MySQL High Availability
by Charles Bell, Mats Kindahl, Lars Thalmann · first published 2014
3mentions
2recommended by
3HN commenters
2011–2017first – last mentioned
67% recommend33% neutral
Affiliate links. As an Amazon Associate I earn from qualifying purchases.
…following hardcopy books in order: MySQL: http://www.amazon.com/MySQL-Developers-Library-Paul-DuBois-e... www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/1449314287/ http://www.amazon.com/MySQL-High-Availability-Building-Cente... If your wanting to do Microsoft SQL Server, I recommend the following: http://www.amazon.com/Microsoft-Server-2012-Step-Developer/d... http://www.amazon.com/Training-70-461-Querying-Microsoft-Ser...…
on “Best way to get started with SQL?” ↗The two must have books for MySQL admin and discuss MySQL's built in replication, what problems you'll encounter, how to tune etc. - High Performance MySQL (Schwartz et al) - MySQL High Availability (Bell et al) I think using MySQL::Replication can be applied on top of what's in these books, but not using their particular setups.
on “MySQL::Replication - peer-to-peer based, multi-master replication for MySQL” ↗…Talks about replication, monitoring, cluster management, avoiding downtime etc i.e. all the tricks you can do to manage multiple instances. Again there's a similar book for MySQL https://www.amazon.com/MySQL-High-Availability-Building-Cent... Last but not least check out the postgres documentation, people consider it a standard of what good documentation looks like https://www.postgresql.org/docs/9.6/static/index.html Also…
on “Ask HN: What is the best online resource to learn advanced SQL?” ↗