[drewpc]

The documentation that Microsoft puts out regarding its "multi-master" features basically advises against using "multi-master" mode and leveraging the Flexible Single Master Operation (FSMO) Roles to ensure consistency across the domain and forest because its conflict resolution is not comprehensive [1]. FSMO roles were created decades ago as a transition from Windows NT's Primary Domain Controller (PDC) model to avoid some of these complexities around changes in a large distributed system. Its a decent solution that has its own pros/cons, but AD is not something I would use as a good example of a multi-master distributed database.

1. https://learn.microsoft.com/en-us/troubleshoot/windows-serve...

[HyperSane]

FSMO roles are only used for the tasks which are not suited to multi-master replication. The vast majority of data can be mutated on any domain controller.

[preseinger]

if you define your data model to exclude the conditions where consistency is relevant, it's not particularly interesting, is it?

[HyperSane]

Or it is a reasonable engineering compromise.