… errors in a server’s my.cnf file. I do this when I need to shut down and restart the server, and I… syntax error. The trick is to examine the currently running MySQL server’s command-line from ps -eaf | grep mysqld, and…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… back to old value upon restart. MySQL also does not have option to re-read config file without restarting as some other software… from settings set in config file, and unexpected change on restart a frequent problem. pt-config-diff is the tool which… in my.cnf to those server is currently running with. The problem however this only works well if settings are set in my.cnf…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… a defined threshold, the reader VIP(s) is removed. MySQL is not restarted. If no slaves are ok, all VIPs, readers and… \ attributes IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid” \ socket… Pacemaker to know if MySQL is already running. It should match the my.cnf pid_file setting. socket: The MySQL unix socket file replication…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… “root” to “mysql“). Before you embark on enabling core file you should consider two things – disk space and restart time. The core file will dump all MySQL Server memory content including buffer pool which… files. First you need “core-file” option to my.cnf which will instruct MySQL to dump core on crash. This alone will unlikely…
Comment: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… the value of the dynamically set variable prior to server restart — something that otherwise gets completely lost. +1 to everything said… the server (I hate hunting them down). Is it /etc/my.cnf? /etc/mysql/my.cnf? /usr/local/mysql/data/my.cnf? /var/lib/mysql/my.cnf?
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data) or # ~/.my.cnf to set…, unless you shutdown # the slave server, delete master.info and restart the slaver server. # For that reason, you may want to…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
… of starting MySQL, Pacemaker invokes a script to start (or restart) the EC2 instance running MySQL. This blog post describes the instance restart script… ‘s/bind-address/#bind-address/g’ /etc/mysql/my.cnf sudo service mysql restart sleep 5 /usr/bin/mysql -u root -proot -e “grant all on…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… machine and you forget to change the server-id in my.cnf. You change the server-id interactively, this is an action…… it was always 1 !! There was a hidden character in my.cnf that was unvalidating the value and then it was set… that the looping statements have been executed) and slave is restarted on mysql 1 Note: you can also check all the statements…
Post: Percona Server 5.5.13-20.4 Stable Release
July 1, 2011 By 3 Comments
… available here and from the Percona Software Repositories). Based on MySQL 5.5.13, Percona Server Percona Server 5.5.13… the LRU Dump/Restore patch which provides similar improvements in restart performance. Replacement is due to SHM buffer pool both being… has the advantage of also persisting across machine restarts. The configuration variables for my.cnf have been kept for compatibility and warnings will…
Post: Is DNS the Achilles heel in your MySQL installation?
May 31, 2008 By 16 Comments
Do you have skip_name_resolve set in your /etc/my.cnf? If not, consider it. DNS works fine, until it doesn…_resolve in your my.cnf file and restart MySQL. But before you do that, run the following command: mysql> SELECT user, host FROM mysql.user -> WHERE host ‘localhost’ AND host RLIKE ‘[a-z]‘; +——+——–+ | user | host | +——+——–+ | foo | my.com | +——+——–+ Any…
