# Learning MySQL

##### MySQL Backup

- [How to Backup/Restore MySQL/MariaDB and PostgreSQL Using ‘Automysqlbackup’ and ‘Autopostgresqlbackup’ Tools](https://www.tecmint.com/mysql-mariadb-postgresql-database-backup-using-automysqlbackup-autopostgresqlbackup/)
- [archlinux | MariaDB](https://wiki.archlinux.org/title/MariaDB)

##### Partition Table

- [MySQL 千萬級資料表 partition 實戰應用](https://www.itread01.com/hkclpql.html)
- [簡單使用 Mysql Partition 優化查詢](https://cola.workxplay.net/mysql-partitioning-for-performance-optimization/)
- [MariaDB Partition 學習](https://abcg5.pixnet.net/blog/post/117375474-mariadb-partition-%E5%AD%B8%E7%BF%92)
- [PARTITION Maintenance in MySQL](http://mysql.rjweb.org/doc.php/partitionmaint)

##### Time-Series in MariaDB

- [Using a Staging Table for Efficient MySQL Data Warehouse Ingestion](http://mysql.rjweb.org/doc.php/staging_table)
- [Summary Tables in MySQL](http://mysql.rjweb.org/doc.php/summarytables)

##### DB Optimization

- [13 Tips for Tuning and Optimizing MySQL and MariaDB](https://vitux.com/tune-and-optimize-mysql-mariadb/)

##### DB Administration

- [20 mysqladmin Commands for MYSQL/MariaDB Database Administration](https://www.tecmint.com/mysqladmin-commands-for-database-administration-in-linux/)
- [Upgrading Uber’s MySQL Fleet to version 8.0 | Uber Blog](https://www.uber.com/en-TW/blog/upgrading-ubers-mysql-fleet/)

##### Synchronize DBs

- [Synchronize databases more easily with open source tools | Opensource.com](https://opensource.com/article/23/3/synchronize-databases-apache-seatunnel)
- [Apache SeaTunnel | Apache SeaTunnel](https://seatunnel.apache.org/)