I'm going to be developing a php site (actually more of a application), but the standards and restriction of what I'm building make MS SQL Server the most appropriate DB solution (will also be running things like SSRS).

So what would be the best way to do this in terms of performance and maintainability?

An obvious solution is to run a virtual machine on the same physical machine as the web server. I haven't yet picked a hosting solution and I know this will eliminate any of the simpler/cheaper hosting solutions, since this will require much more configuration than they'll allow.

I also read in answer to a somewhat similar question here that dual booting was an option. What is this? The only dual booting I'm familiar with is having the option to boot to either OS, not run both concurrently.

How big of a performance hit will I take if I choose to host the DB on a separate machine all together? Or if I elect to have both servers hosted through the same host?

I really don't want to go the route of running the web app and php on MS Server, so that's pretty much out of the question. If push came to shove, I suppose I could just have a MySQL DB on the same machine then replicate that DB on a different MS SQL Server machine. Of course any reports or data import/export wont be real-time.

So any advice or suggestions is really appreciated. Luckily I'm still in the early planning phase and have time to consider different options.

  • Are you sure PHP is the right language for this and that Ubuntu is the right operating system? If you have to deal with Microsoft technologies, you probably shouldn't be using either PHP or Ubuntu. – Michael Hampton Jan 31 '14 at 12:05
  • PHP and MS SQL get along fine (there's a module for it), and this all runs correctly on any Linux flavor. I'd highly recommend against Ubuntu for production work, though. – Nathan C Jan 31 '14 at 13:38
  • @MichaelHampton , php is the language I'm developing in, it's not negotiable. – jreed121 Feb 1 '14 at 6:57
  • @NathanC, yeah, I've worked with php and MS SQL before so I know they play nice. My question is regarding server infrastructure and what would be the optimal setup, mainly in terms of performance, if I elected to use both. – jreed121 Feb 1 '14 at 7:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.