0

I'm coding a program for a small business. The application's going to be used for store-keeping and the ordering of parts for a mechanical shop. I need some type of backend to store orders, article numbers & prices, customers and so on (obviously). Right now I'm using a local MySQL server and running queries directly from the code. This is not ideal because of the risk of a system meltdown or similar. I've thought about running a local MySQL server - with a scheduled backup on a remote host, but I'm hoping there's a better solution. For previous applications I've written a PHP wrapper, and used a web hotel to host the MySQL server - Which isn't ideal either for security reasons. I suppose I should mention the application's written with windows forms in the VS .net environment(in C#). My question's this: How do I set up a MySQL server (or other type of database system) on a remote host - that I can run queries on and then return the result back to the application? Preferably I wouldn't want to handle the MySQL server myself but outsource it. I don't mind renting a server from some host - if it will spare me the hassle of setting up a local server machine to run separately. Are there any solutions that you can rent for this purpose? I'm sure there must be tons of information about this on the interwebs but I can't find anything. I would be very thankful if anyone could give me some pointers!

user2275151
  • 33
  • 4
  • 1
    Hello please see [What topics can I ask about here"](http://stackoverflow.com/help/on-topic). Your question is [primarily opinion-based](http://stackoverflow.com/help/closed-questions). Please post specific code that you are having trouble with. – Dustin Kingen Jul 23 '13 at 16:45
  • 1
    Your setup seems fine to me - what's the problem with running queries from code? Query the local MySQL server from C# using queries you've written and you shouldn't have issues with users crashing things. – Alden Jul 23 '13 at 16:45
  • if you really want to switch, SQLExpress would work as well as MySQL, and it's free, with some limitations it doesn't sound like you need to worry about: http://stackoverflow.com/a/1169641/264607 – BlackICE Jul 23 '13 at 16:48
  • Have you considered Azure? http://www.windowsazure.com/en-us/services/data-management/ – unlimit Jul 23 '13 at 16:55
  • Welcome to StackOverflow. Your question is off topic and highly subjective. Please read [What types of questions should I avoid asking?](http://stackoverflow.com/help/dont-ask). – Matt Johnson-Pint Jul 23 '13 at 16:59
  • What you describe is a two tier application. Direct access to SQL from the client means direct access to SQL and adds to attack surface. Microsoft has WCF for three tier applications. If your app is crashing the system then you are the dimwit not the user. Voting to close based on opinion based and unprofessional language. – paparazzo Jul 23 '13 at 16:59

1 Answers1

1

One way you could do this is rent a cheap VPS and host mysql in there. I have been using DigitalOcean, and it is pretty good. For your needs a $5 per month VPS would be enough.

Or you could use Azure. http://www.windowsazure.com/en-us/services/data-management/

unlimit
  • 3,672
  • 2
  • 26
  • 34