Don’t Use a Dedicated Server for SQL
There are several approaches to creating a database but the practical approach today is to use the cloud instead of trying to build on top of a dedicated server.
By Howard Young
You need a solution to your backend database issues and using a dedicated server is overkill and can be resolved by using the Cloud instead. In most cases you probably could move your data to a preconfigured SQL cloud server, but scaling up to a cloud instance will usually meet your current requirements and provide for future growth. In this article, we will show you how to do this.
Cloud Elasticity Important for SQL
You have to remember that the Cloud infrastructure is basically a server running multiple virtual machines divided up between your application and other applications running on that server giving you fractional capability of the whole system. Often this is adequate to handle the worst case load scenario. However, what we like about the Cloud is that you can reprovision your server image with more memory and processors if ever needed. Of course, if your application requires multiple SQL servers, that is a different configuration, but will scale out to multiple Cloud instances too.
We like to start of our DBaaS configurations with the smallest Cloud the provider will provision. We’ve tried both 64M instances and 256M instances and found that the later provides good performance with enough cache to handle most queries. RackSpace has minimum Cloud Servers with size of 256M; however, if you use Open Cloud, the smallest size which you can now provision is 512M . (It is unknown at this time if they are phasing out their original Cloud servers, and thus, forcing us twice the size.)
Why Build Your Own DBaaS?
There are many cloud providers which to provide a database for you right out of the box. All you have to do is create an account and populate the database with the structure. These are public databases addressable on the edge of the cloud, or front-end, so there is very little you can do to optimize the performance.
Whereas, if you build your own in the cloud, you can always insert an object for balancing the load or caching objects prior to reaching the database. On RackSpace, your server image is supplied with two networks — one public facing and one private facing — giving you the capability to insert a mechanism of this type.
How We Can Help You
there are several ways we can help you get started. One, the first thing we can do is analyze your requirements and give you the necessary design to meet those requirements. Usually, this is just a matter of installing a database on a cloud server for you and migrating your data over to the new database and configuring your application to connect to the new system. However, sometimes it requires a more complicated system so the analysis will come in handy if you decide to use our services.
The best way to do this is to contact us and we’ll determine the best approach for you.