[asterisk-users] Writing CDR's to two database servers

[Daniel Tryba]

On Mon, Jun 19, 2017 at 11:47:04AM -0400, Tech Support wrote:
>     I know that there are probably several solutions to this problem, but
> what I am trying to do is provide some redundancy for my customers CDR data.
> I know that doing simple backups of MySQL is probably the easiest way to go,
> but I'm thinking that there may be some benefit to simultaneously writing
> the CDR data to multiple servers at once. However, I'm drawing a blank on
> this one. Has anyone else done this before? Any insight at all would be
> greatly appreciated.

Beside the already mentioned solutions, you could take a look at a
multi-master setup like a Galera Mysql cluster. Works perfectly for
short queries without locks like CDRs.