Forum Moderators: coopster
The customer is opening two new branches which are quite some distance from each other but wants access to the database from any of the locations. Apart from VPN etc. would it be acceptable to host the database on my server, which is shared. Obvioulsly I would control access to the data but I am concerned that the nature of the information although not commercially sensitive could be open to abuse.
The customer has DSL connection at all locations and already has a company web site which some of the database info could be used for i.e. stock listings etc.
I would be grateful for your thoughts as this is a whole new ball game for me! I use MySql for my sites but never at this depth.
If you set up your shared server environment correctly it's no problem to host the database at neither of the three locations but on your server. An important aspect I would recommend is, that you should take care that the applications are developed in a way that allows to handle the database access via localhost calls. If you need direct access to the database I cannot recommend hosting it outside a DMZ because the MySQL server is of what I heard and read (sorry, but I can't find any specific information right now) not perfectly safe.
Just my 2 cent.
So long...
CT