Hi,
Here is the scenario. Our website is hosted by hosting company. We plan to host the database at our office. The website connects to our database at our office. Is this possible? Is there a performance issue?
Thanks.
Dennis
That certainly is possible.
Things to take into mind, you have a open connection to your database server to anyone on the intranet, so you have to secure the connection via firewall and IP access control list. You might also think about creating a Web Service at the location where your database is for the application on hosts machine to access your data. Connection to the service via SSL would be relatively secure.
Secondly, there will be a slowdown in perfermance since the performance of your website rely's on the speed of yours hosts connection, the speed of your connection, and traffic on both of your networks. A local connection is faster than a remote connection, especially for accessing large amounts of data and a high number of queries. So if your pipe from the host to your database location is not sufficient to support the traffic for you site there will be a performance issue.
It's likely possible (depending mostly on your database engine, and thefirewall situation between your office and the hosting company) butthere may be some pretty serious performance issues. The timethat it's going to take to get data across the Internet could besignificantly longer than over a LAN. Personally, I'd bepretty cautious about this configuration. Not that it won't work,but certainly, test it well.
0 comments:
Post a Comment