A cornucopia of MySQL; strategy and alternatives for 14.04

Registered by James Page

[RATIONALE]
Percona and MariaDB are in the process of entering Debian/Ubuntu with viable MySQL alternatives.

This potentially includes Galera based Active/Active packages.

[GOAL]
Oracle MySQL to remain in main for 14.04, promotion of one active/active mysql solution as preferred/most tested/maybe in main.

Blueprint information

Status:
Complete
Approver:
Patricia Gaughen
Priority:
High
Drafter:
Ubuntu Server
Direction:
Approved
Assignee:
James Page
Definition:
Approved
Series goal:
Accepted for trusty
Implementation:
Implemented
Milestone target:
milestone icon ubuntu-14.04
Started by
James Page
Completed by
James Page

Whiteboard

[UPDATES]
PXC blocked on OpenSSL licensing issues in Galera - raised upstream.

[UDS DISCUSSION TOPICS]
http://pad.ubuntu.com/uds-1311-servercloud-1311-mysql-alternatives

[USER STORIES]
Janet is deploying a new web application that supports use of active/active mysql. She's able to deploy percona-cluster direct from the Ubuntu archive on Ubuntu 14.04 to support this requirement.

Tony works for a company that has mandated use of Oracle MySQL; he's able to deploy a fully supported solution direct from the Ubuntu archive on Ubuntu 14.04.

[ASSUMPTIONS]
Percona packaging will enter Debian/Ubuntu before 14.04 release.
MySQL 5.5 remains upstream supported until 2018, so no hard requirement for transition to 5.6 in 14.04 dev cycle.

[RISKS]

[IN SCOPE]
MySQL (inc re-sync with Debian)
MariaDB
Percona Server

[OUT OF SCOPE]
Changing the vendor of default, supported MySQL solution
Changing the version of MySQL for 14.04 - 5.5 is supported through to 2018.

[USER ACCEPTANCE]

[RELEASE NOTE/BLOG]
Ubuntu 14.04 continues to provide MySQL 5.5 as the default, fully supported MySQL implementation. Initial MySQL 5.6 packages are also provided as an alternative for users in Ubuntu universe

Ubuntu 14.04 includes Percona XtraDB Cluster 5.5, an Active/Active MySQL implementation based on Galera, in Ubuntu universe.

Ubuntu 14.04 also includes MariaDB 5.5, a drop-in MySQL alternative, in Ubuntu universe.

(?)

Work Items

Work items for ubuntu-13.12:
Setup PPA for Percona packaging pre-entry into Debian/Ubuntu: DONE
[otto] Package mariadb 5.5 for Debian: DONE

Work items for ubuntu-14.02:
[otto] mariadb-5.5 5.5.35 -> Debian: DONE

Work items for ubuntu-14.03:
[james-page] Percona Cluster package -> Ubuntu: DONE
[racb] MRE for mysql-5.5: DONE
[james-page] MRE for mysql-5.6: DONE
[racb] Re-sync mysql packaging with Debian: DONE

Work items for ubuntu-14.04:
percona-cluster charm - switch to distro packages, update for 14.04: DONE
[james-page] MySQL 5.6 into Debian/Ubuntu: DONE
MySQL 5.5->5.6 transition for 14.04: POSTPONED
MRE for percona-cluster/percona-xtrabackup: POSTPONED
[george] Percona Server 5.5 & 5.6 package -> Debian (retarget for 14.10): POSTPONED

Dependency tree

* Blueprints in grey have been implemented.