Db9
From Wikitech
(Difference between revisions)
m |
|||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
|name=db9 | |name=db9 | ||
|location=pmtpa | |location=pmtpa | ||
| − | |usage= | + | |usage=mysql |
|memory= | |memory= | ||
|cpu= | |cpu= | ||
| Line 16: | Line 16: | ||
== [[civicrm.wikimedia.org|CiviCRM]] == | == [[civicrm.wikimedia.org|CiviCRM]] == | ||
| − | * [[civicrm.wikimedia.org|civicrm]] | + | * [[civicrm.wikimedia.org|civicrm]] - migrated to db1008 and replicated to db1025 and storage 3 in Nov 2012 |
| − | * [[civicrm.wikimedia.org|drupal]] | + | * [[civicrm.wikimedia.org|drupal]] - migrated to db1008 and replicated to db1025 and storage 3 in Nov 2012 |
| − | * [[dev.civicrm.wikimedia.org|dev_civicrm]] | + | * [[dev.civicrm.wikimedia.org|dev_civicrm]] - migrated to db1008 and replicated to db1025 and storage 3 in Nov 2012 |
| − | * [[dev.civicrm.wikimedia.org|dev_drupal]] | + | * [[dev.civicrm.wikimedia.org|dev_drupal]] - migrated to db1008 and replicated to db1025 and storage 3 in Nov 2012 |
== Blogs == | == Blogs == | ||
| 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]] | ||
| Line 35: | Line 35: | ||
== Disk space issues as of 7/29/2011 == | == Disk space issues as of 7/29/2011 == | ||
| − | The following was obtained by converting a slave to innodb_file_per_table, then df -k within /a/sqldata: | + | <pre> |
| + | The following was obtained by converting a slave to innodb_file_per_table, | ||
| + | then a simple df -k within /a/sqldata: | ||
91752 blog | 91752 blog | ||
| Line 41: | Line 43: | ||
798264 bugzilla4 | 798264 bugzilla4 | ||
466416 bugzilla_testing | 466416 bugzilla_testing | ||
| − | 3996536 civicrm | + | 3996536 civicrm [migrated] |
3052 communicate | 3052 communicate | ||
17388 communicate_civicrm | 17388 communicate_civicrm | ||
| Line 52: | Line 54: | ||
2542624 drupal | 2542624 drupal | ||
657032 etherpad | 657032 etherpad | ||
| − | 28 faulkner | + | 28 faulkner [migrated] |
37180 limesurvey | 37180 limesurvey | ||
63492 newsblog | 63492 newsblog | ||
46132 observium | 46132 observium | ||
10992 ocs_wikimania2009 | 10992 ocs_wikimania2009 | ||
| − | 197330256 otrs | + | 197330256 otrs [migrated in Dec 2011] |
19556 outreach_civicrm | 19556 outreach_civicrm | ||
2136 outreach_drupal | 2136 outreach_drupal | ||
| Line 66: | Line 68: | ||
9292 techblog | 9292 techblog | ||
66380 testblog | 66380 testblog | ||
| + | |||
| + | </pre> | ||
Latest revision as of 08:27, 23 June 2012
| db9 | |
| Location: | pmtpa |
| Serial: | HFZW6C1 |
| Usage: |  |
| Status | |
|---|---|
| Overal: |  Unknown
|
| 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
