… affected (0.25 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table… warning (0.56 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: Duplicate…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who… try! # For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the…. This can even be made easier with mysqlfailover from the MySQL Utilities (this will be the topic of a future post…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…: ms_MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2..._MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5
May 28, 2013 By 1 Comment
… UTC), I will be presenting a webinar entitled, Choosing a MySQL HA Solution, in which we’ll explore the topic of…. We will then explore some of the more well-known MySQL HA tools and technologies available today (largely grouped into those which use traditional MySQL replication, those which use some other MySQL-level replication, and those which replicate at…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… server can easily handle the write load of all the MySQL instances. The original idea was to configure them with raid… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a… STATUS? Look at the last field, Auto_Position: # Slave #1 mysql> show slave status\G [...] Auto_Position: 1 -> GTID-based positioning # Slave #2 mysql> show slave status\G [...] Auto_Position: 0 -> File-based positioning Conclusion…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 3 Comments
…’t have to export databases, you can use the existing mysql data dir. But check http://www.percona.com/doc/percona…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… large innodb database, do I have to export databases from mysql and import them in Percona server or can I use…? 2. What’s the advantage of using Percona server over MySQL? 3. I am using CentOS for my servers but i…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
It may not be easy to simply switch from regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE…
