… 100MBps. By default Galera uses unicast TCP for replication. Because synchronous replication needs to replicate to all nodes at once, this means 1… more the bandwidth required for replication multiplies. Now, this isn’t really much different from standard mysql replication. 1 master with 5 async…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… than with file-based replication. We will see how to change the replication topology when using GTID-based replication. That will show where…’t want to break replication or corrupt your data. Scenario #2: One of the slaves is behind Now let’s imagine that… with GTIDs, you cannot totally forget old-style replication positioning. Conclusion Reconfiguring replication when using GTIDs is usually straightforward: just connect the…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… in it, Percona Server 5.5.31-30.3 is now the current stable release in the 5.5 series. All… and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log with an incorrect…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
If you are using Percona Replication Manager (PRM) with RHEL/CentOS prior to 6.4, upgrading …_validate -f /etc/cluster/cluster.conf Configuration validates We can now copy the configuration file on all nodes: [root@percona1 ~]# scp… —— —- —- —— percona1 1 Online percona2 2 Online percona3 3 Online, Local Now the cluster is fixed and everything works again as expected…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…, I’ve used Xtrabackup simply to clone a server (for replication or migration) or migrate an existing schema to a new…. Fortunately, this can be done easily using mysqldump –no-data. Now, enough with the theory, here is the procedure I used… name) using –include=”^orig[.]“ (i.e. functional partitioning) Combine with –replicate-rewrite-db Daily backups from production to staging with different…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… more detail about using pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL… an event you can’t afford to miss… 
So register now! Please also join the Portland MySQL Meetup group for more…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…_smm.so(galera_recv+0×23)[0x7f9337da4c13] /usr/sbin/mysqld(_Z25wsrep_replication_processP3THD+0x4b)[0x595edb] /usr/sbin/mysqld(start_wsrep_THD+0x3ad…. 130528 09:53:56 mysqld_safe Number of processes running now: 0 130528 09:53:56 mysqld_safe WSREP: not restarting…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually much…_id, group_id, joined) VALUES (100, 1, NOW()); Conclusion Choosing a system to replicate your data to a distributed system requires tradeoffs…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… weighted sum over group members. Percona XtraDB Cluster binary will now be bundled with the libjemalloc library. For RPM/deb packages… (Alex Yurchenko). Cascading foreign key constraint could lead to unresolved replication conflict and leave a slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep recovery, this would lead…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… (bugs 1090145, 1102687) * Added UTC option to pmp-check-mysql-replication-delay to be compatible with pt-hearbeat 2.1.8… error on directory permissions issue (bug 1024001) * pmp-check-mysql-replication-running reported OK when a slave is in “Connecting” state…
