I'm more of an application programming guy than network/internet guy so excuse any ignorance on my part.
I am currently using shared hosting on an IIS server.
I running SMF Forums and a business on the IIS server. I have a payment system that I've programmed tied into the MySQL SMF database. This payment system uses ASP.net. I'm a .Net programmer. SMF is also being currently ran on the IIS server, and it does ok.
I'm really wanting to start running my forums on a separate Unix Server.
So my question is, can i run my ASP.net scripts on my IIS server that access the MySQL database on a separate Apache server? The Apache server and IIS server would have different domains (I'm guessing that'd be required).
I think this is possible, but wondering what others think. All I should need to do is change some connection strings on my Web.config on my IIS server to point to the new SQL databases. But just wondering if anyone had any info or advice.
Definitely. MySQL offers native support for remote connections. Just replace "localhost" with the IP of your remote MySQL host. Both your servers should be located in the same DC, preferably in the same private network -- to reduce latency.
No integration is needed between your IIS and Apache servers. Just grab any Linux/Unix server and you're done. You'll probably need the .Net drivers for MySQL although I would be surprised if they're not integrated already.