Learning MySQL

MySQL Backup

• How to Backup/Restore MySQL/MariaDB and PostgreSQL Using ‘Automysqlbackup’ and ‘Autopostgresqlbackup’ Tools
• archlinux | MariaDB

Partition Table

• MySQL 千萬級資料表 partition 實戰應用
• 簡單使用 Mysql Partition 優化查詢
• MariaDB Partition 學習
• PARTITION Maintenance in MySQL

Time-Series in MariaDB

• Using a Staging Table for Efficient MySQL Data Warehouse Ingestion
• Summary Tables in MySQL

DB Optimization

• 13 Tips for Tuning and Optimizing MySQL and MariaDB

DB Administration

• 20 mysqladmin Commands for MYSQL/MariaDB Database Administration
• Upgrading Uber’s MySQL Fleet  to version 8.0 | Uber Blog

Synchronize DBs

• Synchronize databases more easily with open source tools | Opensource.com
• Apache SeaTunnel | Apache SeaTunnel

drawDB

Free and open source, simple, and intuitive database design editor, data-modeler, and SQL generator.

• drawDB | Online database diagram editor and SQL generator
• GitHub: https://github.com/drawdb-io/drawdb