Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
Answer
Close
Polls
Does your company/department have a disaster recovery plan?
Submit
Yes
No
I don’t know
Thank you for submiting your answer!
Please select another item to change your answer.
Results so far (Total Voters: 9):
  • Yes (44%, 4 Votes)

  • No (56%, 5 Votes)

  • I don’t know (0%, 0 Votes)

208 blog posts in 13 categories

Webinar Replay and Q&A: High Availability in ProxySQL for HA MySQL infrastructures

This blog provides details for the replay of our webinar on high availability in ProxySQL for HA MySQL infrastructures; as well as answers to the many questions asked during this session.

Posted in:

ClusterControl for Galera Cluster for MySQL

Galera Cluster is widely supported by ClusterControl. With over four thousand deployments and more than sixteen thousand configurations, you can be assured that ClusterControl is more than capable of helping you manage your Galera setup.

Posted in:

How to Deploy Asynchronous Replication Slave to MariaDB Galera Cluster 10.x using ClusterControl

Combining Galera and asynchronous replication in the same MariaDB setup, aka Hybrid Replication, can be useful as we’ve discussed previously. This new post takes things further and shows you how to deploy an asynchronous replication slave to MariaDB Galera Cluster 10.x (with master failover), using GTID with ClusterControl.

Updated - Full Restore of a MySQL or MariaDB Galera Cluster from Backup

Performing regular backups of your database cluster is imperative for high availability and disaster recovery. This blog post provides a series of best practices on how to fully restore a MySQL or MariaDB Galera Cluster from backup.

Updated - How to Bootstrap MySQL or MariaDB Galera Cluster

Unlike standard MySQL server and MySQL Cluster, the way to start a MySQL or MariaDB Galera Cluster is a bit different. Galera requires you to start a node in a cluster as a reference point, before the remaining nodes are able to join and form the cluster. This process is known as cluster bootstrap. Bootstrapping is an initial step to introduce a database node as primary component, before others see it as a reference point to sync up data.

Posted in:

Webinar Replay and Q&A: Load balancing MySQL & MariaDB with ProxySQL & ClusterControl

This blog provides details for the replay of our webinar on how to load balance MySQL and MariaDB with ClusterControl and ProxySQL; as well as answers to the many questions asked during this session.

MySQL Tutorial - Troubleshooting MySQL Replication Part 2

This blog post walks you through some issues you may experience when deploying and managing a MySQL Replication environment and how to resolve those issues.

MySQL Tutorial - Troubleshooting MySQL Replication Part 1

This blog post walks you through some issues you may experience when deploying and managing a MySQL Replication environment and how to resolve those issues.

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.