Troubleshooting MySQL Replication: Part Two
In Troubleshooting MySQL Replication: Part One, we discussed how to verify that MySQL Replication is in good shape. We also looked at some of the typical problems. In this post, we will have a look...
Troubleshooting MySQL Replication: Part One
Replication is one of the most common ways to achieve high availability for MySQL and MariaDB. It has become much more robust with the addition of GTIDs, and is thoroughly tested by thousands and thousands...
Video: 9 Tips to Building a Stable MySQL Replication Environment
This video walks you through nine tips you should consider when deploying and managing a MySQL Replication environment and how utilizing ClusterControl can help make deploying, managing, monitoring, and scaling MySQL easy. Though MySQL replication...
MySQL Replication and GTID-Based Failover – A Deep Dive Into Errant Transactions
For years, MySQL replication used to be based on binary log events - all a slave knew was the exact event and the exact position it just read from the master. Any single transaction from...
Video: MySQL Replication & ClusterControl Product Demonstration
The video below details the features and functions that are available in ClusterControl for MySQL Replication. Included in the video are… How to Deploy Master-Slave Replication How to Deploy Multi-Master Replication MySQL Replication overview including...
How to Secure MySQL/MariaDB Servers
After attacks on MongoDB databases, we have recently also seen that MySQL servers are being targeted by ransomware. This should not come as a surprise, given the increasing adoption of public and private clouds....
MySQL Replication: All the Severalnines Resources
MySQL Replication has become an instrumental part of scale-out architectures in LAMP environments. MySQL offers plenty of solutions when there is a need to scale out, the most common being to add read replicas. Building...
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...
MySQL in the Cloud – Online Migration From Amazon RDS to EC2 Instance: Part One
In our previous blog, we saw how easy it is to get started with RDS for MySQL. It is a convenient way to deploy and use MySQL, without worrying about operational overhead. The tradeoff though...
Video Interview with ProxySQL Creator René Cannaò
In anticipation of this month’s webinar MySQL & MariaDB Load Balancing with ProxySQL & ClusterControl that will happen on February 28th Severalnines sat down with the creator of ProxySQL founder and creator René Cannaò to...
Composing the Stack – Simplify Docker Deployment of MySQL Containers
Docker 1.13 introduces a long-awaited feature called compose-file support, which allow us to define our containers with a nice simple config file instead of a single long command. If you have a look at our...