dankow/Deploying_MySQL_in_Production_References.md

Last active May 31, 2020 16:30

Star (7) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dankow/15c800dcb9136db8f9845974b499195f.js"></script>
Save dankow/15c800dcb9136db8f9845974b499195f to your computer and use it in GitHub Desktop.

Download ZIP

References for Deploying MySQL in Production

Raw

Deploying_MySQL_in_Production_References.md

General links:

Slides for this session (from Percona Live Santa Clara 2017)
DBAs, A Priesthood No More - Silvia Botros
Ozar's Hierarchy of Database Needs - Brent Ozar

Config management:

Deploying MySQL HA with Ansible and Vagrant - Daniel Guzman Burgos

OS Config:

CPU governor performance - Vadim Tkachenko
Linux Filesystems and MySQL - Ammon Sutherland
Best Practices for Configuring Optimal MySQL Memory Usage - Peter Zaitsev

MySQL Config:

Percona Config Wizard
MySQL 5.7 Performance Tuning Immediately After Installation - Alexander Rubin
Ten MySQL performance tuning settings after installation - Stephane Combaudon

Backups:

Percona Xtrabackup
mydumper
- Ubuntu provides mydumper packages
- TwinDB has packages for CentOS/RHEL but they're old
mysqlpump
What Are Full, Incremental, and Differential Backups? - Baron Schwartz

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment