Data not replicating over nodea

anmol_koul

So i have a very unreasonable question. I loaded the VMart database on a three node cluster. Its working fine and i can see the database and hosts in MC. Now, when i insert a data row in the employee dimension table on node B, it does not get replicated on nodes A and C. Also if i just exit the vsql client on node B and then again query for that specific data row, i can not find it. Why is this happening?

Shobhit_Garg

Hi Anmol,

Just want to ask a simple question, did you perform commit after insert?
Because if COMMIT is not done then the data will be lost once you log out that session.

anmol_koul

Hi Shobhit,

Unfortunately i did not. Now that i have done it, i can see the data replicated across nodes.
Thank you very much