MySQL HOWTO's

Below there are several guides on getting started with tools and features around MySQL. Some howtos are under construction but Audit, Firewall and the Query Rewrite are done, rest will be finalized soon.

If you want to be able to copy-n-paste the commands from the demo sections in the howto's use my simple install script to setup MySQL, more information here. Some features require MySQL Enterprise Edition and you can follow this guide to download MySQL Enterprise Edition.

All of the guides should work with both MySQL 5.7 and MySQL 8.

---

• MySQL Security

  • MySQL Enterprise Audit (5.6)
  • MySQL Enterprise Audit (5.7)
  • MySQL Enterprise Firewall
  • MySQL Transparent Data Encryption
  • Security blogs by Dasini

• MySQL Performance

  • MySQL Query Rewrite Plugin
  • MySQL Automated Partitioning

• MySQL High Avalability

  • MySQL Replication
  • MySQL InnoDB Cluster (local sandbox)
  • MySQL InnoDB Cluster (3 VM or OCI setup)
  • MySQL NDB Cluster

• MySQL Replication

  • Setting up multi-source replication (MySQL 5.7 and MYSQL 8 with GTID)

• MySQL Cloud

  • Automation scripts

• Database Change Tracking

  • Using MySQL Enterprise Audit Log

• MySQL Document Store

• MySQL Backup/Restore

• MySQL Monitoring