A sneak peek inside the Row Based Replication (RBR) in MySQL 5.6

With MySQL 5.6 coming closer to its release, I got a chance to sneak a look into the Row Based Replication (RBR). 5.6 release of MySQL will be a replication features packed one, and it is for this reason I write  another post on the new enhancements in Row Based Replication(RBR). RBR provides a safe way of replicating between master and slave and thats why RBR enhancements become even more important. RBR in 5.6 is far more optimized than...

Read On

Improving MySQL Slave Performance with Batch Operations

The problem Sometime back a member of the MySQL support team informed us that the slaves are very sluggish, when he tried to run a delete query on the master. "What may be the problem?" we wondered. This is in RBR and its pretty usual that we have slower slaves when using RBR as compared to SBR. We requested for some more details and found that it is something else. It's a problem when a lot of rows are getting modified...

Read On

Scaling out and creating fault tolerant systems with MySQL replication

A few days back, reading the article on the Moore's law, I thought it is not too difficult to extend this for an analogous situation, e.g. the amount of data being cached by a search engine like Google also grows exponentially. With changing times we need to have solution that would adapt to the changing data requirements and availability solutions like virtual infinite scale-out like cloud. Even though virtualization is not exactly a database...

Read On

use test; Select "Hello World" from `Universe`

Hello Folks, I have never been consistent with blogging and most of the time I create a blog hoping that I would  share my thoughts and plans with everyone, but as It has to happen, I neglect it. On this new year I made a resolution that I will work on this blog (actually it was to create one) and maintain it throughout. This blog will be the reflection of my ideas, and an attempt to get a feedback on my work in MySQL replication, together with providing tips and tricks on using MySQL in distributed environment. So, last July I joined...

Read On