Database plans for Ubuntu 14.10

Registered by Patricia Gaughen

[RATIONALE]
Ensure mysql support is up-to-date and rock-solid.

[GOAL]
Transition to mysql-5.6 as default.
Entry of Percona Server into the archive.

Blueprint information

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

Related branches

Sprints

Whiteboard

[UOS]
http://pad.ubuntu.com/uos-1406-ubuntu-server-database-plans-for-1410

[USER STORIES]
Toby wants to take advantage of the new features in mysql-5.6; he's able todo this using Ubuntu 14.10 as its the default, supported version of MySQL.

Mathilda wants to use some of the new storage engines avaliable in Percona Server 5.6 - this is avaliable in Ubuntu 14.10 and she's able to install and use this easily.

Gustavo wants to use the latest stable release of MongoDB - he's able to deploy this using Ubuntu 14.10.

[ASSUMPTIONS]
MySQL 5.6 ready for prime-time and default use.
Transition can happen within 1 cycle.

[RISKS]
Lots of work, only 4 months left.

[IN SCOPE]
MariaDB
MySQL
Percona Server
Percona XtraDB Cluster
MongoDB

[OUT OF SCOPE]

[USER ACCEPTANCE]
MySQL 5.5 and compatible alternatives no longer in archive.
Upgrade path for 5.5 users to 5.6 on upgrade to 14.10.

[RELEASE NOTE/BLOG]
Ubuntu 14.10 includes MySQL 5.6 as the default version of MySQL; MySQL 5.5 has been removed from the archive for this release and existing installations will be upgraded upon migration to 14.10.

Ubuntu 14.10 includes the latest stable release of MongoDB (2.6.x). Users are recommended to read the upstream upgrade notes, specifically pre-flight checks and manual upgrade steps, before upgrading to Ubuntu 14.10.

(?)

Work Items

Work items for ubuntu-14.06:
[james-page] Update mongodb from 2.4->2.6: DONE
[james-page] PXC update for 14.04: DONE

Work items for ubuntu-14.09:
[james-page] interlock with the mysql charm owners: DONE
[racb] Complete virtual-mysql-* implementation: POSTPONED
[racb] mysql 5.6 in main, drop mysql-5.5: POSTPONED
[james-page] update percona-xtradb-cluster (PXC) to 5.6: POSTPONED
[gl-az] package percona-server (PS) 5.6 for Ubuntu: POSTPONED

Work items for ubuntu-14.10:
[mattgriffin] address automated testing gaps for PXC: TODO
[mattgriffin] submit for MRE for PXC 5.5 for 14.04: POSTPONED
[gl-az] percona to take ownership of charm for PXC: TODO
[gl-az] percona charm for PS: POSTPONED
[racb] Coordinate /var/lib/mysql -> /var/lib/<fork> ownership migration: POSTPONED
[akhil-mohan] Handle /var/lib/<fork> migration for mysql-5.6: POSTPONED
[gl-az] Handle /var/lib/<fork> migration for Percona: POSTPONED
[otto] Handle /var/lib/<fork> migration for mariadb: POSTPONED

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.