Risk
9/24/2010
09:39 PM
Connect Directly
Twitter
RSS
E-Mail
50%
50%

EnterpriseDB Adds Integrated Replication, Hot Standby

Postgres Plus gains features from updated open source database PostgreSQL 9.0.

8 Big Data Deployments In Detail
(click image for larger view)
8 Big Data Deployments In Detail
EnterpriseDB has incorporated the 9.0 version of the open source PostgreSQL database system, including built-in replication, into its commercial system, Postgres Plus.

Built-in replication needed to be added to the Postgres Plus to make it competitive with commercial systems, which already contain the feature, acknowledged Robin Schumacher, EnterpriseDB director of product strategy. The PostgreSQL open source project serves as the code base for Postgres Plus. Project managers added the feature in the 9.0 version, which was released on Sept. 20, and EnterpriseDB said its Postgres Plus product supported the new code base immediately.

With built-in replication, a second database server can serve as a satellite or secondary system to a master system. The replicated data set is created by forwarding the activity captured in the write-ahead log to the secondary system. The replication will trail slightly the master copy. The streaming replication method is asynchronous but the two database servers will maintain identical data sets and one can be recovered from the other, Schmacher said in an interview.

The built-in replication gives Postgres Plus a greater ability to scale out to more servers and fail-over more easily in case of database failure, giving Postgres Plus a better high availability profile.

The 9.0 version also allows the master database to query a standby system, giving both the open source system and Postgres Plus hot-standby capability. "Built in replication and hot standby have been the most requested features for many years," said Simon Riggs, lead contributor to hot standby in the PostgreSQL open source project and CTO of of 2ndQuadrant, a firm that supplies technical support for PostgreSQL systems. Riggs made the comment in the announcement of the 9.0 version by the open source project.

Catching up with built-in replication might sound like just another trailing edge feature of open source databases, sometimes cited for their slow adoption rate inside the enterprise. But any additional features that match the commercial systems are heeded in the case of Postgres Plus because it contains an Oracle compatibility layer, allowing most applications that run under Oracle to also run under Postgres Plus, Schumacher said. Postgres Plus recognizes Oracle's PL/SQL variant of the SQL data access language. Stored procedures and triggers in Oracle can be transferred to and run in Postgres Plus, he said.

Among other things, the EnterpriseDB system also works on servers running the 64-bit Windows Server operating system, which along with Linux, is one of the fastest growing operating systems in the data center. Postgres Plus also supports the ability of the 9.0 version of the open source code to continue running while an upgrade or patch to the system takes place. In the past, an upgrade required the data to be transferred to an auxiliary system, then back after the upgrade had taken place, Schumacher said.

The 9.0 version of the open source code base was generated by about 100 core contributors and another 150 occasional contributors. PostgreSQL meets the ACID (atomicity, consistency, isolation, and durability) standard for relational systems, guaranteeing transaction integrity.

Comment  | 
Print  | 
More Insights
Register for Dark Reading Newsletters
Partner Perspectives
What's This?
In a digital world inundated with advanced security threats, Intel Security seeks to transform how we live and work to keep our information secure. Through hardware and software development, Intel Security delivers robust solutions that integrate security into every layer of every digital device. In combining the security expertise of McAfee with the innovation, performance, and trust of Intel, this vision becomes a reality.

As we rely on technology to enhance our everyday and business life, we must too consider the security of the intellectual property and confidential data that is housed on these devices. As we increase the number of devices we use, we increase the number of gateways and opportunity for security threats. Intel Security takes the “security connected” approach to ensure that every device is secure, and that all security solutions are seamlessly integrated.
Featured Writers
White Papers
Cartoon
Current Issue
Dark Reading's October Tech Digest
Fast data analysis can stymie attacks and strengthen enterprise security. Does your team have the data smarts?
Flash Poll
Video
Slideshows
Twitter Feed
Dark Reading - Bug Report
Bug Report
Enterprise Vulnerabilities
From DHS/US-CERT's National Vulnerability Database
CVE-2014-2021
Published: 2014-10-24
Cross-site scripting (XSS) vulnerability in admincp/apilog.php in vBulletin 4.4.2 and earlier, and 5.0.x through 5.0.5 allows remote authenticated users to inject arbitrary web script or HTML via a crafted XMLRPC API request, as demonstrated using the client name.

CVE-2014-3604
Published: 2014-10-24
Certificates.java in Not Yet Commons SSL before 0.3.15 does not properly verify that the server hostname matches a domain name in the subject's Common Name (CN) field of the X.509 certificate, which allows man-in-the-middle attackers to spoof SSL servers via an arbitrary valid certificate.

CVE-2014-6230
Published: 2014-10-24
WP-Ban plugin before 1.6.4 for WordPress, when running in certain configurations, allows remote attackers to bypass the IP blacklist via a crafted X-Forwarded-For header.

CVE-2014-6251
Published: 2014-10-24
Stack-based buffer overflow in CPUMiner before 2.4.1 allows remote attackers to have an unspecified impact by sending a mining.subscribe response with a large nonce2 length, then triggering the overflow with a mining.notify request.

CVE-2014-7180
Published: 2014-10-24
Electric Cloud ElectricCommander before 4.2.6 and 5.x before 5.0.3 uses world-writable permissions for (1) eccert.pl and (2) ecconfigure.pl, which allows local users to execute arbitrary Perl code by modifying these files.

Best of the Web
Dark Reading Radio
Archived Dark Reading Radio
Follow Dark Reading editors into the field as they talk with noted experts from the security world.