Connect to MySql on a remote server?

[accelerator]

Tweet

Hi All

I wish to start using a MySql database on my site.

I currently use vb.net for my site pages.

If I had access to a MySql database with another hosting company, would it be possible, leaving my existing site pages where they are, for them to connect to the MySql database remotely?

In other words, does my web page hosting and the MySql database have to be provided by the same hosting company?

Sorry if this is a rather simple question, but I was just wondering.

Cheers All

accelerator

[dmorison]

It is certainly possible; but it is going to depend on a couple of things.

At the host where MySQL will be running:

* MySQL must be "bound" to a public IP address and listening on a port that you know of (3306 by default)

* You must be able to make a network connection INBOUND to that host's network on the port on which MySQL is listening (3306 by default). It could well be firewalled off...

At the host where your Website/VB.Net is running:

* You must be able to make a network connection OUTBOUND on the port on which MySQL is listening. This could also be firewalled off...

If the above is in place then there shouldn't be any problem - simply configure your database connector for the remote IP address and port number as required.

Hope this helps!

[accelerator]

Thanks for that. I'll have to have a word with my hosting companies.

Rgds

accelerator

[monkeyboy]

Don't forget if you are loading your data from a separate network to test the performance. If you have limited bandwidth at either server any data transfers between them may well eat into your monthly transfer allocation or overall bandwidth.

As you are using VB.NET you can reduce the load on the database and network by using data caching, assuming your ado.net provider supports caching.