Percona Stack Expertise

Courtesy:  Percona

Database Servers

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

Performance Enhancements Strategies

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

MySQL Replication & Backup

MySQL Utilities & Other

Hardware & Software Environment

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s