Oracle: Access MySQL databases from Oracle
I'll show how to access MySQL databases from Oracle
Topic
MySQL
A collection of 10 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'