Any good guides like this for MySQL? Unfortunately having to use it instead of Postgres at my current job.
I have been a heavy user of the Percona distribution of MySQL for many years and highly recommend it. I think that most of the MySQL articles on percona.com are relevant for other MySQL distributions.
As a side note, depending on the software stack, ProxySQL can have a major positive impact on performance and scalability.
* work_mem is postgres specific
* stored procs and functions don't perform as badly in SQL Server
* Triggers behave differently
* NOTIFY is postgres specific
etc.