Topic

MySQL

A collection of 9 issues

Oracle: Database Appliance (ODA) used for other things

My thoughts on what you could also do with your ODA

The Ten Commandments for DBAs

I recently read a great blog entry from Fritz Lechnitz, who wrote about the Ten Commandments for a SQL Server DBA. As I am - and mostly was over many years - an Oracle DBA, who had some excursions to other RDBMS (SQL Server, DB/2, Informix, MySQL, PostgreSQL ), I&

MariaDB: use Docker Compose for MariaDB

Here's an easy way how to set up MariaDB using Docker Compose

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'