I have a virtual server setup (15 domains on each server). I have a web based application that has a large portion of common data for all domains but some tables that contain custom data. The custom data tables do use keys from the common data. Any suggestions on how to design a single or multiple databases that will allow me to maintain common DB tables as well as custom tables for each domain. This may even cross servers so ideas on DB synchronization is very needed. I am hoping for some really thought out answers hopefully based on experience. Thanks to all.
ps. Also, important will be the desire to prevent multiple domains from being down at the same time if a common data source is down.
ps. Also, important will be the desire to prevent multiple domains from being down at the same time if a common data source is down.