Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
215 blog posts in 13 categories

MySQL Replication and GTID-based failover - A Deep Dive into Errant Transactions

This blog post covers deployment of replication cluster using ClusterControl. It also discusses in-depth a concept of errant transactions, how to detect them and how to fix issues related to them.

How to Secure MySQL/MariaDB Servers

This blog post covers a number of tips to protect and secure your MySQL/MariaDB servers from threats and attacks.

MySQL in the Cloud - Online Migration from Amazon RDS to your own server (part 2)

It's challenging to move data out of RDS for MySQL. We will show you how to do the actual migration of data to your own server, and redirect your applications to the new database without downtime.

MySQL in the Cloud - Online Migration from Amazon RDS to EC2 instance (part 1)

RDS for MySQL is easy to get started. It's a convenient way to deploy and use MySQL, without having to worry about any operational overhead. The tradeoff though is reduced control.

MySQL & MariaDB load balancing with ProxySQL & ClusterControl: introduction webinar

We’re delighted to be joined by ProxySQL’s creator, René Cannaò, to tell us more about this new MySQL & MariaDB load balancing proxy and its features. We will also show you how you can deploy ProxySQL using ClusterControl.

MySQL in the Cloud - Pros and Cons of Amazon RDS

Moving your data into a public cloud service is a big decision. All the major cloud vendors offer cloud database services, with Amazon RDS for MySQL being probably the most popular. In this blog, we’ll have a close look at what it is, how it works, and compare its pros and cons.

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.

What’s New in ClusterControl 1.4 - Backup Management

This blog post covers the new backup features available in ClusterControl version 1.4.

ClusterControl Tips & Tricks: How to Manage Configuration Templates for your databases

ClusterControl comes with a set of configuration template files to simplify deployments. This blog post provides an overview of these configuration templates, and how to best make use of them.

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.