Lucas Borges Fernandes

Lucas Borges Fernandes


Software engineer on the Postgres team at Microsoft. MsC in Distributed Systems from the Federal University of Uberlandia. Speaker at Citus Con: An Event for Postgres 2023. Loves to play electric guitar. Brazilian.


Lucas Borges Fernandes

Auto scaling Azure Cosmos DB for PostgreSQL with Citus, Grafana, & Azure Functions

Written by By Lucas Borges Fernandes | May 19, 2023 May 19, 2023

One of the top Citus features is the ability to run PostgreSQL at any scale, on a single node as well as a distributed database cluster.

As your application needs to scale, you can add more nodes to the Citus cluster, rebalance existing data to the new Postgres nodes, and seamlessly scale out. However, these operations require manual intervention: a) first you must create alerts on metrics, b) then, based on those alerts, you need to add more nodes, c) then you must kick off and monitor the shard rebalancer. Automating these steps will give you a complete auto scale experience—and make your life so much easier.

In this blog post, you will learn how to build a full-fledged auto scaling setup for the Citus database extension running as a managed service on Azure—called Azure Cosmos DB for PostgreSQL. You’ll also learn how you can easily add nodes to the Azure Cosmos DB for PostgreSQL cluster and use any metrics available to trigger actions in your cluster! Let’s dive into the following chapters:

Keep reading

Page 1 of 1