Severalnines Blog
The automation and management blog for open source databases

New Whitepaper: MySQL Replication for High Availability

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

Online schema change with gh-ost - throttling and changing configuration at runtime

When performing schema changes online, it is important to be able to control the performance impact on our running databases. This blog post discusses gh-ost’s throttling mechanism. We will also cover the runtime configuration changes that gh-ost allows.

Posted in:

How to perform online schema changes on MySQL using gh-ost

This blog post shows you how to use GitHub’s gh-ost to perform an online schema change on a MySQL master-slave replication setup.

Posted in:

Planets9s - 2016’s most popular s9s resources

Planets9s is a weekly communication on all the latest Severalnines resources and technologies around automation and management of open source databases such as MySQL, MariaDB, PostgreSQL & MongoDB.

Posted in:

How to Perform Efficient Backup for MySQL and MariaDB

There are a number of ways to backup MySQL and MariaDB, each comes with pros and cons. An effective backup strategy will depend on the requirements of the business, the environment you operate in, and the resources at your disposal.

Posted in: