… configure the slave to only replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is… can also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If you’re thinking about…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered that innodb_old_blocks… the database optimizer. The SSB benchmark consists of four sets of queries. Each set is known as a “flight”. I have labeled… built the keys with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… and synchronous clusters I’ve seen a lot of people setting up clusters with 3-6+ nodes on 1 Gbps networks… to our my.cnf: wsrep_provider_options = “gmcast.mcast_addr=239.192.0.11″ If you already have wsrep_provider_options set, add… regular IP of the node. Typically I just set the wsrep_node_address setting on each node if this IP is not…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… event executed: s1> show slave status\G [...] Executed_Gtid_Set: 219be3a9-c3ae-11e2-b985-0800272864ba:1, 3d3871d1-c3ae-…the server UUID can be read in the auto.cnf file in the datadir). So the last executed …is a solution of course, but very poor in my opinion: look for the binlog file/position of …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… all versions, ban master-user, master-host and master-password settings in my.cnf, this may cause huge problems (it’s anyway no…, master-password, master-host and master-port in the my.cnf file? # cat my.cnf [...] master-user=rsandbox master-password=rsandbox master-host=127… is probably not what you want. So never set master-xxx variables in my.cnf! From MySQL 5.5 Starting with MySQL 5…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… setting regarding to memory allocation. So we did some memory allocation setting in my.cnf file. On first day after doing memory allocation setting in my.cnf… [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware: Node:2 CPU = Quard Core…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Python clients when plugin-dir option was set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… file (my.cnf). Bugs fixed #1160047 and #1086978 (Raghavendra D Prabhu). Donor node would run XtraBackup indefinitely when xtrabackup tmpdir was set up…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Python clients when plugin-dir option was set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
March 31, 2013 By 8 Comments
… tuned a few variables up with confidence since 5.6 sets them higher by default. Another minor correction: innodb_auto_extend… the mistake of copying the directive and using it in my.cnf which caused some trouble with a restart. 
