Database Expertise
MySQL
The Pythian team is well respected in the MySQL community. Our database engineers and system administration specialists are active in MySQL user groups and our MySQL-focused blogs are amongst the most read.
The World's Top MySQL Experts
Even the best DBAs are limited by their own experience. But at Pythian, we have one of the world’s largest concentrations of dedicated and varied DBA expertise. This shared experience is an enormous asset to our clients.
Sheeri K. Cabral is a MySQL Certified DBA and was MySQL's Community Advocate of the Year for 2007 and 2008. She has spoken numerous conferences, organizes the Boston MySQL User Group, and wrote the MySQL Administrator's Bible, which was published in May 2009. Sheeri is the first to hold the title of Oracle ACE Director for her MySQL expertise.
Augusto Bott is a MySQL Certified DBA and a prominent and respected member of the MySQL community. He is also Pythian's most-read blogger, having authored our popular series of articles on installing the Oracle database on the Linux OS.
We know when to scale up and scale down, what replication architectures to use, how to get a consistent, reliable backup with minimal overhead and when to use clustering technology. We know storage engines, using MySQL in cloud computing environments, what hardware to use and how to make sure it’s all configured properly. Migrations, performance tuning, security, data modeling, data warehousing – we’ve worked for a lot of companies and know how these things work.
MySQL Database Features
We use the following MySQL features on a regular basis:
- Storage engines (MyISAM, InnoDB, MEMORY, ARCHIVE, MERGE, CSV)
- Replication architecture
- Replication synchronization
- Heartbeat Cluster
- Stored routines, triggers, views, events
- Partitioning (with MERGE tables and MySQL's native partitioning)
- Benchmarking with sysbench
- Backups using InnoDB Hot Backup, XtraBackup, LVM, EBS snapshots
- MySQL Enterprise Monitoring
- MONyog
- MySQL Query Analyzer
- MySQL Proxy
- MySQL Cluster