I have a EE site that has 62k entries. It's a directory site using open data sets. We are expanding to more countries and we expect at least 500k entries to be added in the next year and 400k plus on 2017.
In your opinion; What's the best approch for that # of entries, categories and channels?
One EE install. We have 10 countries. Each country has between 20-50 channels. Each channel has 30-600 categories. Each country shares a unique custom field group between all channels with about 60 custom fields. Potential entries: 1M. What about using a SQL Cloud service like google or rackspace? that will help?
We have 10 different EE installs in different directories in same domain (domain.com/es, domain.com/de, etc). Problems: not sharing templates, not sharing user credentials, etc. Potential entries: 100k per EE install.
Will MSM help? Why? As far as i know; all the information will be at the same db as in setup 1, am I wrong? Is it possible to define each msm license to a directory, or only to a different domain or subdomain?
Thanks in advance,
Sorry for my english; it's not my primary language.