Hello All, We had two system where we were doing Master Slave Replication, we used to do delta-import every 24 hours since we did not want the near real-time data. Now since our data is increasing we thought of adding one more machine to the master slave replication.
I thought of creating a Sharding between two systems and make it Master-Master (indexing every 4 hours between those two) and the other systems is for searching which gets it data from both the masters. Please let me know if this approach is a good approach or do we need to rethink about the strategy. What do you think is the best among. Thanks, Gopesh Sharma