I have build a network using subdomains architecture.
i have mapped real domains to these virtual subdomains and can access those through primary mapped domain(using domain mapping plugin)
On the other hand my exisitng three domains: domainA,domainB,domainC. are having 3 different wordpress installs with their own databases, where there are 1000's of posts and users.
Through forums i have built an understanding that i can import these 3(individual) databases to 1(network) databse.
1) How scalable is the wordpress network and MySql single databse ? Can this handle 10,000 users and their 100,000 or more posts?
2) I have custom roles for users, can I give a user same access rights to all three netwrok sites , while they register only on main network site.
Please give your opinion.