Db1025

db1025 status as of Thu Jul 28 08:14:47 PDT 2011

As of this time we're using db1025 as a testbed for mysql changes for the 'misc' cluster.

There are currently two instances of mysql running:

1) mysql-at-facebook (5.1) running on 3306

purpose: standalone/writable for Arthur's crew to test civicrm with 5.1
dumped: 2011-07-22
conf: /usr/local/mysql-at-facebook/my.cnf
datadir: /a/sqldata
innodb_file_per_table

start daemon: /usr/local/mysql/bin/mysqld_safe &
stop daemon: killall /usr/local/mysql/bin/mysqld
client access: /usr/local/mysql/bin/mysql --socket /a/tmp50/mysqld50.sock --port 3307 -uroot -p

2) mysql-5.0.51a-linux-x86_64-glibc23 running on 3307

purpose: 5.0 slave with file-per-table for emergency use if we overrun db10
conf: /usr/local/mysql/my.cnf
datadir: /a/sqldata50
innodb_file_per_table

start daemon: /usr/local/mysql-at-facebook/bin/mysqld_safe &
stop daemon: killall /usr/local/mysql-at-facebook/libexec/mysqld
client access: /usr/local/mysql/bin/mysql --socket /a/tmp50/mysqld50.sock --port 3307 -uroot -p

There is a full dump from db10 on 7/22/2010 at /a/dumps.

puppet has been temporarily disabled during my.cnf testing