Multimaster configuration doc?

[gonzalo...@iquall.net]

Hello,

I am currently testing citus-community edition with cstore. But as far as I know, the documentation only configures one master node. 

I read some posts that said to synchronize master metadata, but doesn't explain the steps nor the tools to make it.

Is there any documentation for launching, at least, two master nodes? or is citus-enterprise only?

I have suscesfull launched two workers and two master nodes, but the second master nodes cannot query the data insterted in first because desynchronized metadata.

Kind regards

[Sai Srirampur]

Hi Ferrero,

Thanks for contacting us. Could you elaborate more on why you are looking to setup a multi master cluster ?

Are you looking at scaling the reads? Are you looking to scale writes? or is it just keeping a backup of master ?

If you are looking at multi master for backup purposes you  could use PostgreSQL’s streaming replication feature to create a hot standby of the master. Then, if the primary master node fails, the standby can be promoted to the primary automatically to serve queries to your cluster. You could also refer the following section on our docs.

Sai

--
You received this message because you are subscribed to the Google Groups "citus-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to citus-users...@googlegroups.com.
To post to this group, send email to citus...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/citus-users/1026bdd0-5285-4ac5-80dc-ead753f57241%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Gonzalo Ferrero]

Hello Sai

Thanks for the fast response!

I am currently trying to set up a second master to guarantee high availavility if one master goes down. The writes and reads are not a problem, just looking backup.

I have an append distribution for cstore tables.

Before getting started with citus workers, I have tried setting up a simple Master-Slave with cstore, but the problem is that cstore tables don't write to WAL, so the data wasn't replicated. I thought the metadata tables are also cstore-related tables, so I did not check it with the masters.

I will try the solution you posted.

Thank you very much!

Regards

Gonzalo Ferrero

gonzalo...@iquall.net / SKYPE gonzalo...@iquall.net

CEL +54.9.11.2178.4322 / TEL +54.11.4855.6041

Av. Honorio Pueyrredón 1475 C.A.B.A. República Argentina