Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Schema changes in Galera cluster for MySQL and MariaDB - how to avoid RSU locks

This post shows you how to avoid locking existing queries when performing rolling schema upgrades in Galera Cluster for MySQL and MariaDB.

Sharding MySQL with MySQL Fabric and ProxySQL

This blog post shows you how to set up a sharded MySQL setup based on MySQL Fabric and ProxySQL.

How to set up read-write split in Galera Cluster using ProxySQL

This blog shows you how to setup read-write split in Galera Cluster using ProxySQL. It also covers some limitations that we found at the time of writing.

All the Webinar Replays for the MySQL, MongoDB or PostgreSQL DBA

This blog provides an overview and links to our different webinar replays and blog series for the MySQL, MariaDB, Percona, MongoDB and PostgreSQL DBA.

Posted in:

Performing a Live Upgrade to MySQL 5.7

Once we’ve tested that our application works with MySQL 5.7, what is the best way to introduce 5.7 in our live environment? How can we minimize risks? What tools can help facilitate the process?

Posted in:

Sign up for our free whitepaper: MySQL Replication Blueprint

This whitepaper 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.

New Whitepaper: MySQL Replication Blueprint

MySQL Replication Blueprint whitepaper - this includes all aspects of a Replication topology with the ins and outs of deployment, setting up replication, monitoring, upgrades, performing backups and managing high availability using proxies.

Webinar Replay & Slides: the MySQL Replication Blueprint

These are the replay details of our webinar on the MySQL Replication Blueprint with MySQL 5.6 and 5.7, which includes all aspects of a Replication topology with the ins and outs of deployment, setting up replication, monitoring, upgrades, performing backups and managing high availability using proxies.

Posted in:

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

An overview of ProxySQL in a MySQL replication environment, and how ProxySQL adds features like failover and query control to the setup.

MySQL Load Balancing with ProxySQL - an Overview

An overview of ProxySQL, an SQL-aware load balancer for MySQL and MariaDB. This blog post explains the concepts behind ProxySQL, and goes through installation and configuration.