Db9
From Wikitech
(Difference between revisions)
(New page: {{server |name=db9 |location=pmtpa |usage=database |memory= |cpu= |serial=HFZW6C1 |kernel= |updated= |}} Dell_PowerEdge_1950) |
m |
||
| (10 intermediate revisions by 3 users not shown) | |||
| Line 2: | Line 2: | ||
|name=db9 | |name=db9 | ||
|location=pmtpa | |location=pmtpa | ||
| − | |usage= | + | |usage=mysql |
|memory= | |memory= | ||
|cpu= | |cpu= | ||
| Line 11: | Line 11: | ||
[[Dell_PowerEdge_1950]] | [[Dell_PowerEdge_1950]] | ||
| + | |||
| + | = Active Databases = | ||
| + | |||
| + | == [[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]] - migrated to db1008 and replicated to db1025 and storage 3 in Nov 2012 | ||
| + | * [[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]] - migrated to db1008 and replicated to db1025 and storage 3 in Nov 2012 | ||
| + | |||
| + | == Blogs == | ||
| + | |||
| + | * [[blog.wikimedia.org|blog]] | ||
| + | * [[techblog.wikimedia.org|techblog]] | ||
| + | |||
| + | == Others == | ||
| + | |||
| + | * [[ticket.wikimedia.org|otrs]] - [migrated Dec 2011, db48 --> db49] | ||
| + | * [[will.wikimedia.org/racktables/|racktables]] | ||
| + | * [[wm09schols.wikimedia.org|scholarships]] | ||
| + | * [[bugzilla.wikimedia.org|bugzilla3]] | ||
| + | |||
| + | == Disk space issues as of 7/29/2011 == | ||
| + | |||
| + | <pre> | ||
| + | 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 | ||
| + | |||
| + | </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
