Citus Con: An Event for Postgres is a wrap! 💥 Thanks to all who joined. If you missed the event, you can still find and watch all 38 recorded talks 🖥 online.
With Private access, you can allow hosts on a virtual network (VNet) to securely access a Hyperscale (Citus) server group over a private endpoint.
Postgres 14!
Postgres 11, 12, and 13 database versions are all supported. Postgres major version upgrades now available with minimal downtime. And as of Oct 2021, Postgres 14 is supported in many Hyperscale (Citus) regions too.
Basic tier (single node)
With Basic tier, you can be “scale-out-ready” by sharding Postgres on a single Hyperscale (Citus) node and using a distributed data model from the start—so you can easily add nodes later. Or use Basic tier as a handy way to try out Citus.
Columnar compression
With the new columnar storage feature in Hyperscale (Citus), you can compress regular Postgres tables and/or distributed tables to reduce disk footprint, reduce I/O bandwidth needs, and speed up queries.
Citus 10
In addition to features like columnar compression and basic tier, the latest release of Citus 10 is now available in many Hyperscale (Citus) regions and will roll out to remaining regions in the coming months.
Easy to Scale
Basic tier
Be “scale-out-ready” by sharding Postgres on a single Hyperscale (Citus) node and using a distributed data model from the start—so you can easily add nodes later. Or use Basic tier as a handy way to try out Citus.
Sharding Postgres
Transparently shard Postgres tables across multiple nodes to give your application more memory, compute, and disk. Which gives you parallelism, high performance, and a way to scale. And with Basic tier, you can also shard Postgres on a single Hyperscale (Citus) node.
Easy to scale up nodes
Easy to increase compute/memory and storage on your Hyperscale (Citus) coordinator & worker nodes.
Easy to add nodes
It’s as simple as moving a slider to add nodes to your Hyperscale (Citus) cluster, whether starting with Basic tier or Standard tier in the Azure Database for PostgreSQL managed service.
Online Shard Rebalancer
When adding nodes to a Hyperscale (Citus) server group, the shard rebalancer enables you to redistribute shards across nodes to better balance the data distribution and the performance of your Citus database. Online, with zero downtime.
Read replicas
Analysts & developers alike sometimes need to run complex queries without impacting the production database. Read-only replicas of a Hyperscale (Citus) server group are available in the same region. Forks/PITR also available.
Managed PgBouncer
Outsource PgBouncer administration to Azure. Allow many clients to connect, while limiting the number of active connections and keeping the coordinator node running smoothly.
Managed Database Service
High Availability option
High availability (HA) avoids database downtime by maintaining standby replicas for all nodes in a Hyperscale (Citus) cluster, with streaming replication & automated failover.
Automated backup & restore
Automated backups are stored in multiple Azure availability zones. Point-in-time restore is available for any point in time in the last 35 days. Learn more about backup and restore in the Azure docs.
Automated monitoring & alerts
Automated monitoring, configurable metrics dashboard—plus alert setup through Azure Monitor just like with other Azure services.
Scheduled maintenance
Periodic maintenance is included in the service to keep your managed database secure, stable, and up-to-date. You can select your scheduled maintenance windows or let the system pick a day and time window for you automatically.
Security controls
Security features in Hyperscale (Citus) include: Encryption at rest & in flight, firewall rules, and 2FA. For networking, you can use public access with public IPs, private access with private endpoints—or enable both together.
Watch a short demo on how to shard Postgres on a single node, so you can start small and seamlessly add nodes to your Hyperscale (Citus) cluster in the future. Umur also demos the new Citus 10 columnar feature, showing >5X compression.
Azure Database for PostgreSQL is a database as a service that you can use to run, manage, and scale PostgreSQL on Azure. This Quickstart will show you how to create a Hyperscale (Citus) server group (aka cluster) in Azure Database for PostgreSQL, using the Azure portal. Along the way, you will get to shard tables across nodes, ingest sample data, and run queries that execute on multiple nodes in a Hyperscale (Citus) server group.
After you’ve checked out the docs, the best next step is to provision a Hyperscale (Citus) server group. Then you get to figure out your distribution key, run the create_distributed_table command, ingest your data, and start assessing how Hyperscale (Citus) performs for your workload.
Citus was a game changer for us. After migrating to Citus, we can onboard Vonto customers 20X faster, in 2 minutes vs. the 40+ minutes it used to take. And with the launch of Hyperscale (Citus) on Azure Database for PostgreSQL, we are excited to see what we can build next on Azure.
Head of Integration of Business Ventures at ASB Bank & Chief Product Officer at Vonto
Are You Ready to Scale Out Postgres with Hyperscale (Citus) on Azure?
