"Delayed replication" is one of the important features which were being supported in MySQL from 5.6 for a very long time. This induces an intentional lag in the slave, making it lag by the defined time interval. For a long time this was not available with the RDS version of MySQL provided by AWS, Recently … Continue reading Delayed Replication with Amazon RDS
Schema change is one of the crucial tasks in MySQL with huge tables. Schema change can cause locks. What is gh-ost? gh-ost is a triggerless online schema change for MySQL by Github Engineering .It produces light workload on the master during the schema changes . We need online schema change to alter a table … Continue reading GH-OST for MySQL Schema Change.
In our work, We used to get a lot of requirements for replicating data from one data source to another.Previously I wrote replication from MySQL to Red-shift. In this blog I am going to explain about replicating the data from MySQL to Oracle using Tungsten replicator. 1.0. Tungsten Replicator : It is an open source … Continue reading Replicating data from MySQL to Oracle
MySQL replication has evolved a lot in 5.6 ,5.7 and 8.0. This presentation focus on the changes made in parallel replication. It covers MySQL 8.0. It was presented at Mydbops database meetup on 04-08-2016 in Bangalore.
The world of application and its related services are migrating more towards cloud, because of availability, Elasticity, Manageability etc. While moving the entire stack we need to be very cautious while migrating the database part. Migration of DB servers is not a simple lift and shift operation, Rather it would require a proper planning and … Continue reading Database Objects migration to RDS/ Aurora (AWS)
In our work, We used to get a lot of requirements for replicating data from one data source to another. Our team provided solutions to replicate data from MySQL to Vertica, Amazon Redshift, Hadoop. Out of which Amazon Redshift replication is a bit complicated as Amazon Redshift is a Database as a service (DBaaS) and the … Continue reading MySQL to Amazon Redshift Replication.
This is the 5th blog in series of Maxscale blog, Below is the list of our previous blogs, Which provides deep insight for Maxscale and its use cases for different architectures. Scale with Maxscale part -1 (Intro & Galera Cluster) Scale with Maxscale part - 2 (Administration, Installation & operation) Scale with Maxscale part - … Continue reading Scale-with-Maxscale-part5 (Multi-Master)
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
Multi-channel replication is one of the great feature shipped with MySQL 5.7, With allowed the capability of slave to have many masters, having a channel for each master by which they replicate. Each channel id has a unique “channel_name” In the above DB Architecture “channel_1, channel_2 and channel_3” represent the channel_name used for replication from … Continue reading Disabling Multi-Source Replication in MySQL 5.7