I currently have a single host (with HostGator), running multiple separate instances of WP, on the primary domain and many add-on domains.
For one of my sites (on an addon domain), I wish to expand and possibly use Multisite to organise it. The site is rather complicated, in that it has some normal blog style posts, but also a lot (read 10,000's!) of syndicated posts. The reason: I'm using the WP platform as a search engine, with each syndicated post being an article to search, using my own bastardised version of the Relavanssi plugin!
Currently the syndicated posts are all from one country. I wish to branch out, duplicate this framework and syndicate posts from other countries. For scalability reasons I figured it best not to shove syndicated stuff from other countries into the existing DB (under new category/tag etc) and that a separate DB per country would be a better route. Do you agree?
So I'm thinking of going Multisite, have a primary site with the normal blog posts etc, then have a separate sub-site per country of syndicated content. Sound reasonable?
Any tips, any gotchas?
I was reading about path based subsites not working, due to my site having been up for more than a month - some permalink issue?
Can I go the subdomain with this domain being an addon domain and this not in /public_html, but in /public_html/mydomain_com/ ?
How can I go about testing a multisite setup prior to rolling out live? I already have a duplicate of the site for testing, on a subdomain: test.mydomain.com. I tried enabling it on this test site and it just redirected me back to http://www.mydomain.com. I changed DOMAIN_CURRENT_SITE define, but then the site timed out with DNS issues...