I was wondering how Xtradb handles multiple writes in cluster. If you have auto-increments or created users with ids on same table how does it handle that? Would there be multiple same ids if 2 different writes happen at same time on different nodes? I am sure they have worked out something smart about it but how reliable it really is?
Galera, so library used in Percona XtraDB Cluster, by default sets different pools of auto increment values for each node, so no conflict possible for simple inserts. For more complicated cases there are mechanisms to avoid and resolve conflicts.
You can find more information here:
[URL]Percona Live - Open Source Database Conference
[url]http://www.mysqlperformanceblog.com/2012/11/20/understanding-multi-node-writing-conflict-metrics-in-percona-xtradb-cluster-and-galera/[/url]
[url]http://www.mysqlperformanceblog.com/2012/08/17/percona-xtradb-cluster-multi-node-writing-and-unexpected-deadlocks/[/url]