multi sites from 1 db?

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
rsmarsha
Forum Contributor
Posts: 242
Joined: Tue Feb 08, 2005 4:06 am
Location: Leeds, England

multi sites from 1 db?

Post 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.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post by John Cartwright »

Just as long as your host allows you to connect to remote databases.
rsmarsha
Forum Contributor
Posts: 242
Joined: Tue Feb 08, 2005 4:06 am
Location: Leeds, England

Post 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?
User avatar
phpdevuk
Forum Contributor
Posts: 220
Joined: Mon Jul 04, 2005 5:31 am
Location: UK
Contact:

Post 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 :D
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

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