I need to install Mysql-server-5.6 in my ubuntu development server 12.04. Now it is running percona-server5.5. How can i upgrade this to mysql-5.6 ?
I have prepared experimental PPA with MySQL 5.6 packages based on MySQL 5.5 Debian packages. No guarantee that it will work right away, but I would be grateful if you can try it and report back success (or failure).
The PPA can be found at: https://launchpad.net/~ondrej/+archive/mysql-experimental
There's also a MySQL 5.5 PPA with latest upstream release found at: https://launchpad.net/~ondrej/+archive/mysql
I have just written a blog post about upgrading mysql on ubuntu 12.04. You can find my post at http://www.peterchen.net/2013/02/20/en-how-to-install-mysql-5-6-on-ubuntu-12-04-precise/. Hope this will help you.
this tutorial shows you in details how to.. But note that this is done to upgrade to 5.5 i think it's the same for 5.6
I think you should stay with Percona. Both Percona and MariaDB are much better supported, especially on Ubuntu, than the Oracle MySQL distributions. Going the Oracle route will lead to many incompatibilities with how software is being managed, configured, started/stopped, etc. on Ubuntu (or other debian derived distros).
5.6 is very new (as of Feb 2013 the package minor is alpha-60) so the apt-get method is not yet fully supported (for server-5.6) by Percona, as far as I can tell. You can however download the 5.6 *.deb packages for Ubuntu 12.04 from percona.com/downloads/ and then use 'sudo dpkg -i' locally to install them.
I would strongly advise against installing RPM packages on Ubuntu/Debian due to many incompatibility issues that may arise.
Another alternative, and IMHO a better one, is to stay with 5.5 (latest is actually 5.5.29 so it already includes many of the goodies from 5.6) for a while longer, and switch to 5.6 (package name: percona-server-server) once it is out of alpha. It shouldn't be too long now. To do so follow the instructions here