PostGres offered as a cloud cluster service

Hosting provider Open Hosting launches a service for running a Postgres cluster in the cloud

Eyeing greater use of the open source Postgres database in the cloud, hosting provider Open Hosting has launched a service that allows users to run an automated cluster of PostGres databases on the company's own servers.

The company has released a package, Cloud Postgres, that streamlines the process of installing, configuring and monitoring a multiple-server Postgres (formally known as PostGreSQL) implementation on Open Hosting's own servers.

The company is pitching the service to support Web applications, such as those that are run on Ruby on Rails, Django, Drupal or Java. Maintaining multiple duplicate databases in a cluster setup improves stability and performance of the application, the company has asserted.

While Postgres has long enjoyed clustering capabilities, either built-in or through add-on software, the Cloud Postgres service promises to simplify the sometimes thorny administrative chores associated with setting up and running a Postgres cluster.

The software package provisions multiple Postgres servers, each on a separate CentOS 6.2 Linux distribution running on a virtual server. It configures the IP addresses, firewalls, and VLANs (Virtual Local Area Networks), as well as tunes and sizes the databases.

Each cluster can retain two full backups of the data, with the ability to store all the incremental changes between the oldest copy of the database and the newest one. Administrators can get automated email alerts when any of the servers stops performing correctly. Customers can opt for either synchronous or asynchronous replication.

Although cloud providers such as Amazon have tended to initially use Postgres' open source counterpart MySQL for their own cloud database offerings, Postgres is starting to get some attention in this arena. Recently, hosting provider Heroku has launched a PostGres service. And enterprise Postgres support vendor EnterpriseDB offers a package for running Postgres on Amazon Web Services (AWS), also in a cluster mode, if desired.

The clustering capability is offered as a beta service, and costs nothing in addition to Open Hosting's usual hosting fees. Each deployment requires four virtual servers, four IP addresses, two firewalls and one VLAN. The service is unmanaged -- the customer gets root access to the CentOS instances.

Joab Jackson covers enterprise software and general technology breaking news for The IDG News Service. Follow Joab on Twitter at @Joab_Jackson. Joab's e-mail address is Joab_Jackson@idg.com

Join the Good Gear Guide newsletter!

Error: Please check your email address.
Rocket to Success - Your 10 Tips for Smarter ERP System Selection

Tags open sourcedatabasesapplicationssoftwareOpen Hostingcloud computinginternetInfrastructure services

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Joab Jackson

IDG News Service
Show Comments

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Matthew Stivala

HP OfficeJet 250 Mobile Printer

The HP OfficeJet 250 Mobile Printer is a great device that fits perfectly into my fast paced and mobile lifestyle. My first impression of the printer itself was how incredibly compact and sleek the device was.

Armand Abogado

HP OfficeJet 250 Mobile Printer

Wireless printing from my iPhone was also a handy feature, the whole experience was quick and seamless with no setup requirements - accessed through the default iOS printing menu options.

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?