MYSQL limitation on my hosting. Any ideas?

[bnashenas1984]

Hi everyon
I bought a hosting 2 month ago and I'm happy with it.
510 GB webspace
5000 GB Monthly bandwith

for 7 dollars per month. Then I started to make a chatroom with (Flash + Actionscript) for client side scripting and (PHP) for server side.

But after setting up everything I realized that the server I have my hosting on has a MYSQL limitation. Here are the details

100,000 Updates /Hour
100,000 Questions /Hour

It would be MAX 28 requests per seconds. But a chatroom with minimum 1000 users online will generate more trafic than this limitation.

Do you have any idea what I can do? because I already have paid for 1 year. Can I use an external MYSQL server or is there any other way to fix this problem?

Any suggestions will be highly appriciated.

Thanks / Behzad

[Atli]

Hi.

You can of course have your application use a different MySQL server, although that may cause some security problems. It would require you to allow connections from a remote IP address, as apposed to a local server that would be limited to a local network.

For a web with that much traffic, maybe you could contact your host and have the limitation removed or increased?
I bet they would want to charge you something extra, but that's just how it goes.

Unless, are you able to set up your own server?
It's more challenging but it would remove all limitation.

[bnashenas1984]

Thanks for the reply Atli
Actualy I'v already contacted them but the answer was no. Because they have more than 150,000 hostings on their servers they can not increase the limitation. (Even if I pay more) I know it sounds crazy

I also know that the remote MYSQL server should be set to allow external connections but what I'm wondering is if this slows down the program to connect to external database?

One other thing I need to ask. How much does it cost to own a server? I'v never set up a server other than local ones like IIS and Apache.

I'm sure it needs a very fast connection.

Oh by the way. there is one more option which is more complicated. This limit they have on their database is for each MYSQL server. I made several databases and realized that each one of them is stored on a different server.
That means if I make 4 databases it will increase the limitation 4 time more. But how can I use several databases in 1 script.
Is there any way to mix all of them?

[mwasif]

Setting up your own server (at home/office) needs much more attention and you have to deal a lot of things yourself. If you have that much traffic and can afford $150 per month, then you should go for dedicated server from some hosting company like The Planet etc.

If you have several databases on different servers then you can not use them in a single query, otherwise you can use if they are on the same server e.g.

SELECT db1.table_name.username, db2.table_name.location
FROM db1.table_name.id, db2.table_name.user_id