MySQL SRE, Dropbox / ProxySQL
René has 15 years of working experience as System, Network and Database Administrator mainly on Linux/Unix platform. In the last 10 years his experience was focused mainly on MySQL, working as Senior MySQL Support Engineer at Sun/Oracle, then Senior Operational DBA at Blackbird, (formerly PalominoDB), and finally MySQL SRE at Dropbox. In this period he built an analytic and problem solving mindset and he is always eager to take on new challenges, especially if they are related to high performance. His main focus now is the development of ProxySQL.
There are excellent Enterprise softwares that are able to scale out and boost performances of a cluster, but none open source.
In this hands on lab, Rene Cannao will walk through evaluation of operational errors and issues in MySQL 5.6, and recovering from them. This will be a hands-on workshop where possible. Specific items that cannot easily be reproduced will be done via Amazon/EC2 and screencast. 1. Instance Crashes and Hangs - * Evaluating error logs and troubleshooting methodologies. * Determining issues (... [read more]