Sun Microsystems is crowing over a customer that moved to PostgreSQL on Solaris, after a Linux-based Oracle test project failed.
A document on Sun's Web site outlines how Maryland-based open source consultancy OmniTI moved a customer from Oracle to PostgreSQL, the open source database that Sun began supporting on Solaris 10 in late 2005. The customer, "a large database marketing firm", moved from Oracle when its growing database requirements that were "threatening to send software costs skyrocketing" says the paper.
The company's existing half-terabyte OLTP was peaking at 10,000 transactions per second and its data warehouse was consuming 1.2 terabytes of data.
"Scaling the proprietary database application for the OLTP and data warehouse operations would be extremely expensive in light of the application's per-processor licensing requirements," according to Sun. "The open source PostgreSQL database application, on the other hand, had no licensing costs."
Due to the amount of engineering effort required to migrate both database systems, OmniTI decided to only migrate the Oracle-Perl data warehouse to PostgreSQL and keep the OLTP system running Oracle 8i.
"Because Oracle licensing would no longer be needed for the data warehouse, OmniTI moved those Oracle 8i licences to the OLTP, mitigating the costs of scaling the Oracle installation for the OLTP," according to the report.
Sun also took the opportunity to berate Linux - reporting that OmniTI initially ran the new PostgreSQL application on 64-bit Linux, but the customer suffered "unacceptable downtime and eventually catastrophic data losses in that environment".
"OmniTI attributes these outages to a number of specific issues associated with the Linux operating system, such as frequent kernel-panic errors, file systems remounting as read-only, and the lack of reliable support for file system snapshots," according to Sun. "After suffering 20 outages in four months on Linux, OmniTI switched to Solaris 10. Since then, the operating environment has been significantly more reliable and stable."
This was confirmed by OmniTI principal and CTO Theo Schlossnagle on his personal blog.
Schlossnagle said during testing the large PostgreSQL data mount point suddenly went read-only on CentOS 4 (a Red Hat derivative) with the ext3 file system.
"So, naturally, I tried to fix the problem by unmounting and mounting again, all to no avail," he said. "It turns out that a reboot was required to rectify the issue. While this was disturbing, we rebooted and continued on with life. The more annoying issue was the subsequent 18 times this occurred. The show stopper was the 20th time it failed; upon reboot I found catastrophic data loss."
That said, Schlossnagle also runs a lot of Linux and BSD, and believes there isn't a perfect operating system - but Solaris, with its ZFS file system, does "really mesh well with core database needs".
Vendor and operating system politics aside, the real winner appears to be the "large database marketing firm" which experienced a $400,000 one-time saving and $100,000 in annual savings on software licensing as a result of the migration, according to Sun.
So far, Schlossnagle is very happy with the new system, which also combines MySQL for data imports and exports, and praised Sun's focus on testing and stability.