baMulti-Master cluster brings us better write performance — Another interview process

The Interview story

Last week. senior backend position.

“Here you mentioned that lead and scaled database from a single node to cluster, archived better performance, could you please elaborate more?” I asked.

“Sure. I was the lead of this project. We migrated our single node database to the master-master setup database. so we archived scalability and better performance”. the candidate answered.

“Are you sure master-master setup brings you better performance? read or write, how many nodes and which database? and how much faster?” I asked many questions in one go because I was very interested to know.

“We migrated Mariadb to 3 node Galera cluster. Our system has a large number of write requests so the write performance improved”. he said.

“Well that sounds interesting AFAIK, Galera is not built to boost up the system throughput, but focuses more on data consistency. but anyway I will find out thanks for the answer” I said.

“Have you faced any issues when using master-master setup?” I asked

“Yes, sometimes network slowness happens and the poor network connection between nodes causes issues,” he said.

“What kind of issues?” I asked.

“Well, sometimes the node is out of sync. and after some time the node comes back automatically” he…