Can a magento store with 1000 websites and daily automated product updates be made to work by using multiple mysql per website?

The mysql performance of running the magento for this situation under one mysql installation is giving a headache. I wonder if it is feasible to setup an individual mysql for each website so that updates to the catalog can occur concurrently across all websites.

One thought on “Can a magento store with 1000 websites and daily automated product updates be made to work by using multiple mysql per website?”

  1. It sure can be made working within a cluster and if you queue your updates and plan ahead for such. But it won’t be cheap and i’ll guess you ‘ll need a mysql instance for every 30 to 50 website. It’s worth to observe mysql sharding for heavily used tables and ways to run all this inside RAM to dramatically pull down the resource usage needed.

    and for such task you have to be living and breathing INNODB person

Leave a Reply

Your email address will not be published. Required fields are marked *