Skip to content

Instantly share code, notes, and snippets.

@Antti

Antti/start_sql_servers.sh

Forked from tomlea/start_sql_servers.sh
Created March 3, 2011 14:18
Show Gist options
  • Save Antti/852833 to your computer and use it in GitHub Desktop.
Save Antti/852833 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
start_sql_servers.sh
rm -R $HOME/Desktop/server-{1,2}
mkdir -p $HOME/Desktop/server-{1,2}
mysql_install_db --datadir=$HOME/Desktop/server-1 && mysqld --server-id 1 -h ~/Desktop/server-1 --socket ~/Desktop/server-1/mysql.sock -P 10001 --log-bin &
mysql_install_db --datadir=$HOME/Desktop/server-2 && mysqld --server-id 2 -h ~/Desktop/server-2 --socket ~/Desktop/server-2/mysql.sock -P 10002 --master-port=10001 --master-host=127.0.0.1 --master-user=root &
alias sql-master="mysql -h127.0.0.1 -P10001 -uroot"
alias sql-slave="mysql -h127.0.0.1 -P10002 -uroot"
alias sql-master-admin="mysqladmin -h127.0.0.1 -P10001 -uroot"
alias sql-slave-admin="mysqladmin -h127.0.0.1 -P10002 -uroot"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment