Tutorial Slides

Pages

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

Scaling MySQL Strategies for Developers

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; ...
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 ...
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...
MariaDB's Virtual Columns

I wanted to evaluate MariaDB's virtual column and see if it could store business rules next to table data. With virtual columns this co...
Using Business Rules in MySQL

Overview While everyone tries to improve speed and performance in MySQL, other databases have realized that adding features that cut down on...