Zero Downtime, Disaster Recovery, and Second Site Availability for Data Warehouses

Today’s successful enterprise recognizes the value of business information and depends on electronic data for sustaining and advancing business information. Electronic data is a key business asset, directly responsible for business revenue generation.

mLogica understands business data and delivers mission-critical Business Intelligence solutions driving day-to-day business decisions.

How can you grow your data warehouses, keep costs down and reliably backup and restore multi-terabytes of data to protect from catastrophic failures?

One of today’s biggest challenges is efficiently growing the data warehouse and providing high uptime and availability. Reliable backup and restore of 1TB-500TB of data is needed, as well as the ability to have data and service securely copied and available from a second site.

Traditional methods for backing a 1 TB – 500 TB data warehouse to tape simply doesn't cut it anymore: ever restore 20 TB from tape?

Some examples of large data warehouse challenges include:

• Backup and restore of 10 TB of warehoused data takes days using conventional backup tools that copy data to/from disk/tape

• High-availability is complex (and not very HA) and with 3^rd party software there are integration and compatibility issues

• Disaster recovery is very complex with logistics, synchronization, and connectivity issues. Often a DR site is passive and used only for “fire-drill” exercises 1-2 times per year

• Protection from data errors (bad data loaded into a data warehouse)

• Protection from administration errors (e.g.: delete the table)

• Providing full-size test-bed for new applications

• Data compliance (must continue to store data for compliance reasons)

• Litigation hold (records involved in litigation must not be deleted)

• Cross analytics of unstructured and structured data

• Long-term archiving

• Real-time data load

To address these challenges, mLogica provides a Business Continuity Suite (BCS), already used by many of our customers.  BCS, in conjunction with storage and replication software, is a solution proven to deliver reliable backups and rapid restores of multi-terabytes of data. Storage arrays with integrated ATA drives allow customers to efficiently grow their data warehouses while keeping costs down.

BCS has undergone extensive validation testing. The observed test results confirm the integration of Virtual Backup and Virtual Restore with storage and replication software works under various loads and delivers excellent results across various fault conditions.

mLogica provides the BCS and specialized consulting services to protect your data warehouse from data loss, service loss, and to extend data protection to other data types.