Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Apply (1) filters
65 blog posts in 1 category

MySQL on Docker: Running a MariaDB Galera Cluster without Orchestration Tools - DB Container Management - Part 2

So you’ve deployed MariaDB cluster on Docker, what next? What do you do when containers fail or are rescheduled, and IP addresses change? How do you ensure that the database adapts to changes to the underlying container configurations? In this follow-up blog post, we’ll look into cluster management and orchestration of Galera cluster on Docker.

How to Benchmark Performance of MySQL & MariaDB using SysBench

How can you quickly evaluate performance of a database under intensive load? Welcome to sysbench. This blog gives you a good background of sysbench, and how you can use it to benchmark MySQL and MariaDB.

MySQL on Docker: Running a MariaDB Galera Cluster without Container Orchestration Tools - Part 1

Container orchestration tools do not always play nicely with database clusters. In this blog post, we are going to look into how to run a MariaDB Galera Cluster on Docker containers using the standard Docker image on multiple Docker hosts without the help of orchestration tools like Swarm or Kubernetes.

How to Recover Galera Cluster or MySQL Replication from Split Brain Syndrome

Split brain syndrome is a state where a cluster of nodes is partitioned into smaller clusters of equal numbers of nodes, and each cluster believes it is the active cluster. This is a harmful state, as data is changed on a partition, without being replicated to the other. This blog post describes how to prevent a split brain from happening, and what can be done if it does happen.

Posted in:

Watch the Replay: How to Migrate to Galera Cluster for MySQL & MariaDB

Watch the replay of this webinar on how to migrate to Galera Cluster for MySQL & MariaDB. Severalnines Support Engineer Bart Oles walks us through what you need to know in order to migrate from standalone or a master-slave MySQL/MariaDB setup to Galera Cluster.

Posted in:

How to Overcome Accidental Data Deletion in MySQL & MariaDB

Someone accidently deleted part of the database, or forgot to include a WHERE clause in a DELETE query, or dropped the wrong table. Things like that may and will happen, it is inevitable and human. But the impact can be disastrous. What can you do to guard yourself against such situations, and how can you recover your data?

How to Make Your MySQL or MariaDB Database Highly Available on AWS and Google Cloud

Cloud environments are popular these days, and they come with a variety of tools to increase availability. In this blog post, we will show you how leverage these to build a highly available MySQL or MariaDB database. This blog post makes use of Amazon Web Services and Google Cloud Platform.

Comparing Oracle RAC HA Solution to Galera Cluster for MySQL or MariaDB

This blog provides a comparison of achieving high availability with Oracle RAC vs MySQL Galera Cluster.

Posted in:

How to Secure Galera Cluster - 8 Tips

As a distributed database system, Galera Cluster requires additional security measures as compared to a centralized database. Data is distributed across multiple servers or datacenters, with significant data communication across nodes. This blog post covers some important tips to secure your Galera Cluster installation.

Posted in:

Ten Tips on How to Achieve MySQL and MariaDB Security

This blog gives you 10 suggestions on how to improve the security of your MySQL or MariaDB installations.