Hi team, we are looking to have a HA setup for Fleet's MySQL DB. Is there a replication type (async / semi-sync / group) that is suggested for use with Fleet? We are considering async replication because of its simplicity, but in such a model, there can be occasional data loss during failover in the form of missing rows and transactions. Could I please get your thoughts on the consistency guarantees expected by Fleet and what issues could be expected in such scenarios?

Hello @Supreeth Kurpad! Great question. We've got a doc that should give you a good starting point. This article also links to some examples in our reference architecture that might be helpful as well. Reference configuration strategies

Got it, thank you Matt! I will go through the doc.

No problem, Supreeth! Hope everything goes well, but feel free to let us know if something doesn't go totally to plan!

got it, thank you!