Solved: Does both the qpidd send data to Master Postgres - Page 2

asurajpai · 02-16-2016 12:07 AM

Hi,

We have a 13 node installation of Edge.

There are 2 qpidd and 2 postgres (Master - Slave).

The question is does the both the qpidd nodes always send the

1) Queue analytics data to the master only.

Qpidd1 - Master Postgres

Qpidd2 - Master Postgres

Then Master slave replication will bring the both postgres databases in synch.

----OR----------

2) Queue analytics data as follows;.

Qpidd1 - Master Postgres

Qpidd2 - Slave Postgres

Then Master slave replication will bring the both postgres databases in synch.

What happens if one of the Qpidd servers are down. Will all the Queued data sent to the Master or slave?

1) Queue analytics data to the master only.

Qpidd1 - Master Postgres

Qpidd1 - Slave Postgres

Qpidd2___XXX_DOWN - XXXX

Then Master slave replication will bring the both postgres databases in synch.

----OR----------

2) Queue analytics data as follows;.

Qpidd1 - Master Postgres

Qpidd1 - Master Postgres only

Qpidd2___XXX_DOWN - XXX

Then Master slave replication will bring the both postgres databases in synch.

Please help us with the details for the above combination.

Report Inappropriate Content

Hi @asurajpai

The qpids always write to master PG. Slave pgs are readonly and and so cannot be written to. If the master PG is down, the messages remain inside the qpidd.

If qpidd is down, and it contains some messages, the messages are persisted to disk. Once the qpidd is back up, the ingestion from the same qpidd to the master postgres server starts again.

View solution in original post