In this blog, I will provide a step by step procedure to migrate from on-premise MySQL to Amazon RDS/Aurora using Percona-xtrabackup Both RDS and Aurora is a DBAAS provided by Amazon. To know more on DBAAS you can view our presentation here. When you are having a database in size of few GB, it would … Continue reading Migrate MySQL data to RDS/Aurora Using Xtrabackup
"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
Mydbops team has presented at 15th edition Open source India Conference happened at Bangalore on 12-10-2018. Manosh malai ( Senior Devops/ DB Consultant ) and Kabilesh P R ( Co-Founder Mydbops ) has made presentation on "Evolution of DBA in the Cloud Era". They have shared the value addition that DBA's can bring into any … Continue reading Presentation : Evolution of DBA’s in the Cloud Era
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.