The Ultimate Guide to High Availability with MariaDB

Data loss during the time when one node reboots

HI there,

I have three mariadb columnstore nodes - node1, node2 and node3; and a maxscale mxs1. When a replica node ( say node3 ) is rebooted, I lose data that is inserted/updated by my application during that time it was offline. I thought as node1 and node2 are up, the data will still be inserted/updated into node1 and node2. Later when node3 comes up, it will get synced to node3 as well. But that is not the case. Is it usual? or am I missing something.

Please help.

Answer Answered by Daniel Black in this comment.

What used to happen in that scenario is the system should write-lock and inserts error. As it doesn't any more, create a bug report in the MCOL project.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.