Db1025

From Wikitech
(Difference between revisions)
Jump to: navigation, search
m
 
(4 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-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
+

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
Retrieved from "http://wikitech-old.wikimedia.org/index.php?title=Db1025&oldid=43868"
Personal tools
Namespaces

Variants
Actions
Navigation
Ops documentation
Wiki
Toolbox