Hi5 is one of the world's largest social networks, with over 56 million monthly visitors. It's a company that demands maximum scale and performance from its infrastructure.
As such, it's no surprise that Hi5 recently opted to go with PostgreSQL as supported by EnterpriseDB.
PostgreSQL? Isn't that an open-source database? It can handle that load?
Indeed.
Hi5 runs hundreds of PostgreSQL servers in one of the world's largest commercial OLTP PostgreSQL installations. All Hi5 subscriber data, including user profiles, metadata associated with user photos, and comments, is stored on the company's PostgreSQL databases...In June 2008, the PostgreSQL-based system delivered more than 18.5 billion page views, serving nearly 11 million visitors to the site every day.
A key challenge and requirement for Hi5 is that the social-networking site cannot be taken offline for maintenance. The company's PostgreSQL databases must deliver exceptional stability and performance 24 hours per day, seven days per week, 365 days per year to serve users around the globe. Any issues must be resolved in real time, with the system still running.
That's extreme performance, and stands as a continued testament to open source and its increasingly routine ability to deliver significant performance at a lower cost, just as Red Hat announced earlier today in its Linux benchmarks.
However, the real story in Hi5's decision is its work with EnterpriseDB. The Web 2.0 world has traditionally adopted open source heavily...and paid little to nothing for it. Hence, the real news here is one Web 2.0 company's realization that buying support for open-source software makes a lot of sense/cents.… Read more