Page 1 of 1
multi sites from 1 db?
Posted: Tue Nov 08, 2005 8:45 am
by rsmarsha
Does running mulitple sites from 1 db make a difference? As in 2 forums from the same mysql db?
Asking as i want to move hosts and fasthosts offer 1 db with their package and £25pa for another. I currently have hosting with 1and1 with 5 db's but it's very slow on my sites.
Posted: Tue Nov 08, 2005 12:28 pm
by John Cartwright
Just as long as your host allows you to connect to remote databases.
Posted: Wed Nov 09, 2005 3:01 am
by rsmarsha
I mean i'll move everything to the new host and get the 1 db to start with. If i alter the sites to use the 1 db on the new host will it effect site performance?
Posted: Wed Nov 09, 2005 3:07 am
by phpdevuk
I would think it would have the same effect as both sites traffic using the db, if your websites do receive huge amounts of visitors I doubt you would see any drop in performance. Forums can be a pain when they get busy, the amount of bandwidth they consume can cause woes

Posted: Wed Nov 09, 2005 5:12 am
by onion2k
It's certainly possible. I prefix all my database table names with a short code that relates to the site (eg all my ooer.com tables are prefixed with ooer .. all my mosaic tables are prefixed with mos..). That way I can have as many sites in the one database as I like. Generally I don't though. Makes back ups and stuff more difficult.