P
P
PSSemyon2018-10-24 20:40:23
PostgreSQL
PSSemyon, 2018-10-24 20:40:23

Postgres-XL - how to add a new node?

I'm familiar with Postgres-XL. Set up the following scheme:
1 - server: GTM
2 - server: Gtm-Proxy, Coordinator, Datanode
3 - server: Gtm-Proxy, Coordinator, Datanode
Created two tables "by replication" and "by modulo(column_name)".
Everything works as it is said in books, documentation and on various forums.
I added a new node similar to 2 and 3 servers, but I just can't figure out how to synchronize the database structure on the new server. I can't find any information in books or forums.
If anyone has come across this issue, I would appreciate any help.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Y
Yuri Yarosh, 2018-10-25
@voidnugget

There are problems...
You need crutches like Slony or Stolon
What would the migration "spread" on the cluster somehow.
For migrations, you can liquibase with local formatted SQL.
You can roll with anything.
In principle, Postgres-XL has already lost its relevance. PG11 + stolon / pg_pathman is more than enough, you can still use Citus, but IMHO it is too thick. If it is necessary map/reduce'it - it is better to write the plan manually.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question