Redundancy recommendation.

[Pizu]

Hi,

I have 2 FreeRadius + MySQL servers in 2 different locations and everything
is working with no issues, now I'd like to add redundancy for MySQL.

Options:
1) MySQL MASTER/MASTER Replication
2) MySQL Master/Slave
3) FreeRadius SQL redundancy
4) any other idea?

I have already tested the option 1 but am not happy with it as am have some
errors with the accounting id in the db as am having duplicate entries. For
option 3 when the local mariadb is stopped the server doesn't start, is it
normal?

Regards,

Pizu