Let's suppose that I will create an e-commerce for a restaurant chain that has several restaurants and in each restaurant the menu is a little different. The user will enter the website and input its zip code. Based on the zip code he will be redirected to the nearest restaurant menu.
How can I create multiple stores or websites in which each will have its own database?
The higher purpose of this is: speed (one database for the several restaurants would be slow) and sync (I need to figure some way to sync the products on the restaurant with Magento's database. To make sure that users can't buy something that is out of stock.)
The solution that I've thought is to have the homepage in one server and several other servers with one Magento installation for each restaurant. But this would be insane.
A similar question has been asked. But the answers were confusing and nonconclusive.