Juha Heinanen writes:
Our solution was to switch to the mysql driver in kamailio and use the galera loadbalancer (http://galeracluster.com/documentation-webpages/glb.html) to implement loadbalancing/failover to our mariadb galera master/master cluster.
In this solution, also loadbalancer must be made highly available, using, for example, corosync/pacemaker.
Or run loadbalancer on each SIP proxy host.
-- Juha