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?
2 large databases - same server
Moderator: General Moderators
2 large databases - same server
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.
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.
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.
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.
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.