June 18, 2013

Post: MySQL Limitations Part 1: Single-Threaded Replication

… the solution that’s least evil. Why isn’t there multi-threaded replication? I think that a) it’s not as easy… that it would allow a replica to subscribe to multiple masters, which is currently impossible. These solutions represent different types of… have to default to single-threaded as replication currently does, and only enable the multi-threaded behavior if the user configures it…

Post: Announcement of Percona XtraDB Cluster (alpha release)

….17 Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to any node… and includes Write Set REPlication patches. It uses the Galera library, version 2.x, a generic Synchronous Multi-Master replication plugin for transactional applications…

Comment: MySQL Master-Master replication manager released

… me on how the MySQL Multi Master replication model is working or how it is different from a Master – Slave replication in terms of the latency since both are asynchronous. How in the Master Master replication the latency is…

Post: Percona XtraDB Cluster 5.5.20 - Beta release

… Cluster. Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You can write to any node. Parallel applying events on slave. Real “parallel replication”. Automatic node provisioning…

Comment: Converting Character Sets

In a multi-master replication setup, if I broke replication and ran this script on the passive master, then started replication from active->passive, would the queries fail or do other unwanted things? Are the binary logs charset-sensitive during replication?

Comment: How SHOW SLAVE STATUS relates to CHANGE MASTER TO

Am Using Multi master Replication, and everything works great The problem is when a failure happens or connection is lost , replication does not recover automatic I think its because the slave Position changes and i have to stop slaves and show master positions again then retype the change master into and insert there new values again…

Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

Well, there is galera’s synchronous multi master replication around, which works quite nice. Is there any approach to …’t need to keep struggling with asynchronous replication which can break your cluster when you want to migrate your clusters Master-IP.

Post: State of the art: Galera - synchronous replication for InnoDB

… Percona Performance Conference 2009, Seppo Jaakola was presenting “Galera: Multi-Master Synchronous MySQL Replication Clusters”. It was impressed as I personally always wanted… developments in computer science to produce fast and scalable synchronous replication solution that “just works” for databases and similar applications”, which…

Comment: Making the impossible: 3 nodes intercontinental replication

… I missing something? Please point me to the single-LAN, multi-node, multi-master replication numbers if that post (or another) has them. Thanks.

Comment: Understanding Multi-node writing conflict metrics in Percona XtraDB Cluster and Galera

… this blog. From what you say: “Writesets (or “transactions”) are replicated to all available nodes in the cluster on commit (and….mysqlperformanceblog.com/2012/01/19/percona-xtradb-cluster-feature-2-multi-master-replication/, the diagram is similar to http://www.codership.com/wiki…