Connect to multiple remote MySQL database and database server (host) choice

[andremacola]

It is possible when creating a site to determine in which database host?

For example. In ee configuration file:

dbhost1: mysql.myhost.com
dbroot1: root
dbpass1: mypassword

dbhost2: mysql.myhost.com
dbroot2: root
dbpass2: mypassword

ee site create mywebsite.com --wpsc --dbhost1
ee site create mywebsite2.com --wpsc --dbhost2

[rahul286]

Very nice idea! 👍

Can be handled with #142

[rahul286]

Note to myself:

We might need - YAML and https://github.com/0k/shyaml

[rahul286]

ini parser

1. https://github.com/paulchakravarti/ini-parser
2. https://github.com/rudimeier/bash_ini_parser

json

1. https://github.com/kristopolous/TickTick
   2.. http://stackoverflow.com/questions/3858671/unix-command-line-json-parser
2. https://github.com/benbernard/RecordStream

[MiteshShah]

@andremacola

EasyEngine 2.0.2 support remote mysql
Tutorials: https://github.com/rtCamp/easyengine/wiki/Remote-MySQL

For example. In ee configuration file:

dbhost1: mysql.myhost.com
dbroot1: root
dbpass1: mypassword

dbhost2: mysql.myhost.com
dbroot2: root
dbpass2: mypassword

ee site create mywebsite.com --wpsc --dbhost1
ee site create mywebsite2.com --wpsc --dbhost2

Instead of this we suggest create multiple .my.cnf files like

touch ~/.my.cnf1 ~/.my.cnf2 
ln -s ~/.my.cnf1 ~/.my.cnf

In this way your ~/.my.cnf is point to the ~/.my.cnf1 and when you want to used second server just update softlink