Remote MySQL

cdeam · Post by **cdeam** » Sat Sep 01, 2007 9:10 pm

Could pacsone use a remote MySQL host? There is a MySQLPort option in the ini file, but no MySQLHost. It is not always desirable to run a local database server on the same webserver. Thanks.

Post by **pacsone** » Sun Sep 02, 2007 2:17 am

Having a remote MySQL host would contradict the initial design of PacsOne (PACS in one box), but this option should be very feasible.

So the question is: will there be any market demand for this option? since having a remote MySQL host would mean there'll be another server to maintain or trouble-shoot, thus increasing the complexity and costs for using this feature, so we are not sure if this feature is worthy of any development efforts if there is not enough market demand for it.

cdeam · Post by **cdeam** » Sun Sep 02, 2007 6:23 pm

pacsone wrote:Having a remote MySQL host would contradict the initial design of PacsOne (PACS in one box), but this option should be very feasible.

So the question is: will there be any market demand for this option? since having a remote MySQL host would mean there'll be another server to maintain or trouble-shoot, thus increasing the complexity and costs for using this feature, so we are not sure if this feature is worthy of any development efforts if there is not enough market demand for it.

Here is the scenario which could drive this development. A central mysql/storage server (high mem, RAID) that houses all databases, not just pacsone, and has already configured backup scripts. It is much easier to just make the pacsone database an extension of this central server than to build in RAID and custom backup scripts on a separate pacsone server. I don't know, maybe I'm wrong, but I'm pretty confident someone else could use this feature as well. Of course, this is from the stance that you already have this central server in use (which I do). Thanks for the reply.