… and complex procedure. Lets now compare it to MySQL Replication based solution. With MySQL Replication you have to have one Master node which handles… case which allows to use simple solutions such as HA Proxy with these technologies – node is either part of the cluster… for setting up HA solution for MySQL check out synchronous replication based solutions in additionally to MySQL Replication based solutions. I would especially point…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… cross shard queries become a pain. Dealing with lag in MySQL Replication is another issue which complicates application development. All of it… scale MySQL and get some HA out of the box even on the medium level. Seriously – MySQL Cluster, Continuent, Master-Master Replication, DRBD… MySQL side we have further development of MySQL Cluster to be more usable for web apps as well as development of MySQL Proxy to…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL ….commanual proxy_userblogpercona….replicate_do_dbblogpercona.commanual replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_rewrite_dbblogpercona.commanual replicate_same_server_idblogpercona.commanual replicate…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… 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: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
…for environments that use traditional MySQL asynchronous replication. edit: PXC is really a bit like semi-synchronous replication, in that changes are … Hello, was there any good experiences with MySQL Proxy (RW-splitting)? A: Most solutions with MySQL Proxy I see have stern disclaimers against using…
Comment: How does MySQL Replication really work?
February 26, 2013 By 9 Comments
Raghunandan, – I’m not sure MySQL Proxy is ever going to go GA 
Although we were using … than by table and/or schema available in the stock MySQL, so you are definitely looking at something outside the box… not quite sure yet how one would engage mysql-proxy or sql relay in filtering replication traffic.. Either way, let me know if…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
I’ve setup a 3 node Galera cluster with 2 mysql proxy nodes in my testbed and have been really, really impressed…/bug? In my mind the ability to do regular builtin replication is important for geographically-dispersed clusters. The ability to perform async replication to another datacenter, for example, would be valuable in some…
Comment: Master-Master or Master with Many Slaves
December 6, 2010 By 7 Comments
… three posts series: – MySQL Load-Balanced Cluster Guide – Part 1 – setting up the servers themselves and configuring MySQL replication. – MySQL Load-Balanced Cluster… status of your MySQL cluster nodes, which we’ll use in the next guide to set up our proxy. – MySQL Load-Balanced Cluster…
Post: Announcing Percona XtraDB Cluster 5.5.27-23.6
September 7, 2012 By Leave a Comment
… Cluster has implemented ability to have a MySQL Utility user who has system access to… improved “clustercheck.sh“ script which makes a proxy (ie HAProxy) capable of monitoring Percona XtraDB… No other SQL statement except INSERT…SELECT would replicate if /!99997/ comment was present. Bug fixed #…
Comment: How does MySQL Replication really work?
February 26, 2013 By 9 Comments
Hello Aurimas, Is it possible to tweak replication and replicate only inserts from master and ignore the rest of the …… Any ideas would be great help I thought of using mysql proxy, but its still not GA… Thanks, Raghu
