Severalnines Blog
The automation and management blog for open source databases

New Whitepaper: MySQL Replication for High Availability

Severalnines
Posted in:

MySQL Replication is probably the most popular high availability solution for MySQL, and widely used by top web properties like Twitter and Facebook. Although easy to set up, ongoing maintenance like software upgrades, schema changes, topology changes, failover and recovery have always been tricky. At least until MySQL 5.6.

Having recently discussed deployment and management of MySQL replication topologies, we’re now making this handy whitepaper available to all those of you who are currently working with or intending to work with MySQL Replication.

Our new whitepaper covers all you need to know about MySQL Replication, including information on the latest features introduced in 5.6 and 5.7. It also provides a more hands-on, practical section on how to quickly deploy and manage a replication setup using ClusterControl.

More specifically, the following topics are discussed:

  • What is MySQL Replication?
  • Topology for MySQL Replication
  • Deploying a MySQL Replication Setup
  • Connecting Application to the Replication Setup
  • Failover with ClusterControl
  • Operations: managing your MySQL Replication Setup
  • Issues & troubleshooting

To download your free copy of this new whitepaper, click here.

Related Post

MongoDB Webinar - How to Secure MongoDB with ClusterControl

With authentication disabled by default in MongoDB, learning how to secure MongoDB becomes essential. In this webinar we will explain how you can improve your MongoDB security and demonstrate how this is automatically done by ClusterControl.

MySQL on Docker: Composing the Stack

Docker 1.13 introduces a long-awaited feature called Compose-file support. Compose-file defines everything about an application - services, databases, volumes, networks, and dependencies can all be defined in one place.  In this blog, we’ll show you how to use Compose-file to simplify the Docker deployment of MySQL containers.

Posted in:

How to deploy and manage MySQL multi-master replication setups with ClusterControl 1.4

MySQL replication, while simple and popular, may come in different shapes and flavors. Master slave or master master topologies can be configured to suit your environment.  ClusterControl 1.4 brings a list of enhancements to deploy and manage different types of MySQL replication setups. This blog outlines the different topologies that can be deployed, the merits of each topology, and shows how each can be managed in a live environment.

Posted in:

Automatic failover of MySQL Replication - New in ClusterControl 1.4

MySQL replication setups are inevitably related to failovers - what do you do when your master fails and your applications are not able to write to the database anymore? Automated failover is required if you need to quickly recover an environment to keep your database up 24x7. This blog post discusses this new replication feature recently introduced in ClusterControl 1.4.

Posted in: