Say I’ve 50,000 posts in my present WordPress set up. Could also be it can develop greater than 5,00,000 submit’s sooner or later. Now I wanna Scale the database.
I wanna put ,
1-50,000 posts > database server 1
50,001- 1,00,000posts > database server 2
1,00,001- 1,50,000 > database server 3
N posts – N posts > database server N
And, when I’ll go to WordPress dashboard, I can see the whole submit rely .. mixed 3 database submit … Say 1,50,000 submit’s… Additionally, when an consumer will browse my web site…. Completely different posts will fetch from totally different database…. (Solely Learn)….
Now, (write question)-
When I’ll write submit… From WordPress admin, the submit will get saved in one other database server. Now, If I see … Write Database server reached 60,000 or 70,000 posts … I Will merely put this server in ‘learn’ database cluster….
I’ll get one other server for “write” , once more 60,000 or 70,000 posts …merely put it ‘learn’ database cluster….
Like this N….