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
• DBX - 輕量資料庫工具 + MCP Server 讓 AI Agent 直接操作資料；跨平台、開源免費的輕量型資料庫管理工具

Synchronize DBs

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