Systems/Database Administration

Consort offers a managed database service utilizing Oracle11g, Microsoft SQL Server 2008, IBM DB2. The database service is available in three predefined architectural levels (low, medium, and high).

Services Description

Consort will install, configure, and maintains your choice of database platform and ensure services and components of the associated applications are functioning properly at all times.

Support can take the form of a "passive" database administrator role or a completely configured and managed database solution. With the passive support option Consort will offer assistance and support as needed.

Managed Database Services

Consort also provide database clustering services to achieve high availability, easier scalability, and easier manageability.
A database cluster is a group of independent database servers managed as a single system. High availability is achieved through the elimination or reduction of single points of failure. The system can survive most hardware or software failures through the utilization of redundant components. Essentially, there is an on-line spare of each component that can automatically take over in the event of a failure.
Consort's database services manage two, 2-node active-passive fail-over clustering services.
Clustering succeeds through the shared used of a disk array, Two identically configured systems have direct access to an external mirrored disk array. Only one system is actually 'active' at any one time: the other system is running and ready to take over in the event of a hardware or software failure on the live system; it is considered to be the 'passive system. This kind of configuration is commonly referred to as active/passive. Each server checks the uptime of the other via "heartbeats" If the active server is halted for maintenance purposes, or due to a system crash, the passive machine will take over and provide the database service. This process of one server automatically shifting workload to another is call "fail-over".

System Requirements

All systems are configured for dedicated databases use only. No other applications, such as web server applications, can exist on the database system unless the application is specifically related to the functionality of the database.

Determining the system requirements will necessitate a thorough analysis of many different factors. some of these factors include:

  • Concurrent user connections
  • Size of data
  • Type of transactions (OLTP, DSS or hybrid)
  • Number of transactions to be processed during peak hours
  • Frequency and size of batch jobs (often needs additional CPU time)
  • Required response time (fastest CPU will give your the fastest response)