MySQL from Docker or from the Host

docker-compose.yml

php:
  image: webgriffe/magento1-dev
  volumes_from:
    - unison
  links:
    - mysql
    - memcached
    - blackfire_agent:blackfire
  environment:
    HOST_IP: 192.168.99.1
    VIRTUAL_HOST: mymagentostore.docker
    APACHE_DOC_ROOT: /unison
  ulimits:
    nofile: 10240
  working_dir: /unison

unison:
  image: leighmcculloch/unison
  environment:
    - UNISON_VERSION=2.48.3
  ports:
    - "5000:5000"

mysql-data:
  image: tianon/true
  volumes:
    - /var/lib/mysql

mysql:
  image: mysql:5.5
  volumes_from:
    - "mysql-data"
  environment:
    MYSQL_ROOT_PASSWORD: mypass

memcached:
  image: memcached

blackfire_agent:
    image: blackfire/blackfire
    environment:
        # Exposes the host BLACKFIRE_SERVER_ID and TOKEN environment variables.
        # You can also use global environment credentials :
        # BLACKFIRE_SERVER_ID: SERVER-ID
        # BLACKFIRE_SERVER_TOKEN: SERVER-TOKEN
        - BLACKFIRE_SERVER_ID
        - BLACKFIRE_SERVER_TOKEN
        - BLACKFIRE_CLIENT_ID
        - BLACKFIRE_CLIENT_TOKEN

local.xml.mysql-from-docker.xml

<?xml version="1.0"?>
<!--
/**
 * Magento
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Academic Free License (AFL 3.0)
 * that is bundled with this package in the file LICENSE_AFL.txt.
 * It is also available through the world-wide-web at this URL:
 * http://opensource.org/licenses/afl-3.0.php
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to [email protected] so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade Magento to newer
 * versions in the future. If you wish to customize Magento for your
 * needs please refer to http://www.magentocommerce.com for more information.
 *
 * @category   Mage
 * @package    Mage_Core
 * @copyright  Copyright (c) 2008 Irubin Consulting Inc. DBA Varien (http://www.varien.com)
 * @license    http://opensource.org/licenses/afl-3.0.php  Academic Free License (AFL 3.0)
 */
-->
<config>
    <global>
        <install>
            <date><![CDATA[Fri, 01 Jan 2016 16:21:53 +0000]]></date>
        </install>
        <crypt>
            <key><![CDATA[99cad5332733cb45ca61c2927343dd1a]]></key>
        </crypt>
        <disable_local_modules>false</disable_local_modules>
        <resources>
            <db>
                <table_prefix></table_prefix>
            </db>
            <default_setup>
                <connection>
                    <host><![CDATA[mysql]]></host>
                    <username><![CDATA[root]]></username>
                    <password><![CDATA[mypass]]></password>
                    <dbname><![CDATA[mymagestore]]></dbname>
                    <initStatements><![CDATA[SET NAMES utf8]]></initStatements>
                    <model><![CDATA[mysql4]]></model>
                    <type><![CDATA[pdo_mysql]]></type>
                    <pdoType></pdoType>
                    <active>1</active>
                </connection>
            </default_setup>
        </resources>
        <session_save><![CDATA[memcached]]></session_save>
        <session_save_path><![CDATA[memcached:11211]]></session_save_path>
        <cache>
            <backend>memcached</backend>
            <servers>
                <server>
                    <host><![CDATA[memcached]]></host>
                    <port><![CDATA[11211]]></port>
                    <persistent><![CDATA[1]]></persistent>
                </server>
            </servers>
        </cache>
    </global>
    <admin>
        <routers>
            <adminhtml>
                <args>
                    <frontName><![CDATA[admin]]></frontName>
                </args>
            </adminhtml>
        </routers>
    </admin>
</config>

local.xml.mysql-from-host.xml

<?xml version="1.0"?>
<!--
/**
 * Magento
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Academic Free License (AFL 3.0)
 * that is bundled with this package in the file LICENSE_AFL.txt.
 * It is also available through the world-wide-web at this URL:
 * http://opensource.org/licenses/afl-3.0.php
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to [email protected] so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade Magento to newer
 * versions in the future. If you wish to customize Magento for your
 * needs please refer to http://www.magentocommerce.com for more information.
 *
 * @category   Mage
 * @package    Mage_Core
 * @copyright  Copyright (c) 2008 Irubin Consulting Inc. DBA Varien (http://www.varien.com)
 * @license    http://opensource.org/licenses/afl-3.0.php  Academic Free License (AFL 3.0)
 */
-->
<config>
    <global>
        <install>
            <date><![CDATA[Fri, 01 Jan 2016 16:21:53 +0000]]></date>
        </install>
        <crypt>
            <key><![CDATA[99cad5332733cb45ca61c2927343dd1a]]></key>
        </crypt>
        <disable_local_modules>false</disable_local_modules>
        <resources>
            <db>
                <table_prefix></table_prefix>
            </db>
            <default_setup>
                <connection>
                    <host><![CDATA[192.168.99.1]]></host>
                    <username><![CDATA[root]]></username>
                    <password><![CDATA[mypass]]></password>
                    <dbname><![CDATA[mymagestore]]></dbname>
                    <initStatements><![CDATA[SET NAMES utf8]]></initStatements>
                    <model><![CDATA[mysql4]]></model>
                    <type><![CDATA[pdo_mysql]]></type>
                    <pdoType></pdoType>
                    <active>1</active>
                </connection>
            </default_setup>
        </resources>
        <session_save><![CDATA[memcached]]></session_save>
        <session_save_path><![CDATA[memcached:11211]]></session_save_path>
        <cache>
            <backend>memcached</backend>
            <servers>
                <server>
                    <host><![CDATA[memcached]]></host>
                    <port><![CDATA[11211]]></port>
                    <persistent><![CDATA[1]]></persistent>
                </server>
            </servers>
        </cache>
    </global>
    <admin>
        <routers>
            <adminhtml>
                <args>
                    <frontName><![CDATA[admin]]></frontName>
                </args>
            </adminhtml>
        </routers>
    </admin>
</config>