Db1025

From Wikitech
(Difference between revisions)
Jump to: navigation, search
(added daemon stop/start notes)
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
db1025 status as of Thu Jul 28 08:14:47 PDT 2011
+
{{Server
 +
| location = eqiad
 +
| name =
 +
| serial =
 +
| usage = fundraisingdb
 +
| status =
 +
| memory =
 +
| cpu =
 +
| hdd =
 +
| os =
 +
| kernel =
 +
| usage_version =
 +
| server_group = MySQL eqiad
 +
| server_nodename = db1025.eqiad.wmnet
 +
}}
  
As of this time we're using db1025 as a testbed for mysql changes for the 'misc' cluster.
+
'''db1025''' is a 'misc' cluster slave of [[db1008]].  
  
There are currently two instances of mysql running:
+
* runs mysql 5.1 with innodb-file-per-table
 
+
* does LVM snapshots
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
+

Latest revision as of 18:59, 24 February 2012

db1025
Location: eqiad
Server group: MySQL eqiad
Node name: db1025.eqiad.wmnet
Usage: fundraisingdb
Status
Overal: Symbol question.png Unknown
Ganglia?: Ganglia status
Nagios?: Nagios status
Hardware
Software

db1025 is a 'misc' cluster slave of db1008.

  • runs mysql 5.1 with innodb-file-per-table
  • does LVM snapshots
Personal tools
Namespaces

Variants
Actions
Navigation
Ops documentation
Wiki
Toolbox