I’ve setup a 3 node Galera cluster with 2 mysql proxy nodes in my testbed and have been really, really impressed … to do regular builtin replication is important for geographically-dispersed clusters. The ability to perform async replication to another datacenter, for…
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…_online db1 Now you can check MMM status for the cluster – it should display db2 as active master (“writer”) and db1… must change application to use different IP for MySQL or ensure some load balancer/proxy does this, set read-only manually on…
Comment: Partially OpenSourced
April 15, 2008 By 21 Comments
… on Jeremy’s blog and, it seems, also on yours. MySQL Proxy has never been in a state where it would have…. MySQL fully believes in open source (and also in free software, to be specific) and I would list for instance the Cluster… to the MySQL server (and people can even fork the code if they see a need for it). The MySQL Monitor is…
Comment: Three key things to know about moving MySQL into the cloud.
February 15, 2010 By 11 Comments
… snapshot of an existing slave volume, fire up a new MySQL instance with a volume created from that snapshot, point it… action in very short order. Stick a smart proxy in front of your MySQL cluster, and it can point queries at whatever slave…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
July 24, 2012 By 22 Comments
How do I separate Read and write traffic in typical jdbc web application? There is only one solution to use mysql-proxy to do so ? I would like to use HAProxy because it is highly recommended for Percona Xtradb Cluster.
Comment: MySQL Sizing questions
February 9, 2012 By 4 Comments
… proxy. PHP installed. Apache Server. 2 Database server with the same configuration, but active-pasive controlled by load balancing using HT proxy. MySQL installed. 2 load balancing servers Celeron 2.4 Ghz with 1GB of RAM. (each one) Our cluster solution include…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
January 30, 2008 By 7 Comments
… expect MySQL to be fully enterprise-ready, with clustering/replication/etc, proxying, etc. all being easy to setup, configure and automate. I think MySQL…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
January 31, 2013 By 63 Comments
Hi, I have implemented the HA proxy and with the XtraDB cluster. I was using your B configuration everything seamed to work… but after two days I have find out that certain mysql updates and inserts are not sent to the database by…
Comment: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 19, 2012 By 17 Comments
…We are also working on further optimizations for cluster wide conflicts, more news about this later. … with separately, e.g. by an intelligent proxy, ScaleBase has something to offer here. And… topology, Galera replication gives many benefits over mysql replication. Many projects migrate to G world …
