MySQL & MariaDB Database Backup Resources
Most organizations do not realize they have a problem with database backups until they need to restore the data and find it’s not there or not in the form that they were expecting. The designated...
HAProxy: All the Severalnines Resources
Load balancers are an essential component in MySQL and MariaDB database high availability; especially when making topology changes transparent to applications and implementing read-write split functionality. HAProxy is free, open source software that provides a...
HAProxy Connections vs MySQL Connections – What You Should Know
Having a load balancer or reverse proxy in front of your MySQL or MariaDB server does add a little bit of complexity to your database setup, which might lead to some, things behaving differently. Theoretically,...
Monitoring Galera Cluster for MySQL or MariaDB – Understanding Metrics (Updated)
To operate any database efficiently, you need to have insight into database performance. This might not be obvious when everything is going well, but as soon as something goes wrong, access to information can be...
Percona Live Dublin – Event Recap & Our Sessions
Severalnines was pleased to yet again sponsor Percona Live Europe, the Open Source Database Conference which was held this year in Dublin, Ireland. At the Conference Severalnines team members flew in from around the world...
Manage and Automate Galera Cluster – Why ClusterControl
Galera Cluster by Codership is a synchronous multi-master replication technology which can be utilized to build highly available MySQL or MariaDB clusters. It has been downloaded over one million times since last year, establishing itself...
Multiple Data Center Setups Using Galera Cluster for MySQL or MariaDB
Building High Availability, one Step at a Time When it comes to database infrastructure, we all want it. We all strive to build a highly available setup. Redundancy is the key. We start to implement...
A How-To Guide for Galera Cluster
Since it was originally published more than 63,000 people (to date) have leveraged the MySQL for Galera Cluster Tutorial to both learn about and get started using MySQL Galera Cluster. Galera Cluster for MySQL is...
Galera Cluster Comparison – Codership vs Percona vs MariaDB
Galera Cluster is a synchronous multi-master replication plugin for InnoDB or XtraDB storage engine. It offers a number of outstanding features that standard MySQL replication doesn’t - read-write to any cluster node, automatic membership control,...
What’s New With MySQL Replication in MySQL 8.0
Replication in MySQL has been around for a long time, and has been steadily improving over the years. It has been more like evolution rather than revolution. This is perfectly understandable, as replication is an...
DevOps Considerations for Production-Ready Database Deployments
MySQL is easy to install and use, it has always been popular with developers and system administrators. On the other hand, deploying a production-ready MySQL environment for a business-critical enterprise workload is a different story....
DevOps Database Glossary for the MySQL Novice
When you need to work with a database that you are not 100% familiar with, you can be overwhelmed by the hundreds of metrics available. Which ones are the most important? What should I monitor,...