I have a customer that has 2 domain names, lets say store1.com and store2.com. These stores will offer the same products from the same inventory.

So, my question is....

Is it possible to have 2 domains share some of the tables, specifically the products tables? I guess we could use all of the tables but the problem is then the different paths and domain names. Maybe it's possible to setup mysql to replicate some of the tables back and forth or maybe do a reconciliation throughout the day or something? The only thing about reconciling though is if there is a product that we only have 1 of and someone buys that one product it will still show as available until the reconciliation occurs.

Maybe someone could point me in the right direction here?