FromDual has the pleasure to announce the release of the new version 2.0.0 of its popular MySQL, Galera Cluster and MariaDB multi-instance environment MyEnv.
If you are already familiar with MySQL and you are challenged to operate a serious MySQL Enterprise infrastructure this training is the right one for you.
Requirements
You are familiar with the MySQL basics and have already some experience with MySQL operations. The SQL language does not look strange to you any more. Further you are familiar with the Linux console and rule the most important UNIX commands.
There are some pretty sophisticated Load Balancers for Galera Clusters setups out in the market (ProxySQL, MaxScale, HAproxy, ...). They have many different exotic features. You can nearly do everything with them. But this comes at the cost of complexity. Non of them is simple any more.
The FromDual Ops Center for MySQL and MariaDB (focmm) is an application for DBA's and system administrators to manage MySQL and MariaDB database farms.
The main task of Ops Center is to support you in your daily MySQL and MariaDB operation tasks.
The FromDual Ops Center for MySQL, Galera Cluster, MariaDB and Percona Server helps you to operate your complex MySQL database set-ups with and easy to use Web-GUI. Master/Slave, Master/Master, VIP fail-over, etc. is possible.
FromDual tools provide valuable additional functionality which facilitate and optimize daily operations of your MySQL databases.
Since our last newsletter a lot of things have changed in the FromDual tools.
FromDual Tools bieten wertvolle ergänzende Funktionen, die den täglichen Betrieb von MySQL Datenbanken erleichtern und optimieren.
Seit unserem letzten Newsletter hat sich einiges getan bei den FromDual Tools.
You are already familiar with the MySQL or MariaDB and you are challenged to operate a serious MySQL database. If this is the case this training is the right one for you.
Following question came up recently: What happens if you drop or add a partition of an existing already partitioned table with ALTER TABLE? Will it be copied or will just the single partition be dropped and added? How are the index(es) rebuild after such a drop/add?
The following maintenance jobs are typically run against a MySQL database:
Backup
Clean-up binary logs
Optimize tables
Purge query cache
Rotate binary logs
Backup
A backup is not a typical maintenance job. But it behaves more or less like one. The backup should be done regularly depending on the restore/PITR (Point in Time Recovery) requirements.
