Demo: High Availability of Data with DB2 Express-C
Making your Data Highly available with DB2 Express-C 9
Making your Data Highly Available with DB2 Express-C 9
Today, data is one of the most valuable assets in an organization. Continuous availability of data is paramount to a company’s operations. A data outage - short or long, planned or unplanned - can result in a loss of thousands or even millions of dollars, and business lost to the competition. Downtime is simply not an option.
Fault tolerant and redundant components are typically used for achieving high availability. You may have multiple web servers or application servers for redundancy but how about your database servers? One option is to use operating system or software failover clustering on the database servers. However this type of clustering alone isn’t enough, as it relies on shared-disk for database. And disks are more prone to failure compared to other components such as processors.
IBM DB2, known for delivering extreme data availability, and used by some of the largest corporations, is now available for even the smallest of businesses. DB2 Express-C is an entry-level full-feature data server for Linux and Windows. And like the enterprise versions, DB2 Express-C is designed to be highly resilient and more fault tolerant than other data servers. [The low-cost yearly subscription for] DB2 Express-C comes with built-in capabilities for high availability and disaster recovery, also known as the HADR feature.
You can use the DB2 Express-C HADR feature to setup a cluster with two database servers - a primary and a standby. Each server has its own set of disks for database storage. HADR continuously updates the standby database server. In case of an outage your applications can be automatically rerouted to the standby server. Once the failed server is brought back online, it updates itself, and becomes available to take over in case of an outage at the other server. And, because the DB2 HADR feature does not rely on shared-disk clustering, the standby database servers can be kept in the same location or be thousands of miles apart in disaster recovery sites.
DB2 Express-C [yearly subscription] includes the database clustering feature at no extra charge. Unlike other data servers, there are no expensive add-ons or options to buy. Simply license DB2 Express-C for both servers in your cluster and start protecting your data from outages resulting from natural disasters, hardware failures, software crashes, or even downtime from planned maintenance.
