ProxySQL Series: Mirroring MySQL Queries

This is our third blog in the ProxySQL Series MySQL Replication Read-write Split up Seamless Replication Switchover Using MHA This blog post explains one of the very important use case of ProxySQL called Mirroring. Mirroring in ProxySQL is not an equivalent to MySQL replication. Also it does not guarantee data consistency across the servers but still there … Continue reading ProxySQL Series: Mirroring MySQL Queries

Advertisements

ProxySQL Series: Seamless Replication Switchover Using MHA

This is our second blog in the ProxySQL Series ( Blog I MySQL Replication Read-write Split up ). Will cover how to integrate ProxySQL with MHA to handle failover of Database servers. We already have Master - Slave replication setup behind ProxySQL from previous blog [ProxySQL On MySQL Replication] For this setup we have added one more … Continue reading ProxySQL Series: Seamless Replication Switchover Using MHA

ProxySQL Series: MySQL Replication Read-write Split up.

At Mydbops we always thrive to provide the best MySQL Solutions. We are exploring the modern SQL load balancers. We have planned to write a series of blog on ProxySQL. The first blog in this series is  how to set up ProxySQL for MySQL Replication Topology including Read / Write Split and some background over ProxySQL. What … Continue reading ProxySQL Series: MySQL Replication Read-write Split up.

Making Maxscale/ProxySQL Highly Available ( 2 > 1 )

As Mydbops we are implementing Load Balancer using Maxscale or ProxySQL ( Our presentation ) for lot our client,  but these load balancers will become a SPOF (Single Point of failure) .  We have tried to explore services like HAProxy, Nginx, and Keepalived etc. Except Keepalived, all the services need to run on the standalone instance … Continue reading Making Maxscale/ProxySQL Highly Available ( 2 > 1 )