ProxySQL Series : Percona Cluster/MariaDB Cluster (Galera) Read-write Split

ProxySQL is the most preferred and is widely used for load-balancing MySQL workload, thanks to Rene Cannon & Team for the great tool, and kudos on the recent release of ProxySQL 1.4.10, with a lot of bug fixes. ProxySQL is simple in design, lightweight, highly efficient and feature rich, We have been working with ProxySQL … Continue reading ProxySQL Series : Percona Cluster/MariaDB Cluster (Galera) Read-write Split

Advertisements

Back to basics: Isolation Levels In MySQL

In this blog, we will see the very basic thing "I" of "ACID" and an important property of Transaction ie., "ISOLATION" The isolation defines the way in which the MySQL server (InnoDB) separates each transaction from other concurrent running transaction in the server and also¬†ensures that the transactions are processed in a reliable way.¬†If transactions … Continue reading Back to basics: Isolation Levels In MySQL

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

Mongodb sharded cluster – basics

To scale any databases beyond a limit it data has to be sharded ( Distributed ). MongoDB as a document store has inbuilt sharding. 1. Sharding: Sharding is a method for distributing data across multiple machines. MongoDB uses sharding to support deployments with very large data sets and high throughput on read and write operations. … Continue reading Mongodb sharded cluster – basics