I’m planning a replacement of a legacy SIP soft-switch and part of my design will include two replicated database servers to handle failover. According to the 4th edition of Asterisk: The Definitive Guide, Asterisk 11 did not include failover support for cdr_odbc. Has this since changed as of Asterisk 13? Reading through the Asterisk 13 changes in the project wiki, it does not appear to have changed.
As far as I know, asterisk, by itself, does not handle the failover. You’ll need to set up the master-master replication on the database or use DRBD, then handle the failover through corosync/pacemaker/heartbeat or keepalived. There are also commercial packages that “do it all”.