Options

Data not replicating over nodea

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?

Comments

  • Options
    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.
  • Options
    Hi Shobhit,

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file