How to make Asterisk work with MySQL replication?

Question

MySQL

Given:
Asterisk telephony server.
MS replication configured under it on Mysql.
Several third-party applications (monitoring, web face for Asterisk).
Task:
Configure Asterisk and applications so that reading is done only from the slave, and writing is done to the master (for load balancing).
Questions:
Is it true that Aster does not allow you to specify in the settings a separate server for reading, separately for writing? There is no information about this in the documentation. How is mysql replication supported then?
If you need to connect an application that does not allow you to specify separate servers for writing and reading, how to take advantage of replication? Is it necessary to configure the layer in the form of haproxy or mysql proxy?

Answer 1

CDR and CEL only write to the database without reading anything.
func_odbc specifies a specific dsn for each function.
Dynamic configuration, AFAIK, only reads from the database and does not write anything.