… decided to use the following strategy. Start with a clean MySQL install so that Innodb tablespace id is set to 1 Import… connectivity, I fired up an Ubuntu 10.04 EC2 instance, installed MySQL and provided the customer the credentials to upload their files… Bash script: #!/bin/bash CURRENT_ID=1 mysql -u root “create database if not exists filler;” while [ 1 ] do CURRENT_SPACEID=`mysql -u…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… script (such as the one that ships by default with many server installations) or a system administration mistake to delete one of MySQL…. A variety of problems can delete MySQL‘s PID file, such as a buggy init script that attempts to start the server… missing, then many init scripts will behave very badly. Sample problems include starting two instances of MySQL on the same files in…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… decided to use them for benchmarking. On the desktop, I installed Percona-Server-11.2 which I configured with the following… of the Desktop. This script uses a PHP script, make_conn.php, to generate the idle connections. This script is the following: Before… never above 10%. I also hacked a bit the “run_mysql.sh” script to allow more processing threads (100) instead of the…
Post: Percona Server 5.1.56-12.7
April 18, 2011 By Leave a Comment
…) Added helper script README-Solaris for building on Solaris. (Vadim Tkachenko) Changes were made to the post-install messages (Ignacio … running mysql_install_db after installation or upgrade, in order to avoid “permission denied” error when starting ”mysqld”. (Aleksandr Kuzminsky) MySQL bugs …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… local virtualbox instance, and I tried to show the minimal installation required for XtraDB cluster. Unfortunately enough, I didn’t include… asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I installed Percona as cluster database working with… is blocking, since it is backed up by the wrapper script called innobackupex, and not xtrabackup itself while holding a lock…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what …the replication traffic. An interesting thing to note – scripts can hurt replication traffic well after they are… with you in SAN, NAS or Cloud installations. It all can be the cause of the…
Post: Rebuilding MySQL with same options
April 8, 2010 By 4 Comments
… compilation options as possible if original build scripts are not available ? MySQL distribution has a great script called mysqlbug which was supposed to…=c++’ ‘build_alias=amd64-portbld-freebsd7.0′ Assuming MySQL was properly built and installed these are configuration options it was built with…
Post: Debugging MySQL SSL problems
November 8, 2012 By Leave a Comment
… learned somethings about MySQL SSL today that I thought would be worth sharing. I was setting up a PRM install for a…] ssl-key=/etc/mysql/ssl/server-key.pem ssl-cert=/etc/mysql/ssl/server-cert.pem ssl-ca=/etc/mysql/ssl/ca-cert… script to build the chroot directories, I finally got what I had been looking for: # mysql –ssl-ca=/data/mysql/etc/mysql/DigiCertCA.pem … mysql…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… cluster manager A Pacemaker configuration A MySQL resource agent Here I will not cover the Pacemaker installation since this is fairly straightforward and covered elsewhere. I’ll discuss the MySQL resource agent and the… will start MySQL, not the regular init.d script pid: The pid file. This is use by Pacemaker to know if MySQL is…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… xinetd to daemonize the script. If xinetd is not installed yet, you can install it with yum. # yum -y install xinetd The servie itself… –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp…
