I was comparing the MemSQL versions 7.0.15 and 6.8.3 and I found that reference data is getting asynchronously replicated to all leaves and child aggregators in version 7.0.15. However, on version 6.8.3, it is getting synchronously replicated.
In the screenshot, I ran show databases extended on a leaf and it says async slave. On version 6.8.3, it says sync slave.
I am not sure about the change in default behavior as in case their is latency during asynchronous replication of reference data and leaves have to perform join operation to local copy of reference data then leaves will not be seeing up to date copy of data which will result in incorrect data display.
Does anyone have an idea about the reason of this change? Also, How do we change it back to synchronous in version 7.0.15?