Getting Started

Citus Cloud is a fully managed hosted version of Citus Enterprise edition on top of AWS. Citus Cloud comes with the benefit of Citus allowing you to easily scale out your memory and processing power, without having to worry about keeping it up and running.

Provisioning

Once you’ve created your account at https://console.citusdata.com you can provision your Citus cluster. When you login you’ll be at the home of the dashboard, and from here you can click New Formation to begin your formation creation.

../_images/cloud_provisioning.png

Configuring Your Plan

Citus Cloud plans vary based on the size of your primary node, size of your distributed nodes, number of distributed nodes and whether you have high availability or not. From within the Citus console you can configure your plan or you can preview what it might look like within the pricing calculator.

The key items you’ll care about for each node:

  • Storage - All nodes come with 1 TB of storage
  • Memory - The memory on each node varies based on the size of node you select
  • Cores - The cores on each node varies based on the size of node you select

Supported Regions

Citus Cloud runs on top of Amazon Web Services. During provisioning you’re able to select your database region. We currently support:

  • US East (N. Virginia) [us-east-1]
  • US East (Ohio) [us-east-2]
  • Asia Pacific (Tokyo) [ap-northeast-1]
  • Asia Pacific (Seoul) [ap-northeast-2]
  • Asia Pacific (Singapore) [ap-southeast-1]
  • Asia Pacific (Sydney) [ap-southeast-2]
  • Asia Pacific (Mumbai) [ap-south-1]
  • EU (Frankfurt) [us-central-1]
  • EU (Ireland) [us-west-1]
  • South America (São Paulo) [sa-east-1]
  • US West (N. California) [us-west-1]
  • US West (Oregon) [us-west-2]

If there is an AWS region you do not see listed but would like for us to add support for please contact us and we’d be happy to look into it.

Other infrastructure providers

At this time we only support Citus Cloud on top of Amazon Web Services. We are continually exploring other infrastructure providers to make Citus Cloud available on. If you have immediate needs you could consider running Citus Community Edition or Citus Enterprise Edition. Or if you have questions about our timeline for other infrastructure providers please feel free to reach out.

Connecting

Applications connect to Citus the same way they would PostgreSQL, using a connection URI. This is a string which includes network and authentication information, and has the form:

postgresql://[user[:password]@][host][:port][/dbname][?param1=value1&...]

The connection string for each Cloud Formation is provided on the Overview tab in Citus Console.

../_images/cloud-overview-1.png

By default the URL displays only the hostname of the connection, but the full URL is available by clicking the “Show Full URL” link.

../_images/cloud-overview-2.png

Support and Billing

All Citus Cloud plans come with support included. Premium support including SLA around response time and phone escalation is available on a contract basis for customers that may need a more premium level of support.

Support

Web based support is available on all Citus Cloud plans. You can open a support inquiry within the Citus Cloud console. Support response times for ticket classification of Citus Cloud are:

  • Urgent (production database offline) - 1 hour response time
  • High (production database impacted) - 4 hour response time
  • Normal (general support) - 1 business day response time
  • Low (general question) - 3 business days response time

Billing and pricing

Citus Cloud bills on a per minute basis. We bill for a minimum of one hour of usage across all plans. Pricing varies based on the size and configuration of the cluster. A few factors that determine your price are:

  • Size of your distributed nodes
  • Number of distributed nodes
  • Whether you have high availability enabled, both on the primary node and on distributed nodes
  • Size of your primary node

You can see pricing of various configurations directly within our pricing calculator.

Extensions

To keep a standard Cloud installation for all customers and improve our ability to troubleshoot and provide support, we do not provide superuser access to Cloud clusters. Thus customers are not able to install PostgreSQL extensions themselves.

Generally there is no need to install extensions, however, because every Cloud cluster comes pre-loaded with many useful ones:

Name Version Schema Description
btree_gin 1.0 public support for indexing common datatypes in GIN
btree_gist 1.2 public support for indexing common datatypes in GiST
citext 1.3 public data type for case-insensitive character strings
citus 7.0-15 pg_catalog Citus distributed database
cube 1.2 public data type for multidimensional cubes
dblink 1.2 public connect to other PostgreSQL databases from within a database
earthdistance 1.1 public calculate great-circle distances on the surface of the Earth
fuzzystrmatch 1.1 public determine similarities and distance between strings
hll 1.0 public type for storing hyperloglog data
hstore 1.4 public data type for storing sets of (key, value) pairs
intarray 1.2 public functions, operators, and index support for 1-D arrays of integers
ltree 1.1 public data type for hierarchical tree-like structures
pg_buffercache 1.2 public examine the shared buffer cache
pg_freespacemap 1.1 public examine the free space map (FSM)
pg_prewarm 1.1 public prewarm relation data
pg_stat_statements 1.4 public track execution statistics of all SQL statements executed
pg_trgm 1.3 public text similarity measurement and index searching based on trigrams
pgcrypto 1.3 public cryptographic functions
pgrowlocks 1.2 public show row-level locking information
pgstattuple 1.4 public show tuple-level statistics
plpgsql 1.0 pg_catalog PL/pgSQL procedural language
session_analytics 1.0 public  
shard_rebalancer 7.0 public  
sslinfo 1.2 public information about SSL certificates
tablefunc 1.0 public functions that manipulate whole tables, including crosstab
unaccent 1.1 public text search dictionary that removes accents
uuid-ossp 1.1 public generate universally unique identifiers (UUIDs)
xml2 1.1 public XPath querying and XSLT