… Server 12.04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql 5.5 the statement “CHANGE MASTER TO MASTER_HOST=” ” will make an error and stop this script. As I can see, Yves fixed this in his the last version on gitub. But in my MySQL – installation a…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
…It really makes sense to test it under MySQL workload, but before getting to that, let …but this is the one that has biggest installation base. Driver information: Fusion-io driver version: ….js”;fjs.parentNode.insertBefore(js,fjs);}}(document,”script“,”twitter-wjs”); mbgc=’f5f5f5′;ww=’320′;mbc=’…
Comment: Making the impossible: 3 nodes intercontinental replication
March 21, 2012 By 25 Comments
… run the script, it gives me this error message: “mysql_install_db: command not found” I’m not able to find mysql_install_db anywhere… I install Percona server: http://www.percona.com/doc/percona-server/5.5/installation.html on these images before running this intercontinental script?
Comment: Making the impossible: 3 nodes intercontinental replication
March 21, 2012 By 25 Comments
… get the script working. Just need to ADD these two lines: yes | yum -y remove mysql-libs yes | yum -y install Percona-XtraDB-server Percona-XtraDB-client right BEFORE: yes | yum -y install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client and then the mysql_install_db will be installed properly.
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
…streaming backups were performed by the innobackupex script but incremental backups were done by … topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, … and tools around it: Percona XtraBackup: install, usage, tricks tutorial, Tuesday 10th April Introducing…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
March 15, 2012 By 37 Comments
… just write sane install and init scripts for MySQL? The most annoying for me part in Debian/Ubuntu is the /etc/mysql/debian-start… the ‘check_for_crashed_tables’ function (found in /usr/share/mysql/debian-start.inc.sh) which, among other things, does nasty… start in /etc/init.d/mysql. I regret to say, but Percona’s edition of those scripts also includes those questionable features…
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
… to write not about MySQL Server upgrade process but rather about my experience with RPM scripts used during install and upgrade. These are…. mysql user removed I’m not sure if this one is done by RedHat uninstall script or MySQL install script but simply I find no mysql user after upgrade. MySQL Does not start after upgrade…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
…MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL… -a’ would cause MySQL to shut down. The MySQL package scripts for Debian force MySQL stop/start …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
… well commented. The example settings file should work for most MySQL installations which allow connections as root with no password from localhost… message “setup completed” otherwise. Verify installation The binary log stores it progress in a metadata table: $ mysql -e ‘select * from flexviews.binlog…. Starting the background process: FlexCDC includes a consumer_safe.sh script that will start up a copy of FlexCDC and restart…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 7 Comments
… 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…
