Tag Info

New answers tagged

0

The way I do it most of the time : bakup, copy to another server and then remove it from the source mysqldump -u db_user -p db_password db_name| gzip > /current/path/for/backups/backup_$(date).sql.gz; #Searching, moving to other server and deleting backup files from source. cd /current/path/for/backups/backup_$(date).sql.gz; for f in *.gz do scp -pr ...


1

If you don't want to store the file at your local machine, you can try something like this: mysqldump -u db_user -p db_password db_name| ssh user@example.com "cat > /path/to/dump.sql" To compress the file before transfer (ssh will also try to compress it's traffic): mysqldump -u db_user -p db_password db_name| gzip | ssh user@example.com "cat > ...


2

You can create a shared folder on destination and mount it on mysql server then give the destination path in the script to that mounted folder. This should work. Alternatively you can initiate a scp connection to copy the conent to destination server.


3

I did have to flush-hosts on the database as well, still puzzling through where the bad connectons came from. You'll have to do that again, soon enough, unless you increase the value of max_connect_errors in the server configuration, because the ELB health checks will be interpreted by MySQL as a bad connection, since ELB connects and disconnects ...


1

It's not generally possible to "forward" a TCP connection. Load balancers terminate the connection from the client and open a new connection to the origin server, so any connection-specific information that the load balancer doesn't collect and pass on to the origin is lost -- most notably the source IP address (often passed to the origin server using the ...


0

After many hours of frustration, I figured out it was a cookie issue. For some reason, only one cookie would be set at a time. Some reinstalling of the VPS later fixed the problem.


0

Considering these three benchmarks, i would choose AMD Phenom II X6 1055T. Intel Core i5 750 vs AMD Phenom II X6 1055T Intel Core i5 750 vs AMD Phenom II X6 1055T AMD Phenom II X6 1055T (95W) vs Intel Core i5-750


0

Similarly to how you cannot change the log file size without re-creating the innodb logs, you also cannot re-specify the ibdata file size without re-creating it. Besides, there is no need to resize it larger since it defaults to an auto-extending file. Here is the relevant bit of the error that tells you this is a problem: InnoDB: Error: ...


0

It actually turned out that other things could be done to improve cluster performance. These two links were useful resources: http://openlife.cc/blogs/2011/august/running-sysbench-tests-against-galera-cluster https://www.percona.com/blog/2013/12/07/linux-performance-tuning-tips-mysql/


1

If you are doing DNAT from outside network to your inside network, the external users can access your internal server using the public IP correctly as you have done. The public IP is NATed to private IP and forwarded to server. However, your internal users will not be able to access the same server using the public IP unless NAT is fixed to allow this too. ...


0

The issue was caused by the IPV6, I disabled ipv6 by adding #disable ipv6 net.ipv6.conf.all.disable_ipv6 = 1 net.ipv6.conf.default.disable_ipv6 = 1 net.ipv6.conf.lo.disable_ipv6 = 1 to /etc/sysctl.conf and there were no more delays.


0

It looks like your logs are corrupted. Try recreating the InnoDB log files by moving the existing ib_logfile(s) out of the way and restarting MySQL. If that doesn't work you're likely to have some data corruption.


0

Thanks for the help @Fox and @Sven, i have now solved the problem. It was a nfs-kernel-server setting, /etc/defaults/nfs-kernel-server contained the option --manage-gids that breaks the usage of secondary groups. So while the mysql user had the right permissions through a secondary group the permissions on the nfs-server's side were wrong. Hope someone ...


0

I've added support for hotcopies to the mysql_manager rubygem, but it only supports hotcopies of the entire mysql directory. It accomplishes this by first doing repetitive rsyncs without table locks until sync duration is tolerable, then obtains a lock using FLUSH TABLES WITH READ LOCK before doing a final rsync. Since it's using rsync, it also supports ...


0

A lot of talk here about security groups, but also check: Do the associated Subnets seem properly configured? Are the Subnets part of a Routing Group that seems properly configured (Internet Gateway specified, etc?) Does the RDS say it's Publicly Accessible? And of course check the RDS Security Group and EC2 Security Group Don't forget your actual source ...


0

Michael, I really appreciate your suggestion. My new table looks like this: :INPUT DROP [0:0] :FORWARD ACCEPT [0:0] :OUTPUT ACCEPT [46:5592] -A INPUT -m rt --rt-type 0 --rt-segsleft 0 -j DROP -A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT -A INPUT -p ipv6-icmp -j ACCEPT -A INPUT -i lo -j ACCEPT -A INPUT -p tcp -m state --state NEW -m tcp ...


0

If you are using nginx php-fastcgi and you got 502 Bad Gateway error than you have to look at your virtual host configuration on nginx config file. You have to set or correct the fastcgi_pass parameter.The fastcgi_pass is the variable to set the socket connection between nginx and php CGI. Another point of issue is that the binary starter script could ...


1

You don't state what engine are you using, but let me presume it's InnoDB (as it's pretty much standard these days) then in MySQL Docs (Using actual symbolic links has never been supported for InnoDB tables.) and The DATA DIRECTORY clause is a supported alternative to using symbolic links, which has always been problematic and was never supported ...


0

Please make sure you have mapped Php-cgi.exe in IIS properly. Check the following resource for more information: http://learn.iis.net/page.aspx/246/using-fastcgi-to-host-php-applications-on-iis7/ Thanks,


-1

Sorry Guys, Its not any server fault but i think the lack of some knowledge about sql. Just go to wamp server in right corner on the taskbar and click the mysql then go to mysql console set there password and window will set and will go disappear. Then go with the file config.nic.php and edit it with username (whatever u like or use already set) and password ...


1

Here is how we do it. This step by step example uses Linux LVM to take a consistent snapshot of the master. If you don't shutdown the master I don't think there is anyway to guarantee a consistent snapshot because MySQL holds cached pages in the memory. http://www.juhavehnia.com/2015/05/rebuilding-mysql-slave-using-linux-lvm.html


0

Here are step by step instruction how to rebuild MySQL slave from the master using Linux LVM snapshots. This is ideal method when you cannot afford much downtime to copy binary files to the slave. There are other ways of doing this but I always question the consistency of the slave. I take my backups from the slave so I absolutely need to make sure that my ...


1

Here are step by step instruction how to do this with minimal downtime using Linux LVM snapshots. http://www.juhavehnia.com/2015/05/rebuilding-mysql-slave-using-linux-lvm.html


4

if you have the password of root of mysql or any user with full controll of mysql, you can use mysqladmin in this way: mysqladmin -u root -p shutdown You can login as root in your server and use the script of your distribution to stop mysql


0

Add the following in your my.cnf [mysqld] skip-host-cache skip-name-resolve These two variables are not global so need to service mysql restart after that If you want to block all connections to port 3306 (MySQL) and allow only those you want $ iptables -N mysql $ iptables -A mysql --src 1.1.1.1 -j ACCEPT $ iptables -A mysql -j DROP $ iptables -I INPUT ...


3

You shouldn't have installed mysql-community-release-fc21-5.noarch in the first place. That RPM is clearly labelled that it's for fedora core 21. yum erase mysql-community-release-fc21-5.noarch. Next you're trying to install mysql-community-release-el5-5.noarch.rpm. Do that and you're back to where you started, with a slightly different error message. ...


0

The minimal requirement to give sufficient rights to a given user (admin here) to be able to grant all privileges on a given DB (db4user1 here) is : GRANT DROP , REFERENCES , INDEX , ALTER , CREATE TEMPORARY TABLES , LOCK TABLES , CREATE VIEW , EVENT, TRIGGER, SHOW VIEW , CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON `db4user1` . * TO 'admin'@'localhost' WITH ...


0

It's look like to me that you want to create just another admin like default root, so you can use simple syntax like that: GRANT ALL ON *.* TO admin@localhost IDENTIFIED BY 'passwd5678' WITH GRANT OPTION;


0

Digging into network traces I found some Name Resolution problems. I'm running 5.1.41 version of MySQL Community Edition. I don't know if this is true for more actual releases, but in this version, "name resolve" feature is enabled by default. With name resolution enabled, each time a network connection starts, MySQL tries to resolve client's PC name from ...


-2

[!520]# mysql --version|awk '{ print $5 }'|awk -F\, '{ print $1 }' Output is : 5.5.41


1

For the above two examples, if you want the "14.14" string: mysql -V | awk '{print $3}' If want the "5.x.x" string: mysql -V | awk '{print $5}' I can't guarantee that the strings will be in the same format across major versions, though. Also, this could probably also be performed with sed and some clever regexing. If you want a check against installed ...


1

Are you experiencing any site performance issues? The thing with Linux is that it's not a bad thing for top to show that all your RAM is in use. Try giving us the output of free -m. When an application is finished with the memory it used, the kernel doesn't immediately purge the pages of data and mark it as free memory again. For instance, my desktop VM I ...


0

WordPress uses a lot of RAM - and cpu. There's not much to do, than to upgrade your server if you want to continue using WordPress. The alternate could be to use another system for your server, or get someone to code your website. In that way, the RAM-usage will not be as high - if the coder does his job right, of course. Not sure if this helped, but that's ...


1

mysqldiff is just telling you that you have a difference between both DB, regarding the DB name : dev_si_brand_new versus prod_si. If you don't want mysqldiff stops at the first difference encountered and continue the comparison, just add the --force argument to your command line : --force Do not halt at the first difference found. Process all ...


1

yes. it will work. copy: /var/lib/mysql/* /etc/mysql/* then you can create another one VM with mysql and copy back the data.


0

Seeing your error for some reason it is trying to use an incorrect unix socket. Try adding to mysql command the parameter -S /var/lib/mysql/mysql.sock.


2

That only applies to TIMESTAMP fields. DATETIME fields are left as-is. See http://dev.mysql.com/doc/refman/5.7/en/datetime.html


0

Latest didn't help. This worked -- Run - pip uninstall mysql-python YAML - libraries: - name: MySQLdb version: "1.2.4" Settings - 'default': { 'ENGINE':'django.db.backends.mysql', 'HOST':'/cloudsql/ProjectName:DBName', 'NAME': 'my_database', 'USER': 'root', 'PASSWORD': '********', }


0

I have found the solution. I added this line to my /etc/ssh/sshd_config file: KexAlgorithms curve25519-sha256@libssh.org,ecdh-sha2-nistp256,ecdh-sha2-nistp384,ecdh-sha2-nistp521,diffie-hellman-group-exchange-sha256,diffie-hellman-group14-sha1,diffie-hellman-group1-sha1 and restarted ssh: systemctl restart ssh as suggested by this post: ...


0

Try node 'your hostname' { class {'mysql::server':} } class mysql::server { package { "mysql-server": ensure => installed } package { "mysql": ensure => installed } service { "mysqld": enable => true, ensure => running, require => Package["mysql-server"], } file { "/var/lib/mysql/my.cnf": owner => "mysql", group => "mysql", source ...


0

You define the mount point, say /etc/storage, for what you are going to use on pp. Put three /// in front of the mount point you define. (fileserver.conf) [fs] path /etc/storage/ allow * (nodes.pp) source => "puppet:///fs/my.cnf",


-1

InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery Whenever database get crashed, we used to get this. Innodb mechanism tries to recover spontaneously. Use innodb_force_recovery to force the InnoDB storage engine to start up If this is happening regularly at the same time check for any cron or any logrotation ...


0

InnoDB: Database was not shut down normally! Seems like some other process on the server is killing mysql process. you might need to check the CPU Load as well. Is your server running out of memory?


2

You should run "prepare" first. It will create the table required for the benchmark. In your case, it should be sysbench --test=oltp prepare


0

If my application had been GPL compatible, I could have used libmysqld. Alternatively I could also paid Oracle for a commercial license. There are also tons of other database systems out there. Since my application isn't too complex, it seems that using a mixture of SQLite and the MySQL Connector (which does not require GPL) might be the best alternative. ...


1

The best way to attack it is to look at http://www.brendangregg.com/linuxperf.html and follow Brendan's advice. Specifically you want his iosnoop tool that will tell you who access the storage the most. But you'll do yourself a big favor if you read through it to learn his thought process and methodologies as that would benefit you a lot in the long term.


1

Is this asking me to create a root password for the server or a separate root password just for mysql? It is asking you to setup a root password for MySQL only. Not a root password for your server OS. MySQL does not take care about operating system root password. It is only interested about its own root password to protect itself.


0

If you can log into MySQL as root@localhost run the following SELECT USER(),CURRENT_USER(); What does this tell you: USER() reports how you attempted to authenticate in MySQL CURRENT_USER() reports how you were allowed to authenticate in MySQL When you got the error Access denied for user 'rootd'@'umhef.ca' (using password: YES) The host part ...


0

Try each of these steps, clear cache, refresh and check From $host = "127.0.0.1"; change to $host = "localhost"; Check whether the default port is 3306 or anything else. Check the process name and port netstat -tln Enable skip-networking (comment out # ) in my.cnf Have a look in /etc/hosts as well to ensure everything is fine there Also --bind-address if ...


3

source is indeed an odd choice, unless your appservers are supposed to have session persistence with DB slaves. That's for you to figure out, though. leastconn is usually a very good choice if performance of each server (both appserver and database) is not absolutely steady. This depends on the details of your application and platform. (E.g., a Java based ...



Top 50 recent answers are included