Sharing database

Throughout multiple sites

[rknuppel]

I have a quick question. I run 3 or 4 websites that have similar tables, we'll call them the "Teams" and "Schedule" tables. Currently, I manage these tables on all 3 websites individually. But I seem to be doing the exact same thing keep these tables up to date, on all 3 websites.

Is it ok to keep like a master copy of these tables somewhere, then just use this table on all 3 of my sites? I'd be connecting to a database across different sites, is this ok?

Sorry if I'm confusing everyone. Let me know what you all think.

Ryan

[kamakaze]

I dont see why not. Instead of using localhost you would need to use the hostname where the database is setup at. Other than that it should work like normal.

[rknuppel]

It's not considered "bad practice" or anything though?

[kamakaze]

The only problem I could see as a result of this is if you have one site that is hitting the database so hard that it causing performance issues for the other sites.Other than that I think it would be fine and much easier to manage.

[JKMitchell]

It's not considered "bad practice" or anything though?

From a database point of view it would be considered good practice as you only have one source of data and don't have to worry about differences between the databases.

Of course, as has been said, if you have one site hitting the database at a high rate it could slow down the others, although from experience it would have to be a very high hit rate.