… update, I prefer to use CMAN as recommended. First as we have 2 nodes of 3 running, we should try to not…_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): Slave percona3…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you …temporary table could vanish if the slave restarts and then subsequent queries…the sequence after making certain insert/update/delete operations. If you have… it helped? When I did not use the STRAIGHT_JOIN, the…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
Stephane, how are you coping with bug#69095 (replication fails with GTID enabled and master changes from SBR to RBR) and bug#69135 (mysql.slave_master_info is not updated) ?
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… isn’t really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication… luxury of not blocking the master from taking writes if bandwidth is constrained and the slaves lag for a bit, not so in… server. I could not find a way to migrate an existing unicast cluster to multicast with a rolling update. I believe (but…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… regular MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside transaction. 2. Updates…. Also, if BINLOG_FORMAT is not consistent on master/slave db. 3. CREATE TABLE …. SELECT – It is not supported to perform such type…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump … basics. log_slave_updates is REQUIRED You need to have log_slave_updates enabled on the cluster node acting as async slave for replicated events… normal async replication, an event will not be written to the slave‘s binary unless log_slave_updates is enabled, this is similar to…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… conflict and leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were … to prepared statement execution loop, which does not honor wsrep status codes correctly. Bug fixed #1144911…please report them to our bug tracking system. UPDATE[18-04-2013]: There was a RPM …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL…MySQL 5.5.30-30.2 are available in our online documentation. Bugs can be reported on the launchpad bug tracker. UPDATE… clean RPM installations and not upgrades. We have …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… a player makes an achievement, your application updates this table with a statement like this: UPDATE achievements SET count = count + 1 where… stand-alone MySQL Innodb with asynchronous slaves. We may not think about the tradeoffs, but we’re making them (anyone obsessively testing slave position…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…completed regardless of its state before updating. This caused some problems for some…slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL…regression only affected clean RPM installations and not upgrades. We have pushed the …
