One of my favorite MySQL configurations for high availability is master-master replication, which is just like normal master-slave replication except that you can fail over in both directions. Aside from MySQL Cluster… have to be the tools I used — it could be MySQL Proxy or a TCP sniffer or anything else. But if you…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… one of our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL Master-Master replication manager (MMM) ever… use different IP for MySQL or ensure some load balancer/proxy does this, set read-only manually on standby master so application can…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…master_connect_retryblogpercona.commanual master_hostblogpercona.commanual master_info_fileblogpercona.commanual master_passwordblogpercona.commanual master_portblogpercona.commanual master_retry_countblogpercona.commanual master_sslblogpercona.commanual master_ssl_cablogpercona.commanual master…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… to scale MySQL and get some HA out of the box even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD or… MySQL side we have further development of MySQL Cluster to be more usable for web apps as well as development of MySQL Proxy to…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
…MASTER and all that, why can’t something simple be added into the replication protocol itself. Basically you tell a master to replicate…) – it does require some sort of proxy/middle layer to be able to …s custom scripts, and replication enhancements. It would be nice to see MySQL actually just build …
