2 large databases - same server

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

2 large databases - same server

Post 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?
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Post 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.
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Post 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.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Post 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.
ody
Forum Contributor
Posts: 147
Joined: Sat Mar 27, 2004 4:42 am
Location: ManchesterUK

Post 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.
Post Reply