Presentation : MySQL Load balancers and its solution

MySQL load balancers becomes a trend setters in Market for High availability and Scalability. They offer variety of solutions for database. What can be the best load balancer ? It varies from case to case. This presentation was made at Mydbops meetup on 04-08-2018 covers the basics of load balancers with their advantages/ disadvantages and … Continue reading Presentation : MySQL Load balancers and its solution

Advertisements

ProxySQL Series: Handling resource expensive(bad) Queries in MySQL

This is our fourth blog in the ProxySQL Series MySQL Replication Read-write Split up Seamless Replication Switchover Using MHA Mirroring MySQL Queries This blog focuses on how to quickly find and address badly written queries using ProxySQL without any downtime and change in application code. When we get an incident about the high usage on … Continue reading ProxySQL Series: Handling resource expensive(bad) Queries in MySQL

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

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 )