Database Replication for Reporting and BI

Most large-scale production environments include multiple database servers, multiple cores per CPU, gigabytes of memory and terabytes of disk storage. Databases deployed to serve specific applications and user communities frequently evolve into much larger, more strategic resources supporting numerous applications and multiple end user departments. DBAs and IT managers are continually challenged to meet application performance expectations in the face of this increases demand, and to scale performance reasonably as database usage evolves. Database replication is a useful technique for improving the performance of production open source databases while making near real time information available to reporting and business intelligence applications.

Deliver Critical Information to Business Users - In Real-time

EnterpriseDB provides powerful database replication products and services. Postgres Plus^® Advanced Server supports asynchronous replication between Postgres Plus, Oracle^® and PostgreSQL databases. Asynchronous replication means that your replication databases are updated at near real time intervals without degrading the performance of your production databases. Your production applications benefit from improved performance while your reports and dashboards have access to the most current business information. Using Postgres Plus for your replication strategy gives you the rock-solid foundation of Postgres database technology at a fraction of the cost of proprietary database replication alternatives.

In addition to delivering world-class database replication products, EnterpriseDB also offers specialized replication consulting services. Our domain experts can help you design a replication strategy that fits your current needs and gives you the flexibility to adapt to changing conditions. We also frequently help customers to implement their chosen replication strategies, providing the vital hands-on knowledge transfer that helps DBAs become proficient in managing their replication infrastructures.

Postgres Plus Replication Server

Postgres Plus Replication Server replicates data across the enterprise in near real time to meet a wide array of business challenges. Data can be replicated to or from heterogeneous Postgres Plus, Oracle and PostgreSQL databases across distant geographies, complex enterprise data infrastructures, and heterogeneous operating platforms, including Linux^®, Solaris^®, and Windows^®. PostgresPlus Replication Server enables enterprises to:

• Run reporting and other applications in Oracle environments at a fraction of Oracle's cost
• Ensure availability and seamless disaster recovery of critical database services
• Speed database performance
• Transfer data across heterogeneous data sources while maintaining transactional integrity
• Migrate to updated or upgraded versions of Postgres Plus Advanced Server with no database downtime or risk to data

Key features of the Postgres Plus Replication Server include:

• The Replication Console, which enables the configuration, monitoring, and maintenance of multiple replicated servers from a single graphical user interface
• Single-master, multi-slave replication, which enables the deployment of multiple warm standby databases, either locally or remotely
• Snapshot replication or scheduled incremental replication, which provides increased flexibility

Learn more about Postgres Plus Advanced Server.

Replication Setup Service

EnterpriseDB's Replication Setup service leverages our expertise to help you define and implement a replication solution that's tailored to your requirements. Whether you are offloading production data to reporting servers, synchronizing warehouse information or optimizing your failover/standby capabilities, Replication Setup delivers the help you need, when you need it.

EnterpriseDB's Replication Setup engagement typically includes:

• Identification of candidate databases for replication
• Identification of the appropriate technology and implementation for replication
• Analysis of uptime requirements and data latency
• Formulation of the replication strategy
• Implementation of the replication strategy
• Testing of the replication infrastructure
• Staff training on the replication infrastructure

Learn more about EnterpriseDB's Replication Setup service.

What Should I Do Now?

Depending on your business needs and timing considerations, we recommend the following next steps:

Contact us directly. This is the fastest and easiest way to learn more. Our sales engineering team can help you determine the quickest path to optimizing your Postgres databases.

Download and evaluate Postgres Plus Advanced Server. By evaluating our software, your technologists can quickly determine the depth of our Oracle compatibility and the completeness of our Postgres database foundation.

Below are resources that will help IT managers learn more about how organizations are leveraging EnterpriseDB's replication solutions today, as well as educational content for technologists about using Postgres replication strategies to improve performance and database availability.

IT Managers		DBAs, Architects, and Developers
	FTD Case Study Learn how FTD, the worldwide leader in floral delivery, used Postgres Plus to implement a sophisticaned Oracle replication, reporting and BI infrastructure in six weeks.		Delivering Oracle Compatibility This EnterpriseDB white paper provides an overview of the five key areas of Oracle compatibility provided by Postgres Plus Advanced Server.
	The Explosion in DBMS Choice This white paper, written by industry expert Curt Monash, provides an overview and recommendations for usage of open source databases.		High Availability Database Solutions for PostgreSQL and Postgres Plus This EnterpriseDB white paper discusses database replication in the context of high availability database strategies and includes a useful discussion of the Postgres Plus Replication Server architecture.
	hi5 Networks Case Study Learn how hi5 Networks, the leading social network in more than 25 countries with over 80 million registered users, dramatically improved application scalability and performance by leveraging EnterpriseDB's packaged services and expert consulting.		PostgreSQL Replication Solutions This EnterpriseDB webcast, conducted by Bruce Momjian, PostgreSQL Community Leader, outlines the primary requirements for database replication and discusses solutions available in PostgreSQL, including those currently implemented and those in development.