Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Watch the Webinar Replay: MySQL & MariaDB Performance Tuning for Dummies

Tuning a database and the underlying OS is one of the key tasks when managing a database. The goal is to avoid overutilization or underutilization of the available resources.

In this webinar replay, we give you a crash course in performance tuning for MySQL & MariaDB databases.

Schema Management Tips for MySQL & MariaDB

Schema changes are not popular among database ops folks. They can be quite cumbersome in MySQL and MariaDB, and there are risks to the data as well as the availability of the database.

This blog describes the different types of schema change operations you can perform on MySQL and MariaDB, and presents some best practices to minimize disruptions to your operations.

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.

Comparing RDS vs EC2 for Managing MySQL or MariaDB on AWS

When managing MySQL on AWS, one has the choice between convenience of a hosting service like RDS, and the control and flexibility of running MySQL on EC2. This blog discusses the difference, with focus on the tradeoffs when using replication.

ChatOps - Managing MySQL, MongoDB & PostgreSQL from Slack

CCBot helps you monitor and manage your database Infrastructure from Slack. ChatOps is about bringing your DevOps work to your chats and conversations within a team, e.g. Slack. You can deploy database clusters, get status information, trigger backups, add nodes to your cluster or replication setup by talking to a chatbot, which understands ClusterControl commands.

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.

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.

Understanding Deadlocks in MySQL & PostgreSQL

Anyone who has written applications on top of MySQL or PostgreSQL probably has had to deal with concurrency problems at some point. This blog focuses on issues around database deadlock, a situation in which two or more transactions are waiting for one another to give up locks.