Page 1 of 1

2 large databases - same server

Posted: Sat Mar 03, 2007 4:30 am
by s.dot
So, I have this dedicated server -- currently only serving one site. The database on that site is nearing 1 GB in size. That's fine.. it's mostly storage. The MySQL load isn't too high, due to good scripting and clever use of cron jobs.

Now, I'm ready to add a second site on to this server. Same issue.. this database is huge. Mostly just storage, and again the SQL load won't be high.

However this database is 3.6 GB in size.

My question is, can the server handle it?

I know a single database can't be over 4 GB in size (i think (CentOS OS)).

I don't want to make my current running site have downtime by trying to implement this second massive database that won't work.

So, will I have any problems?

Posted: Sat Mar 03, 2007 5:10 am
by onion2k
We've got (I think) 8 databases over 1 gig on one server. And it's the webserver too, serving over 15 million pages a month at peak. It's never been a problem.

Posted: Sat Mar 03, 2007 5:50 am
by s.dot
This server is the webserver/database server/mail server/dns server all rolled into one. serves about 5 million hits/month.

Only 1 gb of ram on it though.. might have to go to two if I decide to use the second site on it.

So I guess if you've got 8 1GB databases on one server, then 1 1GB and 1 3.6GB database shouldn't be a problem.

Posted: Sat Mar 03, 2007 6:22 am
by onion2k
scottayy wrote:Only 1 gb of ram on it though.. might have to go to two if I decide to use the second site on it.
Ah, we've got either 4Gb or 8Gb, can't remember, and it's a dual Xeon thing too.

Posted: Mon Mar 05, 2007 11:39 am
by ody
If your using 64bit hardware, running linux with LFS and using MySQL there is no reason why you should not be able to break the 4gb barrier. Check your tables with something like:

show table status like 'table name' \G

And look for "Max_data_length:" I have 281474976710655 on my opteron servers which is erm.. a hell of a lot of available storage.. but don't forget to check your filesystem for LFS support. If you have "Max_data_length: 4294967295" your limited to 4gb.

This can still be changed.. google for "mysql 4gb limit" or something and your bound to find help.