June 19, 2013

Post: Minimizing Downtime from Lengthy AWS Outages

… in AWS is the region.  They are geographically isolated in different physical data centers around the … on another instance and simply fire up MySQL.  This works wonderfully unless EBS is the … analogy). Multi Region Replication The easiest approach would be to use native replication from a master …

Post: State of MySQL Market and will Replication live ?

… scale MySQL and get some HA out of the box even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD…, CouchDB which comes computed with Cloud Computing and dealing with geographically distributed very large scale systems. This is the area where…

Comment: Finding your MySQL High-Availability solution – The questions

… internal Replication. 2.4 I think it worth pointing out NDB is less than ideal if one needs to replicate to geographically dispersed location. There are way to get around this (external replication…) but this introduces even… communication is in the clear. 2.9 The MySQL database does not replicate with cluster. Need to add a user or update…

Comment: Product to try: MySQL/MariaDB-Galera 0.8

I’ve setup a 3 node Galera cluster with 2 mysql proxy nodes in my testbed and have been really, really… candidate for a new State Snapshot Transfer methods. Does traditional replication work with the 0.8 release, or still a feature… ability to do regular builtin replication is important for geographically-dispersed clusters. The ability to perform async replication to another datacenter, for example…

Comment: Finding your MySQL High-Availability solution – The questions

Great article. I’m wondering how a requirement for geographically distributed servers might impact the choices given. Certainly, having shared … an issue, so the Heartbeat/SAN method becomes problematic. Simple MySQL replication should still work, though you’d have the caveat of…

Comment: Announcement of Percona XtraDB Cluster (alpha release)

… guess the two main differences come from MySQL Cluster doing two things: 1) Separation of MySQL Server and Storage Engine; meaning that… pretty much useless on a geographical scale. What you can do of course is combine MySQL Cluster with replication, but then you’re back to asynch. So all in all, either you design your application for MySQL