no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
| — | about_percona [2015/06/02 00:06] (current) – created - external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== About Percona ====== | ||
| + | * [[Percona]] | ||
| + | |||
| + | === History === | ||
| + | |||
| + | * MySQL wasn't using their own InnoDB software that they bought out until 5.5 (5.1 included an older version that they were maintaining themselves) | ||
| + | * Oracle bought out MySQL, and has not been improving much on InnoDB | ||
| + | * InnoDB was released as a modular plugin, which is how it works in 5.5 | ||
| + | * Percona forked InnoDB, created ExtraDB | ||
| + | |||
| + | === About === | ||
| + | |||
| + | * Open-source software (GNU GPL) | ||
| + | * MySQL consulting | ||
| + | |||
| + | === Software === | ||
| + | |||
| + | == Why InnoDB / XtraDB? == | ||
| + | |||
| + | * Row-locking versus table-locking (MyISAM) | ||
| + | * Transactional support - atomic commits | ||
| + | * Binary logging for replication | ||
| + | * Foreign key support | ||
| + | |||
| + | == Percona Server == | ||
| + | |||
| + | * Percona Server - Drop-in replacement for MySQL. | ||
| + | | ||
| + | == XtraDB == | ||
| + | |||
| + | * XtraDB is 100% compliant with InnoDB features and SQL - another drop-in | ||
| + | |||
| + | == Percona XtraDB Cluster == | ||
| + | |||
| + | * Extremely easy to setup (less than one hour on initial trial) | ||
| + | * Very minor changes to database configuration | ||
| + | * Master-master-master setup - three or more masters | ||
| + | * Synchronous replication | ||
| + | * Can add / remove servers at anytime | ||
| + | * Cluster software is using third-party software, not MySQL' | ||
| + | |||
| + | == XtraBackup == | ||
| + | |||
| + | * Hot backups -- make backups while running server without affecting service | ||
| + | * InnoDB locks table while using mysqldump | ||
| + | * Throttles backups based on system load | ||
| + | |||
| + | == Monitoring == | ||
| + | |||
| + | * Plugins for Nagios, cacti | ||
| + | | ||
| + | == Utilities == | ||
| + | |||
| + | * Offer an amazing toolset: | ||
| + | * [[Percona Toolkit]] | ||
| + | * [[https:// | ||
| + | * [[https:// | ||
| + | |||
| + | == Configuration == | ||
| + | |||
| + | * [[http:// | ||
| + | * Ubuntu + Percona + my settings | ||
| + | * UTF-8 connections and collations by default | ||
| + | * InnoDB tables by default | ||
| + | * Strict startup checks -- will crash if InnoDB doesn' | ||
| + | * No table caching | ||
| + | * Slow query logs (more than one second) | ||
| + | * Compatible with existing Ubuntu configurations, | ||
| + | |||
| + | === Deployment === | ||
| + | |||
| + | * Maintain a 5.1 and a 5.5 release set | ||
| + | * Ubuntu repositories | ||
| + | * Gentoo ebuild in the works | ||
| + | * Migration is as simple as a MySQL upgrade (dump, restore tables) | ||
