Tutorial Slides

Pages

Here are my slides from the tutorial I gave at Percona Live UK.

Scaling MySQL Strategies for Developers

Developing Internal Business Applications with PHP

Image via Wikipedia Recently, my company has decided to go full (or mostly) open source by moving away from Microsoft technologies. This is ...
Open Source ETL tools vs Commercial ETL tools

Image via Wikipedia Recently I have been asked by my company to make a case for open-source ETL -data integration tools as an alternative ...
How to Safetly Restart Your MySQL Slave Server

Make sure that nothing can access it (take it off the load balancer). in mysql client do: STOP SLAVE; in mysql client do: FLUSH TABLES; ...
Storing Conditions in the Database

Caching Business Logic in the Database I had this relatively simple idea of storing conditions in the database. The idea is to store the con...
JSON and MySQL Stored Procedures

You probably heard that MySQL 5.7 supports JSON. But did you know that you can also use JSON with MySQL Stored Procedures - making them ver...
Where have all the MySQL DBAs gone?

I have a friend who works as a MySQL recruiter. He recently told me that he cannot find any more MySQL DBAs in the UK or in the neighbouring...