Database Performance Audit

Pages

to take a look at your database?

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...
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...