2 large databases - same server
Posted: Sat Mar 03, 2007 4:30 am
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?
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?