IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 2 and Version 3 of IppDatabases


Ignore:
Timestamp:
Mar 10, 2011, 11:53:31 AM (15 years ago)
Author:
Serge CHASTEL
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • IppDatabases

    v2 v3  
    1 This is the wiki page giving some details about the various databases:
     1This is the wiki page giving some details about the different databases.
     2
     3Note: information_schema, log, mysql, and test are MySQL databases.
    24
    35|| Host || Database name || Replication host || Manager ||
     6|| ippdb00 || nebulous || ippdb02 || * ||
     7|| ippdb01 || gpc1 || ipp001 || * ||
     8|| ippc17 || ippRequestServer || ippc19 || * ||
     9|| ippdb01 || isp || || Heather ||
     10|| ippdb01 || czardb || || Roy ||
     11|| ippdb01 || ippToPsps || || Roy ||
     12|| ippdb01 || detection_efficiency || || Bill ||
     13|| ippdb01 || Rw10BH96 || || Bill ||
     14|| ippc19 || ''ippRequestServer'' || - || Replicated ||
    415
     16Note: Databases on ipp001 are not shown (development cluster).
    517
    6 
    7 = By database =
    8  * nebulous. Master is on ippdb00, replicated on ippdb02.
    9  * gpc1. Master is on ippdb01, replicated on ipp001.
    10  * ipprequestServer is on ippc17, replicated on ippc19.
    11  * isp is on ippdb01. Managed by Heather.
    12  * czardb is on ippdb01. Managed by Roy.
    13  * ippToPsps is on ippdb01. Managed by Roy.
    14  * detection_efficiency on ippdb01 is managed by Bill
    15  * Rw10BH96 on ippdb01 is managed by Bill
    16  * MD01 is on ippdb01
    17  * MD02 is on ippdb01
    18  * MD03 is on ippdb01
    19  * MD04 is on ippdb01
    20  * beaumont is on ippdb01
    21  * eamtest is on ippdb01 and likely managed by Gene.
    22  * ippadmin is on ippdb01
    23 
    24 = By MySQL server =
    25  * ippdb00:
    26  * ippdb01:
    27  * ippc17:
     18Other:
     19|| Host || Database name || Replication host || Manager ||
     20|| ippdb01 || MD01 || || ||
     21|| ippdb01 || MD02 || || ||
     22|| ippdb01 || MD03 || || ||
     23|| ippdb01 || MD04 || || ||
     24|| ippdb01 || beaumont || || ||
     25|| ippdb01 || czwtestA || || ||
     26|| ippdb01 || czwtestB || || ||
     27|| ippdb01 || eamtest || || ||
     28|| ippdb01 || ippadmin || || ||
    2829
    2930Backup policy is defined [wiki:DatabaseBackups here].