MariaDB: use Docker Compose for MariaDB
Here's an easy way how to set up MariaDB using Docker Compose
Topic
MySQL
A collection of 7 issues
Percona: Use Percona as an alternative for MySQL or MongoDB
Percona for MySQL
Why Percona
Percona for MySQL is a fork of MySQL. It aims to be a more stable alternative (as it fixes many bugs which still exist in MySQL), but it stays completely compatible with MySQL.
No Innovation Release
Percona for MySQL will not release innovation releases, because
MySQL: Use CheckMk to monitor MySQL
CheckMk is a great tool for monitoring. Especially when it comes to standard functions for operating systems.
But CheckMk is also great for the monitoring of MySQL databases.
If you want to use it, just install the CheckMk agent on the MySQL server. Additionally, you'll need the MySQL
MariaDB/MySQL: Migrate from MariaDB to MySQL (using MySQL Shell)
This blog post is about how to migrate from MariaDB to MySQL using MySQL Shell.
MySQL: Deploy InnoDB ClusterSet
What is InnoDB ClusterSet
MySQL: "MySQL InnoDB ClusterSet provides disaster tolerance for InnoDB Cluster deployments by linking a primary InnoDB Cluster with one or more replicas of itself in alternate locations, such as different datacenters. InnoDB ClusterSet automatically manages replication from the primary cluster to the replica clusters using
MySQL: create an InnoDB cluster
What is MySQL InnoDB Cluster?
MySQL InnoDB Cluster is an easy way to increase the avalability and read-only operations of a MySQL database.
For the simplest configuration, we need 3 hosts having MySQL server installed and running.
In my case, I'll use MySQL sandboxes in MySQL Shell as
MySQL: Use Docker Compose for MySQL
Using Docker, you can easily set up new MySQL instances.
I prefer to use Docker compose for that - here's my configuration file (which should also work for MariaDB-Containers):
services:
db:
image: mysql:8.0
restart: always
environment:
MYSQL_DATABASE: 'db'
MYSQL_USER: 'user'