… my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5.6, based…with 5.6 if you’re not using GTID-based replication. If you are using GTID-based replication, it… a safe bet that MySQL is up and running. That said, there are plenty of other MySQL and OS…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… it incorrectly. So how do you safely disconnect a replication slave? In short For MySQL 5.0 and 5.1, run STOP SLAVE, CHANGE MASTER TO MASTER_HOST=” and then RESET SLAVE. For MySQL 5.5… difference between RESET SLAVE and RESET SLAVE ALL, disconnecting a replication slave is much easier with MySQL 5.5+.
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…Alexey Bychko). The mysqld_safe script would fail to retrieve the Galera replication position on Ubuntu 10…unresolved replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication …free. Release notes for Percona XtraDB Cluster 5.5.30-23.7.4 are available …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s … in between the statements that is not safe to retry after the database state changes. … that logic (I usually get less than 5 people who do out of 100). But, …
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… – Upgrade of MySQL 5.0.30 to 5.0.32 is generally likely to expose less issues than 5.0.30 to 5.0.86…. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL 5.0 database with MySQL 5.1… into some replication bug – in any case you need to take care about these if you’re to be safe. Adding the…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… any significant development since MySQL 4.1, so in-place upgrade of MySQL 5.0 to MySQL 5.5 should be rather safe from data standpoint. There… of specific issues might be making MySQL Replication to work. You might need to inject MySQL 5.0 in between so it will convert… do staged upgrades for your replicated setup or plan some downtime for upgrade. Q: Upgrading to MySQL 5.5 do we really need all…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… up with inconsistent database, broken replication and other problems. I should note semi-synchronous replication available in MySQL 5.5 does not solves these problems… as requirement with “guarantees” cluster provides – such as it is safe to read and write from any node and application will…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
… MySQL University in Raleigh,NC, Tuesday 29th of January I have created the outline of improvements available in MySQL 5… – Crash Safe Slave and Binlog – Replication Event Checksums – Time Delayed Replication – Server UUID – Improved Logging for Row based Replication – Replication Utilities …
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… row-based replication in MySQL 5.1 and later, but most installations I know of are using statement-based replication, even on MySQL 5.1 This… one transaction on the master, the temporary table was not safe for replication. I’m pretty sure this is a bug. The… MySQL statement-based replication without some risk of breaking slaves. At some point I may test how it works with row-based replication…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… you’re only using Innodb tables your replication is not completely crash safe – if Slave MySQL Server crashes/power goes down it is… pausing replication (so you can get consistent master position). It is all great but it does not work any more in MySQL 5… thing works. Until this issue is fixed getting Crash Safe replication with MySQL is not impossible but surely more complicated and has much…
