I plan to use postgres for freeradius authentication and accounting.
Two Radius servers (radius1 and radius2)
Two Postgres servers (db1 and db2)
For radius1, db1 is the primary and db2 is the secondary
For radius2, db2 is the primary and db1 is the secondary
And then need to configure the posgresql replication.
As per plan, I am thinking to use master-master replication but when we use "Synchronous Multimaster Replication" there will be performance impact if there is heavy write.
I believe there will be heavy write in accounting table. So, in this situation.
Which replication method is more suitable for master-master setup?