An experienced MySQL DBA database administrator based in Birmingham, UK. Certified to the top levels with the MySQL® database server from versions 3.2 to 8.x, I have spent several years building and maintaining busy sites with 24×7 database availability and high levels of performance

MySQL Server setup and management

I have set up master-slave replicated database clusters, for both performance, HA (high availability) and backup scenarios. These setups have allowed for timely and effective archiving and disaster recovery, including PiTR (Point in Time Recovery) for data damaged by runaway SQL statements

My work also involves database optimisation (setting up the server for maximum performance), schema design and optimisation, monitoring MySQL® database servers to maintain maximum performance and availability, and SQL query optimisation

Server and system administration

I am also the administrator of the Linux® servers on which I work, allowing me to extend the database optimisation to the OS and hardware level. This results in some systems I’ve worked on achieving uptimes in excess of 1500 days, with on-line replacement and upgrades of hard disks and related filesystems

Writing

I also write articles for both developers using MySQL and MySQL DBAs