… replication is the most common way to do it. The Continuent Tungsten Replicator is the most known alternative product. There is Galera replication (synchronous) in development. DRBD is somethat replication, if you need it for high availability – replication…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… Yves Trudeau, you may have heard about Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona… Corosync / Pacemaker that take cares of MySQL and manages the replication. Corosync allows any number of servers to be part of…
Post: Percona MySQL University comes to Toronto on March 22
February 18, 2013 By 2 Comments
… start of the week so we had many speakers available. Specifically the MySQL High Availability, Replication, Clustering are getting a lot of coverage. Special…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… case – you got pair of servers replicating as Master-Master which you typically want for high availability and online schema changes. How far… things like analytics. High Availability The trick with high availability is the more complex architectures and processes you use for high availability prevention the more likely… beyond the need. You may start with couple of replicated nodes for high availability and maintenance if you’re in serious business (and…
Post: Minimizing Downtime from Lengthy AWS Outages
October 24, 2012 By 7 Comments
… clients architect and deploy highly available systems designed with disaster recovery in the cloud. Here are a few high level best practices that… can be combined to create a highly available architecture. While Amazon claims that issues in a single Availability Zone should have no impact… the real gear analogy). Multi Region Replication The easiest approach would be to use native replication from a master to a slave…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… attempt to scale replication) or was a poor choice, with adding memory or SSD being a better choice. High Availability Some people are… storage. If you want SAN like high availability I would highly consider DRBD which can do storage level replication between directly attached volumes. Now…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 11 Comments
… announce the availability of the GA release of our new product Percona XtraDB Cluster. Percona XtraDB Cluster is a High Availability and Scalability… 1: High Availability Percona XtraDB Cluster Feature 2: Multi-Master replication Create 3 nodes XtraDB Cluster in 3 minutes Benchmarking Galera replication overhead Percona…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… my favorite MySQL configurations for high availability is master-master replication, which is just like normal master-slave replication except that you can fail… usual. However, if you do this you actually compromise your high-availability plan a little, because you can mask the lack of…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
… and High Availability ? Come to Percona Live NYC taking place Oct 1-2 and learn about many state of the art high availability solutions for MySQL such as Clustrix, Tungsten Replicator, PRM, Percona XtraDB Cluster, MySQL and…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
…writes a lot of queries. High Availability Tutorials One of the clearly emerging themes this year is High Availability, though honestly I’m not…tutorials: Using Tungsten Replicator to solve replication problems (3 hr) Ramp-up tutorial for MySQL Cluster – Scaling with continuous availability (6 hr) …
