… Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make… replication configuration with one master and two slaves, all running MySQL 5.6 with GTIDs disabled. First try: configure only one of… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… the second post of a series of articles focused on MySQL 5.6 GTIDs. You can find part one here. Our goal… 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…
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 only… performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
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…. We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on Linux is available… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Comment: Upgrading MySQL
May 27, 2013 By 24 Comments
… mysql-5.5.11-linux2.6-i686.tar.gz mv mysql-5.5.11-linux2.6-i686 mysql cd mysql chmod root:mysql data/ chown root:mysql data cd /var/lib/mysql/ rm -rf ibdata1 ib_logfile* /usr/local/mysql/ cd…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
Yes, because MySQL 5.6 GTID is fundamentally broken in the design. You don’t … of MySQL 5.6 and MariaDB 10 using GTID. You will be kept plenty busy trying to get even a pure MySQL 5.6…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… max_used_connections=13 max_threads=2002 thread_count=6 connection_count=6 It is possible that mysqld could use up to…+0x3ad)[0x51e34d] /lib64/libpthread.so.0[0x33e0607851] /lib64/libc.so.6(clone+0x6d)[0x33dfee890d] Trying to get some variables. Some pointers…:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
You can replicate from MySQL 5.6 to MariaDB 10.0 or vice versa. You just won’… MariaDB compatible without merging all of the crap that is MySQL 5.6 global transaction ID, I would very much like to…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 27, 2013 By 8 Comments
@Kristian Does it mean that MariaDB 10 is incompatible with MySQL 5.6 GTID? You cannot replicate to/from a MySQL 5.6 host using GTIDs?
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… seen a lot of people setting up clusters with 3-6+ nodes on 1 Gbps networks. 1 Gbps seems like a… mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql…
