We're excited to announce general availability of CitusDB 4.0, which is based on the new PostgreSQL 9.4 release. CitusDB is our full featured, turnkey database solution for fully scalable, highly-available PostgreSQL. A licensed solution, CitusDB allows you to scale out PostgreSQL across commodity servers and also parallel process queries across the cluster for real-time analytics on big data.
This release brings exciting new functionality and performance improvements, including:
CitusDB 4.0 is based on PostgreSQL 9.4.0, and is binary incompatible with CitusDB 3.0. As a result, the install path for the new version has changed from /opt/citusdb/3.0 to /opt/citusdb/4.0 in order to allow for multiple versions of Citus DB to be installed in parallel.
If you are running CitusDB 3.0 and want to upgrade to v4.0, you will need to run pg_upgrade on your all nodes, and manually reload your distributed metadata. For specifics, please get in touch with us so we can assist with the upgrade process. If you are downloading and using CitusDB for the first time, please follow the installation instructions found in the CitusDB documentation page.
Download it now at citusdata.com/downloads.
Last month we went to PGConf.Russia and gave a talk on pg_shard which is available for download on GitHub. pg_shard is an open source PostgreSQL extension which allows users to scale out their database by creating a cluster of commodity servers. pg_shard shards the database and replicates the shards across the cluster, allowing users to both easily scale out as well as create a high availability cluster. The video from my talk is now available for all to see:
We got some very interesting questions during the talk that we wanted to highlight and clarify.
We would like to thank the organizers for a great conference and providing the recording of the talk! If you would like more information on pg_shard or on common use cases for scaling out PostgreSQL, please visit the Citus Data website.