Db1025

From Wikitech
(Difference between revisions)
Jump to: navigation, search
m
(update after db1025 reconfigured for normal operation)
Line 1: Line 1:
db1025 status as of Thu Jul 28 08:14:47 PDT 2011
+
db1025 is a 'misc' cluster slave of db9
 
+
it lives in eqiad
As of this time we're using db1025 as a testbed for mysql changes for the 'misc' cluster.
+
it runs mysql 5.1 with innodb-file-per-table
 
+
it does LVS snapshots
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-at-facebook/bin/mysql -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
+

Revision as of 19:59, 8 September 2011

db1025 is a 'misc' cluster slave of db9 it lives in eqiad it runs mysql 5.1 with innodb-file-per-table it does LVS snapshots

Personal tools
Namespaces

Variants
Actions
Navigation
Ops documentation
Wiki
Toolbox