One MySQL Database In 20 or More Websites

[itnecor]

I'm new in web programming, Currently I have 20 static websites in hostcentric and my client asked to make all those sites a dynamic/database driven site using only one MySQL database so that if they made changes(through the CMS)in one site it will propagates to all. They do not want the idea of 1 database for 1 site/domain.

According to Hostcentric Tech Support they are not yet supporting a centralized database. So, what do you think is the best alternative, how can I configure a way to make the databases synchronized.

Please help me!

[omoutop]

It would by hard for you since you are new in web programming to synchronize somehow all the databases...so the best idea is to create only one...however, such database will be huge and there are several matters to think before doing that...However, there is a CMS in my mind that creates dynamic websites and can be used for creating more than one in a single DB(I am 99%sure)...this one is Drupal...u can find it here [drupal.org...] ...it requires some searching in order to make it run properly but once u master it it is perfect for simple database driven websites...hope I helped...

[jatar_k]

Welcome to WebmasterWorld itnecor,

since they have no central db option and you need them all to be synced then one option would be to create your own central db.

Either dedicate on of the db's as central or maybe even put it on a local machine. The most important thing here is to define the process and then make sure everyone only makes changes in one place and then you can export from there to all the other db's.

I would also make a schedule for exporting to all other db's, maybe once or twice a day, though I like the thought of once a day best.

[itnecor]

Thanks jatar_k and omoutop, because of you I have an idea now how to do it. Thanks!