No doubt there will be a need for you to split off your analytical queries from the main database for performance reasons.
If you have been following me in the past with Azure SQL DB you would use failover group read endpoints. With MySQL we would need to build a replica (read only) to another server. This uses MySQL’s native feature binlog replication which is great to hear. This form is asynchronous.
Read on to see how.