Probably most of MySQL users sometime had a situation when they would do changes in MySQL config file without restarting server (may be…. Unlike Apache MySQL service control script does not have “configtest” option so there is no straight way to check MySQL config file for errors… checks options for names which is good sanity check. I would encourage you to run such check after you made changes to your config…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
…. MySQL also does not have option to re-read config file without restarting as some other software so approach to change config file… different from settings set in config file, and unexpected change on restart a frequent problem. pt-config-diff is the tool which… detect such change easily because MySQL Server does not seems to have an easy way to check what was the default value…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… \ attributes IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid… interval=”5s” role=”Master” OCF_CHECK_LEVEL=”1″ \ op monitor interval=”2s” role=”Slave” OCF_CHECK_LEVEL=”1″ primitive reader_vip_1… I had to define: config: The path of the my.cnf file. Remember that Pacemaker will start MySQL, not the regular init…
Post: Fixing MySQL with a comment in the config file
February 4, 2011 By 5 Comments
… the first one. The multiple instances were started through the mysql_multi init script. Perhaps you already know what was wrong…” in the /etc/my.cnf file. Not a [mysqld_multi] config file section, but the text string “mysqld_multi”. It was… Linux distribution this was on; I just checked a recent download, and the official MySQL distribution contains a file called mysqld_multi…
Comment: Innodb Performance Optimization Basics
March 4, 2008 By 69 Comments
… point this out given the recent posting on the about checking MySQL Config files. Keep up the fantastic work. Kirby
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… checked out Apache and network config, etc, and I don’t see anything wrong there. So at this point, it looks like MySQL… port, etc etc. Nothing unusual. Next I check what the MySQL version is, and I check (with the ‘file’ command) whether /usr/libexec… of other things I’ll look at, including checking for default users in the mysql.* tables, running mk-duplicate-key-checker to…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
… Since we know the “instance_id” of the new instance, checking if it is running is easy: done=”false” while [ $done…/ha.d/ha.cf and ask heartbeat to reload its config MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW_INSTANCE…/ha.d/ha.cf and ask heartbeat to reload its config MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW_INSTANCE…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… got a new feature addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http… below will connect to the remote server specified in the config and ensure mysqlbinlog utility is up and running. By default… addition, older logfiles that have been rotated can be checked against the MySQL server’s version if they are the same or…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G…-05-10 04:26:14 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL… to 20 nodes. cd shard-query #generate a config for 20 shards (adjust to your number of …
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 13, 2011 By 37 Comments
…cloning without having to worry about losing config changes, plus it makes reading configs much easier as you can …available across OS releases. I thought I’d double check on my RHN account to see what RH …packages they list are for MySQL 3.23!! The RHEL 6 marketing blurb mentions MySQL 5.1.47, but …
