Migrating from MySQL to PostgreSQL – What You Should Know
Whether migrating a database or project from MySQL to PostgreSQL, or choosing PostgreSQL for a new project with only MySQL knowledge, there are a few things to know about PostgreSQL and the differences between the...
Zero Downtime Network Migration With MySQL Galera Cluster Using Relay Node
Galera Cluster’s automatic node provisioning simplifies the complexity of scaling out a database cluster with guaranteed data consistency. SST and IST improve the usability of initial data synchronization without the need to manually backup the...
Migrating MySQL Database from Amazon RDS to DigitalOcean
In previous blogs (part 1 and part 2), we discussed how to migrate your RDS data into an EC2 instance. In the process, we managed to move our data out of RDS, but we are...
MySQL in the Cloud – Online Migration from Amazon RDS to Your own Server: Part2
As we saw earlier, it might be challenging for companies to move their data out of RDS for MySQL. In the first part of this blog, we showed you how to set up your target...
How to Perform Online Schema Changes on MySQL Using gh-ost
In the previous blog post, we discussed how gh-ost works internally and how it compares to Percona’s pt-online-schema-change. Today we’d like to focus on operations - how can we test a schema change with...
Webinar Replay: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster
Thanks to everyone who attended this week’s webinar; if you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online. Special thanks to Seppo...
Live Database Migration from MMM to MariaDB Galera Cluster
This is a guest post from Igor Shevtsov, a MySQL DBA based in Twickenham, UK. Igor has had the opportunity to deploy and manage different types of high availability MySQL solutions, and we invited him...
Migrating MySQL Galera Cluster to a New Data Center Without Downtime
Are you tired and frustrated with your hosting or cloud provider? Have you seen a constant degradation in service levels and responsiveness? Or was the public cloud a bit too expensive after all, and you’re...