install-mysql-5.6-on-travis.yml

install:
  - "sudo apt-get remove mysql-common mysql-server-5.5 mysql-server-core-5.5 mysql-client-5.5 mysql-client-core-5.5"
  - "sudo apt-get autoremove"
  - "sudo apt-get install libaio1"
  - "wget -O mysql-5.6.14.deb http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.14-debian6.0-x86_64.deb/from/http://cdn.mysql.com/"
  - "sudo dpkg -i mysql-5.6.14.deb"
  - "sudo cp /opt/mysql/server-5.6/support-files/mysql.server /etc/init.d/mysql.server"
  - "sudo ln -s /opt/mysql/server-5.6/bin/* /usr/bin/"
  # some config values were changed since 5.5
  - "sudo sed -i'' 's/table_cache/table_open_cache/' /etc/mysql/my.cnf"
  - "sudo sed -i'' 's/log_slow_queries/slow_query_log/' /etc/mysql/my.cnf"
  - "sudo sed -i'' 's/basedir[^=]\\+=.*$/basedir = \\/opt\\/mysql\\/server-5.6/' /etc/mysql/my.cnf"
  - "sudo /etc/init.d/mysql.server start"

now mysql 5.6.17, line 5 is:

• "wget -O mysql-5.6.14.deb http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.17-debian6.0-x86_64.deb/from/http://cdn.mysql.com/"

You may also manually set sql_mode to 5.6 default:

• mysql -e "SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES'"

May I suggest installing from the official repos (recently released): http://mysqlrelease.com/2014/05/theyre-here-official-mysql-repos-for-debian-and-ubuntu/

Thanks for the gist! I've got trouble getting it to work though:

Selecting previously unselected package mysql.
(Reading database ... 68740 files and directories currently installed.)
Unpacking mysql (from mysql-5.6.14.deb) ...
Setting up mysql (5.6.14) ...
sed: -e expression #1, char 35: unknown option to `s'
Starting MySQL
... * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).

Full output here:
https://travis-ci.org/brick/geo/builds/36138495

Any idea?

Commenting here since this is high up in the Google results for "travis mysql 5.6".

With Travis' new Trusty infra beta, installing mysql5.6 can be done in only a couple of lines. For an example, see:
mozilla/treeherder#1080

At least for now this does unfortunately mean giving up on the caching available with the container infra.

We can use MySQL 5.6 on travis now.

e.g.

# travis.yml

dist: trusty
sudo: required
addons:
  apt:
    packages:
    - mysql-server-5.6
    - mysql-client-core-5.6
    - mysql-client-5.6

See https://docs.travis-ci.com/user/database-setup/#MySQL-5.6 for reference.

(@drogus Thank you for create this gist. )