{"product":{"product_id":"1449314287","title":"High Performance MySQL: Optimization, Backups, and Replication","price":"9.22","image_url":"https://m.media-amazon.com/images/I/5144MpFC6hL._SL500_.jpg","url":"https://www.amazon.com/dp/1449314287"},"comments":[{"body":"Certs are there to show that you have a good grasp of certain concepts, not as learning tools.\r\n\r\nSomething like O'Reilly's [High-Performance MySQL](http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/1449314287/) book would be a great way to get the knowledge part down, but nothing beats hands-on experience.","subreddit_name":"mysql","author":"kadaan"},{"body":"Cool right? I read about it in [this book](https://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/1449314287), which is 10 years old!","subreddit_name":"laravel","author":"aarondf"},{"body":"I was kind of thrown into MySQL for trial by fire.  The company that I worked at as an Operations Engineer needed someone to focus on the databases.  I volunteered and, through learning as I went, I picked up a lot.\r\n\r\nI recommend a few things.  First of all, pick up [High Performance MySQL](https://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/1449314287/l).  It is a great read and will give you some very useful insights as to how MySQL operates internally.  I think I have 4 or 5 copies sitting around the house.\r\n\r\nNext, download the [Sakila database](https://dev.mysql.com/doc/sakila/en/sakila-installation.html).  Poke around in there and see what you can find.  Google \"Sakila Database Exercises\" and I'm sure you will find a lot of exercises to do on that dataset.\r\n\r\nPersonally, I learn best two ways.  First, by trial and error.  I have to get my hands in a system and try things to see what works, how it works and so on.  Next, I learn from other people.  Don't be afraid to google and ask about things.  There are TONS of resources out there to help people learn mysql.  ","subreddit_name":"mysql","author":"jericon"},{"body":"[High Performance MySQL](http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/1449314287?utm_source=out\u0026amp;utm_medium=reddit) is a good place to start.  \r\n\r\nDepending on what you're doing with MySQL, you may also want to check out [VividCortex](http://www.vividcortex.com), the monitoring tool designed by Baron Schwartz, one of the authors of that book.","subreddit_name":"mysql","author":"arslotnick"},{"body":"Give [VividCortex](http://www.vividcortex.com?utm_source=out\u0026amp;utm_medium=reddit) a look too, specifically for database monitoring. VividCortex offers the most granular monitoring available (constant 1 second granularity), which is pretty crazy and extremely useful. It was also founded and is run by Baron Scwartz, who literally wrote [*the* book on MySQL](http://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/1449314287?utm_source=out\u0026amp;utm_medium=reddit). You can also watch [a video](https://vividcortex.com/blog/2015/08/03/top-queries-video/?utm_source=out\u0026amp;utm_medium=reddit) of the app in action, if you're interested. ","subreddit_name":"sysadmin","author":"arslotnick"},{"body":"When you get to a project larger than a small business or personal website it's less about the language and more about imposing a structure that makes sense backed by a data model that's thought out and performant. \r\n\r\nI recommend these books:\r\n\r\nhttp://www.amazon.com/High-Performance-MySQL-Optimization-Replication/dp/1449314287/ref=sr_1_1?ie=UTF8\u0026amp;qid=1425831227\u0026amp;sr=8-1\u0026amp;keywords=high+performance+mysql\r\nhttp://www.amazon.com/gp/product/0321127420/ref=oh_aui_detailpage_o05_s00?ie=UTF8\u0026amp;psc=1","subreddit_name":"PHP","author":"mrferos"}]}