Percona's Whole Stack Coverage

MySQL expertise put Percona on the map, particularly our expertise in the InnoDB storage engine, which is the backbone of all serious MySQL use. However many technologies are part of any successful MySQL project besides MySQL itself. Percona has broad expertise in most of them. We provide "whole stack" coverage, tuning each "instrument" in your MySQL "orchestra" to work together. We care about achieving your overall goals, not just your MySQL piece. There are no artificial boundaries when working with a Percona consultant. Below is a list of technologies we have successfully handled.

Database Servers

• MySQL Server - Versions 4.x, 5.0, 5.1, & 5.5
• MySQL Server - Community & Enterprise Editions
• Percona Server - Percona's builds of MySQL 5.0 with performance patches
• MariaDB - backward compatible, drop-in replacement branch of the MySQL Database Server.
• MySQL Cluster - Versions 6.x, 7.x
• Drizzle - Re-engineered fork of MySQL designed for cloud computing

Storage Engines

• MyISAM - Traditional storage engine with Table Locks and no transactions support
• InnoDB - Native, Plug-In, & Embedded versions
• XtraDB - Percona's enhanced transactional engine based on Innodb
• Blackhole - Non-writable engine used in special replication-related situations
• Federated - Disperses tables across multiple servers
• Falcon - In memory engine (no longer under active development)
• SphinxSE - Full text search engine
• Maria - Transactional engine by Monty Program Ab, derived from MyISAM
• PBXT - Transactional engine by Primebase
• TokuDB - Storage engine that increases performance with fractal indexing technology

MySQL High Availability

• Pacemaker - scalable cluster resource manager
• Heartbeat - High availability node monitor
• DRBD - Block based replication by Linbit
• Schooner MySQL Enterprise with Active Cluster
• HA Proxy- Load balancer

Performance Enhancements Strategies

• memcached - In-memory caching
• MySQL Proxy - Load balancing, failover, query filtering & analysis utility

MySQL Replication & Backup

• XtraBackup - Open-source non-blocking backup tool for InnoDB and XtraDB data
• InnoDB Hot Backup - Oracle's proprietary backup utility
• mysqldump, mysqlhotcopy - Official MySQL tools
• MyLVMBackup - Backup scripts
• Zmanda - Commercial backup manager
• Statement Based & Row Based replication commands
• Tungsten - Commercial replication manager

MySQL Utilities & Other

• Maatkit - Suite of 20+ utilities for developers & DBAs
• innotop - MySQL internals monitor
• mysqlsla - General log analyzer
• mysqlreport - Makes readable SHOW STATUS output
• MySQL Connectors - ODBC, J, Net, MXJ, C++, C, PHP native driver
• MySQL Workbench - GUI based integrated development environment
• MySQL GUI Tools Bundle - Administrator, Query Browsers, Migration Toolkit
• MySQL Command Line Tools - mysqlbinlog, myisamchk, mysqld_multi, etc.
• phpMyAdmin - Browser based DBA tool
• SQLyog - GUI based integrated development environment
• Stored Procedures, Triggers, Full Text Search, Views, & UDFs

Hardware & Software Environment

• Storage: RAID, SAN, NAS, SSD & Virtualization
• Switches, Firewalls, Load Balancers, Remote Management
• Web Servers: Apache, Tomcat, Lighttpd, Squid, Varnish
• Version Control: Subversion, Mercurial, Bazaar, Bitkeeper
• DNS: Bind, VPN, IPSEC, IPFW, IPTables, PFSense, UltraDNS, PowerDNS, DjbDNS
• Debugging: Strace, Oprofile, Dtrace, GDB, Valgrind, KCachegrind
• Mail: Postfix, Sendmail, Qmail, Exim, Cyrus
• Monitoring: Nagios, MONyog, Cacti
• Languages: PHP, Perl, Ruby, Python, Java, Erlang
• PHP: Xcache, APC, eAccelerator
• Frameworks: Rails, Drupal, Wordpress, phpBB
• Filesystems: ext3, ZFS, XFS