How to split mysql database accross multiple servers ?

Hi , i have a wordpress site with many posts and my server cant handle it anymore so i wanted to ask if there is a way to avoid paying another host packages to run this site in multiple servers and replace it with dropbox or google driver etc . So is there any way to run my site in multiple servers but with google driver or dropbox insteed of aws for example ?
If its plugin , or a way im willing to pay .

MariosElGreco said:

Hi , i have a wordpress site with many posts and my server cant handle it anymore so i wanted to ask if there is a way to avoid paying another host packages to run this site in multiple servers and replace it with dropbox or google driver etc . So is there any way to run my site in multiple servers but with google driver or dropbox insteed of aws for example ?
If its plugin , or a way im willing to pay .

Click to expand...

Just migrate the server to amazon. There's no point in splitting it, it will make it even more difficult to track each posts.

It doesnt work the way you think it does. Just upgrade to a better package , or find a cheaper host that will meet your requirements, much easier that way.

Kode said:

Just migrate the server to amazon. There's no point in splitting it, it will make it even more difficult to track each posts.

Click to expand...

So one database not splitting at all - ok thanks .
But if i have same database in google driver and my server ? im trying to avoid buy another instance of hosting (too much money) . could somehow tell to wordpress site to read some times from google drive and some times from hosting provider ?

virtualpurity said:

It doesnt work the way you think it does. Just upgrade to a better package , or find a cheaper host that will meet your requirements, much easier that way.

Click to expand...

I cant afford upgrading or other host.

MariosElGreco said:

So one database not splitting at all - ok thanks .
But if i have same database in google driver and my server ? im trying to avoid buy another instance of hosting (too much money) . could somehow tell to wordpress site to read some times from google drive and some times from hosting provider ?

Click to expand...

Trying that will just kill your site even if you could somehow make it work. Are you using a caching plugin? If not do so and it will reduce the load on your server quite a bit by lowering your database calls.

Also look at your plugins, some plugins are not all that well written and and suck up way more resources than then should. Most times when I have seen a resource issue it has been a plugin that caused it though once in awhile you will see a bad template.

Another thing to look at if this is a sudden issue is to check and see if your site has been hacked. If so it could be increasing your resource usage.

One more thing to check is bots. Sometimes bots will get stuck on your site and drive your bandwidth and resources through the roof. If so that is an easy fix you can just block the ones causing the problems.

MariosElGreco said:

I cant afford upgrading or other host.

Click to expand...

Your hosting is what your whole business is built on. Trying to build a business on a crappy host is like building a house on sand. cheaper but will start falling apart, collapse, and ultimately fail. Go cheap on something else, your hosting is not what you should be pinching pennies on.

Man, that just sound crazy, hold on a sec, OP you say google Drive but do you mean Google Cloud?
https://cloud.google.com/sql/

Im just opened a free tier account in amazon aws , so now may i can

Kode said:

Just migrate the server to amazon. There's no point in splitting it, it will make it even more difficult to track each posts.

Click to expand...

Are EC2 instancefree ? i just register to amazon for the 1 free year , so what can do really within this year without pay?
please do not make fun , i really cant spare a nickle this time of year

MariosElGreco said:

Im just opened a free tier account in amazon aws , so now may i can

Are EC2 instancefree ? i just register to amazon for the 1 free year , so what can do really within this year without pay?
please do not make fun , i really cant spare a nickle this time of year

Click to expand...

It's free. AWS is pay for how much you use. So if you don't exceed the free tier limit, it'll stay free, but it's typically more expensive (when you pay) than the other web hosting company like HostGator.

You can shard MySQL databases, no problem.. but I'm quite sure that you don't need it. Try to optimize your database instead.
https://wordpress.org/plugins/wp-optimize/ Try this plugin.. it should help you a bit.

Even a small MySQL server can handle pretty high loads that Wordpress can produce.. so get yourself a VPS from cloud service providers which cost the same as a reasonable shared host. Optimize your database for memory usage and you should be good to go.