I've been looking for a definitive answer, but can't seem to find one.
We have one Magento server (one store), and one write enabled mysql database. Upper management want's to scale out TWO Magento web servers behind a load balancer, but have them connected to the SAME write database.
So, two Magento installs, each a clone (one store, on redundant www servers), both ACTIVE, and writing to ONE backend mysql database.
I know it's possible if you have two stores > one database, but I'm almost certain you can't have the same store writing to ONE mysql database, because of the old auto_increment field clash should two clients happen to hit something that causes a new row to be inserted, and both www servers try to write to the same database at the same time.
Am I correct, or is there something in Magento (Enterprise) that circumvents this?