Db9
From Wikitech
(Difference between revisions)
(→CiviCRM) |
m |
||
| (2 intermediate revisions by one user not shown) | |||
| Line 2: | Line 2: | ||
|name=db9 | |name=db9 | ||
|location=pmtpa | |location=pmtpa | ||
| − | |usage= | + | |usage=mysql |
|memory= | |memory= | ||
|cpu= | |cpu= | ||
| Line 28: | Line 28: | ||
== Others == | == Others == | ||
| − | * [[ticket.wikimedia.org|otrs]] | + | * [[ticket.wikimedia.org|otrs]] - [migrated Dec 2011, db48 --> db49] |
* [[will.wikimedia.org/racktables/|racktables]] | * [[will.wikimedia.org/racktables/|racktables]] | ||
* [[wm09schols.wikimedia.org|scholarships]] | * [[wm09schols.wikimedia.org|scholarships]] | ||
Latest revision as of 08:27, 23 June 2012
| db9 | |
| Location: | pmtpa |
| Serial: | HFZW6C1 |
| Usage: | |
| Status | |
|---|---|
| Overal: | |
| Nagios?: | Nagios status |
| Hardware | |
| Software | |
Contents |
[edit] Active Databases
[edit] CiviCRM
- civicrm - migrated to db1008 and replicated to db1025 and storage 3 in Nov 2012
- drupal - migrated to db1008 and replicated to db1025 and storage 3 in Nov 2012
- dev_civicrm - migrated to db1008 and replicated to db1025 and storage 3 in Nov 2012
- dev_drupal - migrated to db1008 and replicated to db1025 and storage 3 in Nov 2012
[edit] Blogs
[edit] Others
- otrs - [migrated Dec 2011, db48 --> db49]
- racktables
- scholarships
- bugzilla3
[edit] Disk space issues as of 7/29/2011
The following was obtained by converting a slave to innodb_file_per_table, then a simple df -k within /a/sqldata: 91752 blog 853972 bugzilla3 798264 bugzilla4 466416 bugzilla_testing 3996536 civicrm [migrated] 3052 communicate 17388 communicate_civicrm 76440 contacts_civicrm 7076 contacts_drupal 3851328 dev_civicrm 2097040 dev_drupal 6604 dev_fundraising 63380 donateblog 2542624 drupal 657032 etherpad 28 faulkner [migrated] 37180 limesurvey 63492 newsblog 46132 observium 10992 ocs_wikimania2009 197330256 otrs [migrated in Dec 2011] 19556 outreach_civicrm 2136 outreach_drupal 58228 puppet 47376 racktables 337664 rt 5388 scholarships 9292 techblog 66380 testblog