Advanced DB Infrastructure : Hecate project

Hecate : integrated db infrastructure project

  • Statistics Agent (MySQL) - collects CPU, RAM, Load, MySQL statistics and ships this to Pool Registry service via SOAP call (see attached src.rpm);
  • Pool Registry service - keeps track of database pools (stats per node), provides load balancing and data transfer capabilities via exposed SOAP interface;
    • Pool Manager - keeps track of database pools;
    • Pool Registry Web UI - displays currently available pool list, node status, works as monitoring UI for collaboration;
    • Fast In-Memory Cache - reduces the Pool Registry <-> Data Source Adapter communications burden;
  • Data Source Adapter - announces Pools to Pool Registry, converts "generic" requests for datasets into db-specific commands, sends serialized data back to Pool Registry;
    • (de)serialization Factory - converts dataset requests into DB queries, serializes DB response;
    • DB native cache - provides caching capabilities, native to DB used in Pool;
    • Local Disk Cache - persistent local cache
  • Client Application - makes requests for data, using SOAP calls to Pool Registry. Data is fetched from either local or remote pool, transparently.
    • Two-way db access - direct local db access interface + distributed data access interface;
    • Local Load Balancing Interface - direct db access interface requires local load balancing information, retrieved from Pool Registry;
    • Local Disk Cache - persistent local cache, reduces the Client App <-> Pool Registry communications burden;