Feeds

HP shares database smarts with EnterpriseDB

Postgres Plus goes cloudy

3 Big data security analytics techniques

EnterpriseDB is trying to pump up the PostgreSQL database to do battle with Oracle 11g and, to a lesser extent, IBM's DB2 and Microsoft's SQL. So the database upstart is upgrading its Postgres Plus Advanced Server 9.1 - and kicking it onto Amazon's EC2 compute cloud to peddle it alongside Amazon's own Relational Database Service.

As El Reg previously reported, the open source PostgreSQL relational database was updated to the 9.1 release level last September, with a lot of the work being done by a team at EnterpriseDB, which has become the "Red Hat for PostgreSQL," led by Robert Haas, the senior architect at the company.

With the open source PostgreSQL 9.1 that debuted in September, synchronous replication between clustered databases – available on a per-transaction, per-user, or per-connection basis, not across the entire system – was the big feature. So was unlogged tables, a feature that allows intermediate tables (such as end user session tables) to be omitted from asynchronous or synchronous replication to boost the performance of the overall database when it is clustered.

These and other PostgreSQL 9.1 features have now been rolled up into the commercial-grade Postgres Plus Advanced Server 9.1 from EnterpriseDB. Sean Doherty, vice president of business development at the company, tells El Reg that a number of new features, which the EntepriseDB team did in conjunction with database experts at HP, are being rolled up in Advanced Server 9.1. HP and EnterpriseDB have worked deep down in the guts of the database engine to improve the read and write performance of the database and help PostgreSQL scale across more processor cores.

"Customers are looking for something secondary, and MySQL is not the answer because that is Oracle's, too," says Doherty.

Given all of its woes with Oracle over the HP-UX/Itanium platform, HP is keen on peddling PostgreSQL on its high-end Xeon-based ProLiant DL980 eight-socket servers as well as on the Itanium-based Integrity blades and Superdome 2 servers. Postgres Plus Advanced Server 9.0, which debuted last July, was the first release to support HP-UX – the HP-UX 11i v3 release, to be precise. You could roll your own PostgreSQL database from the source for HP-UX 10.X and 11.X versions for many years, for PA-RISC or Itanium processors.

With Advanced Server 9.1, the read and write functions of the database can now scale efficiently across 32 cores, up from 24 cores with the 9.0 release. Doherty says its labs can push it to 64 cores and there's no reason that it can't be pushed up further.

It will need to be if Postgres Plus Advanced Server is to be a true alternative to Oracle 11g among HP shops. That eight-socket DL980 can support 80 cores today, and a Superdome 2 tops out at 32 sockets and 128 cores, with the count doubling sometime this year with Intel's "Poulson" Itanium processors.

EnterpriseDB has a slew of features that lets the PostgreSQL database be "skinned" so it looks like an Oracle database. IBM has a stake in EnterpriseDB and licenses this skinning technology to make use of it in its own DB2 database for Windows, Linux, and Unix, although it doesn't make a lot of noise about this.

Oracle compatibility is a big deal, and with PostgreSQL Plus Advanced Server 9.1, the commercial-grade database from EnterpriseDB is getting what is called a virtual private database in the Oracle world. Virtual private databases provide locking at the row and column level so users can be kept from seeing subsets of the information in a database.

The read and write performance improvements being added to Postgres Plus Advanced Server 9.1 will be turned back over to the PostgreSQL community and are expected to be further tuned and put into the future PostgreSQL 9.2 release, according to Doherty.

Postgres Plus Advanced Server 9.1 is supported on Linux, Windows, Solaris, HP-UX, Mac OS X, and FreeBSD platforms. It costs $4,395 per socket for an annual support subscription for standard 9x5 business hours and $4,945 per socket for 24x7 premium support.

Taking on Amazon and MySQL, too

On the cloud front, EnterpriseDB has begun shipping its Postgres Plus Cloud Database service, which was in beta testing last September when the open source PostgreSQL 9.1 database came out. The cloudy database service is meant to be an alternative to Amazon's MySQL-derived Relational Data Service and just like RDS, it runs on Amazon's EC2 compute cloud and makes use of the storage clouds to store data.

The service includes autoscaling, snapshots, cloning, and automated database administration functions, and Doherty says the pricing is very simple: EnterpriseDB is charging exactly the same price for its database service as Amazon charges for RDS.

The EnterpriseDB cloud service is comprised of a management console for running the clusters of database images, and you can plug in the freebie PostgreSQL or the supported Postgres Plus Advanced Server on the EC2 cloud. If you want to manage the databases yourself, have at it with the console. Or, if you have some extra dough and you are feeling lazy, you can pay EnterpriseDB an additional support contract to manage keeping the databases up and running smoothly.

Doherty says that HP is very interested in putting this cloud-enabled version of PostgreSQL onto its OpenStack-based Cloud Compute infrastructure cloud service. CloudBees and Engine Yard are supporting it on their clouds as well. ®

SANS - Survey on application security programs

More from The Register

next story
Android engineer: We DIDN'T copy Apple OR follow Samsung's orders
Veep testifies for Samsung during Apple patent trial
This time it's 'Personal': new Office 365 sub covers just two devices
Redmond also brings Office into Google's back yard
Batten down the hatches, Ubuntu 14.04 LTS due in TWO DAYS
Admins dab straining server brows in advance of Trusty Tahr's long-term support landing
Microsoft lobs pre-release Windows Phone 8.1 at devs who dare
App makers can load it before anyone else, but if they do they're stuck with it
Half of Twitter's 'active users' are SILENT STALKERS
Nearly 50% have NEVER tweeted a word
Internet-of-stuff startup dumps NoSQL for ... SQL?
NoSQL taste great at first but lacks proper nutrients, says startup cloud whiz
Windows 8.1, which you probably haven't upgraded to yet, ALREADY OBSOLETE
Pre-Update versions of new Windows version will no longer support patches
Microsoft TIER SMEAR changes app prices whether devs ask or not
Some go up, some go down, Redmond goes silent
Red Hat to ship RHEL 7 release candidate with a taste of container tech
Grab 'near-final' version of next Enterprise Linux next week
Ditch the sync, paddle in the Streem: Upstart offers syncless sharing
Upload, delete and carry on sharing afterwards?
prev story

Whitepapers

Designing a defence for mobile apps
In this whitepaper learn the various considerations for defending mobile applications; from the mobile application architecture itself to the myriad testing technologies needed to properly assess mobile applications risk.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Securing web applications made simple and scalable
In this whitepaper learn how automated security testing can provide a simple and scalable way to protect your web applications.