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

Synchronize DBs

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