Which server can I solve for MySQL, Windows or Unix / Linux / Ubuntu / Debian?
I am working on a SaaS project and mysql is our main database. Our applications are written in C # .net and run under Windows 2003 server.
Considering service, cost, options, and performance, which plattaform server can I decide to host MySQL, Windows or Unix / Linux / Ubuntu / Debian?
The script looks like this:
The server I am starting today has a modal transaction volume. Databases are growing by 5 MB per day and we expect a 50 MB increase in a couple of months and this is critical.
I don't know how big the database will be. We rent a VPS to host an application server and databases.
Most of our queries are simple, but our ORM Tool uses subqueries all the time. We also run simple and heavy reports. Some of these are triggered when clicked by the user, but most are executed for the queue.
Buying extra space for sharing will be nice as we have got more clients. This SaaS project after all.
a source to share
I think you need more information to make an informed decision. It is difficult to simply pull out a “best” answer based on a lack of specific information.
- What is your expected transaction volume?
- How big will the database be?
- How complex are your queries, i.e. do they work for a long time or relatively fast?
- Are you hosting the application on your own server in your own place? If you need to buy additional space for sharing, an additional server might not be the best option.
- How "critical" is this database? Ie, perhaps you need replicated servers to ensure stability.
There is a server sizing tool in the http://www.sizinglounge.com/ window , so you should check that. It looks like your server may be less than its lowest level, but this should be a good place to start.
If it's a mission-critical application you need to do some kind of replication to the secondary server if the primary fails, so you're definitely looking at two systems. This should be in addition to a good backup plan.
Considering that you are not sure how big this amount is, you can simply continue to rent a server. For your backup, one idea is to look at running MySQL on an Amazon EC2 instance. BTW it's important to have a remote replicated server. If you have two systems next to each other and there is an environmental problem, they can both be commission-free at the same time. But with the copy removed, your options are open to potential work around it.
If you are doing many read-only queries locally and hosting the site somewhere, it might make sense to set up a local copy of the replicated database for the query. This can potentially improve both your site and local performance. Plus it will give you a good feat with a local copy under your control.
NTN, Brandon
a source to share
When developing, you can use your windows box to start the MySQL server. If and when you want your DBMS on a separate server to be on a Windows or Linux server.
MySql and supporting backup tools etc. probably have more features on Linux.
There are also third party vendors that will host your MySQL database on their servers. The advantage is that they will handle backups, maintenance, etc.
Also: look into phpMyAdmin for use as a great administration tool.
Larry
a source to share