TimescaleDB分布式集群搭建

pigcoffee

于 2023-12-30 22:21:06 发布

阅读量1.4k

点赞数 18

CC 4.0 BY-SA版权

文章标签：分布式 postgresql

本文链接：https://blog.youkuaiyun.com/hqwang4/article/details/135310550

本文介绍了如何搭建TimescaleDB的分布式集群，包括添加数据节点和创建分布式表。TimescaleDB利用多节点将多个PostgreSQL实例组合成逻辑分布式数据库，通过访问节点协调数据节点上的数据分布和访问。推荐为访问节点和数据节点分别配置不同的服务器，以避免复杂性。文中展示了添加数据节点的SQL命令以及创建分布式表的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Multi-node TimescaleDB allows you to tie several databases together into a logical distributed database to combine the processing power of many physical PostgreSQL instances.

One of the databases exists on an access node and stores metadata about the other databases. The other databases are located on data nodes and hold the actual data. In theory, a PostgreSQL instance can serve as both an access node and a data node at the same time in different databases. However, it is recommended not to have mixed setups, because it can be complicated, and server instances are often provisioned differently depending on the role they serve.

For self-hosted installations, create a server that can act as an access node, then use that access node to create data nodes on other servers.

When you have configured multi-node TimescaleDB, the access node coordinates the placement and access of data chunks on the data nodes. In most cases, it is recommend that you use multidimensio