Topic

MySQL

A collection of 3 issues

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

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'