CloudFlare Leverages Citus Data's PostgreSQL Database to Boost Real-time Customer Analytics and Business Intelligence

By CIOReview | Friday, November 13, 2015
850
1287
280

FREMONT, CA: To provide website owners with information on millions of site visits and potential threats through aggregation of non-user identifying data from millions of customers and performing complex queries with less response time, CloudFlare uses Citus Data’s horizontally scalable operational and analytics database for Big Data. Built on PostgreSQL 9.4, CitusDB provides real-time customer analytics and business intelligence on activity data from more than 4 million websites.

By replicating shards of operational database across a scalable cluster of commodity servers, the CitusDB platform handles Big Data as large as hundreds of billions of events or hundreds of terabytes. CitusDB enables CloudFlare to replicate multiple logical shards to independent machines in the cluster and automatically fail over between replicas even during queries. In the event of a hardware failure, CloudFlare can use the CitusDB rebalance function to re-replicate shards in the cluster. Being an extension of the latest version of PostgreSQL, CitusDB enables CloudFlare to work with its existing Postgres extensions without any changes or modifications. The ability to distribute queries across commodity servers without sacrificing performance provides CloudFlare with very cost-effective long-term scalability.

 Use of CitusDB for business intelligence is helping CloudFlare to grow its business. The ease of running distributed queries on the data allows CloudFlare’s product, operations and sales teams to improve performance, enhance the customer experience and increase sales. The ability to distribute queries across commodity servers without sacrificing performance provides CloudFlare with very cost-effective long-term scalability. Use of a single SQL query for instant cross-customer visibility eliminates the need for sales team to spend hours going through granular data for extracting the information they need.

"CitusDB is both an operational and analytics database that enables companies like CloudFlare to shard their Postgres database across a cluster of commodity servers and leverage massive parallel processing to distribute queries across the cluster for real-time analytics. As a result, these companies are able to grow their business infrastructures cost effectively and reliably while achieving the performance they need to meet the data analytics requirements of their customers. They also benefit from the large and growing pool of Postgres talent and expertise," says Umur Cubukcu, CEO and Co-founder, Citus Data.