Scaling MySQL for Analytics: A No-Nonsense Guide to GTID Replication
Hey Maman, since you work in a production environment, you need this to be straightforward. Separating your transactional database (client-facing) from your analytical database (reporting) is the textbook way to prevent heavy data-crunching queries from causing user-facing lag. Here is how you set up a robust Primary-