This isn't a constraint, this is a limit, the goal is to have a
bi-directional replication but I've not found solutions to my problem
using mysql. I've a control access system with 9 minitowers which
controls people access via RFID, each minitower is provided with linux
and mysql synchronized with a main server, each machine is identical to
others and can alive without connecting to main server if any problem
hardware or software close the connection with the rest of the network
and align again datas if connection go up, something like a survivor
system. So now you can understand that with this scenario mysql actual
replication MASTER/SLAVE isn't a solution. (Perhaps I'll think to modify
sources :)) )
> The only constraint you'll have here is that there can only be one MASTER
> that has to accept all the INSERT/UPDATE/DELETE (or anything that will
> make the data change). All other nodes would be considered SLAVEs and
> be READ-ONLY.
>
> Hope this helps.
>
> a
>
>
