Severalnines Blog
The automation and management blog for open source databases

Planets9s - Join us next Tuesday: introducing a new Blueprint for MySQL Replication

Posted in:

Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source databases.

Join us next Tuesday: introducing a new Blueprint for MySQL Replication

In this new webinar, we will introduce the Severalnines Blueprint for MySQL Replication - this includes all aspects of a MySQL Replication topology with the ins and outs of deployment, setting up replication, monitoring, upgrades, performing backups and managing high availability using proxies as ProxySQL, MaxScale and HAProxy.

Sign up for the webinar

Read-Write Splitting for Java Apps using Connector/J, MySQL Replication and HAProxy

In this new blog post, we play around with Java, Connector/J, MySQL Replication and HAProxy. And we describe how to manually deploy a MariaDB Replication setup and add it into ClusterControl using “Add Existing Server/Cluster” as well as deploy HAProxy with Keepalived, and create a simple Java application to connect to our Replication setup.

Read the blog

How ProxySQL adds Failover and Query Control to your MySQL Replication Setup

In this new blog post we describe how to set up ProxySQL to work in a MySQL Replication environment managed by ClusterControl. We take a look at the metrics it provides to a DBA, and how this data can be used to ensure smooth operations.

Read the blog

That’s it for this week! Feel free to share these resources with your colleagues and follow us in our social media channels.

Have a good end of the week,

Jean-Jérôme Schmidt
Planets9s Editor
Severalnines AB

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: