… Linux network interface bonding in balance-rr mode; this is the only NIC bonding mode which will allow you to stripe a…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
….7 the checks will be stricter: in the default SQL mode, a duplicate index will throw a warning instead of a note. In strict mode, it will throw an error and the second ALTER will…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… simulate the problem): [root@percona3 percona]# crm configure property maintenance-mode=true We can see that the resources are unmanaged: ============ Last…: [ percona1 ] Slaves: [ percona2 percona3 ] So if you were in maintenance mode, you should have : [root@percona2 percona]# pcs status Last updated…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… controller write cache use. Even the fairly slow gzip-1 mode works well. The tpcc database, which contains a lot of…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… thread stops because the master has GTID_MODE OFF and this server has GTID_MODE ON, Error_code: 1593 So unfortunately if… thread stops because the master has GTID_MODE ON and this server has GTID_MODE OFF, Error_code: 1593 These simple tests… be able to mix servers where gtid_mode is ON with servers where gtid_mode is OFF. This would greatly simplify the…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
…, as I may have preferences for or against a certain mode of operation that others may not share, so readers may… blacklisting of PIDs or simply running in a “cache everything” mode. Both of them have support for not caching sequential IO…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… of MySQL and Percona Server 5.6 with the GTID mode enabled. Example of how this information can be used to…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… of MySQL and Percona Server 5.6 with the GTID mode enabled. Example of how this information can be used to… failure. Bug fixed #1170806. innobackupex would fail if the SQL_MODE was set to ANSI_QUOTES. Bug fixed #945161. Missing space…
Post: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 6, 2013 By 2 Comments
… /*!50038*/ pt-stalk prints the wrong variable name in verbose mode when –function is used And more The first two bugs…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… fc_master_slave disabled (which it is by default). This mode actually adjusts the fc_limit dynamically based on the number…
