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.
Martin Wendler
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
Oracle: Which updates to install
In my IT carreer, I often come to new customers I didn't know before. So I don't know their infrastructure.
As I'm a DBA, I'm not interested in application servers (besides telling the customer that Operating Systems and standard applications should always
TimescaleDB: Use Docker Compose for TimescaleDB
This time, I'm showing how to use Docker Compose to run TimescaleDB
Oracle: Prepare database for upgrade using autoupgrade.jar
In my job, I often have to upgrade or patch Oracle databases. Furtunately, most of all the databases in production are now on 19c, and the rest is mainly on 12.2.0.1.
The best tool for upgrading is autoupgrade.jar, which in future will be the only upgrade
CheckMk: Use Docker Compose for CheckMk
CheckMk is a great tool for monitoring. It's quite easy to deploy, and it offers support for monitoring a big range of hardware and software solutions - either through plugins, or out of the box.
To create a CheckMk container, you can use this docker-compose.yml:
services:
checkmk:
Oracle: Upgrade from 12.1.0.1 using autoupgrade.jar takes ages
Last year, when I upgraded many Oracle databases to 19c, I had a few databases which were still on Oracle 12.1.0.1. In case that you forgot what 12.1.0.1 meant for Oracle and all customers:
* Until 12.1.0.1, we had Enterprise Edition, Standard
MySQL: Configure InnoDB ReplicaSet
What is InnoDB ReplicaSet
MySQL documentation: "Being based on MySQL Replication, an InnoDB ReplicaSet has a single primary, which replicates to one or more secondary instances. An InnoDB ReplicaSet does not provide all of the features which InnoDB Cluster provides, such as automatic failover, or multi-primary mode. But, it
InfluxDB: Using Docker Compose for InfluxDB
InfluxDB is a "time series database developed by the company InfluxData. It is used for storage and retrieval of time series data in fields such as operations monitoring, application metrics, Internet of Things sensor data, and real-time analytics."
Besides installing InfluxDB on a server, or rent the service
Grafana: Use Docker Compose for Grafana
Grafana is a great tool: "Query, visualize, alert on, and understand your data no matter where it’s stored. With Grafana you can create, explore, and share all of your data through beautiful, flexible dashboards."
In a modern production environment, I'd have a highly available system