For important or high transaction applications we recommend a mixture of replication and clustering. This will give you complete automatic fail-over of databases as well as load balancing of transactions across multiple databases.
Replication is a method for duplicating and sharing data (and database objects) across multiple databases. Preserving consistency by syncing between databases.
Replication is usually used by mobile applications or server apps that are distributed and might have conflicts in the data.
Clustering is essentially installing more than one SQL Server instances into a cluster. It uses a SAN for shared storage. It lets you access all the data for the SQL Server instance from any instance (or node) you want. So if one node has an issue, you can seamlessly switch to a different node on the cluster.
If you need HA (High Availability). If you want to be able to workaround hardware failures. If you need to patch with no downtime. If you need things to ‘just work’.
It’s reassuring to know that Hyve will take care of everything server-side so we can focus on doing what we do, building th... More
I like working with Hyve because they are honest, transparent and down to earth.They have a knack for taking even the most co... More
As a start up, we knew nothing of servers and hosts and went with the first one that was recommended. They were based in the ... More
Carluccio’s selected Hyve to host www.carluccios.com, and also manage its online ecommerce and website security. The site p... More
British Airways’ global audience means that traffic spikes can occur at any time of the day or night. Hyve’s cloud platfo... More
Running several sites for Tesco is a unique challenge when it comes to hosting, as with the click of a button potentially mil... More
Hyve provides LiveSource with a high-performance hosting platform in multiple global locations. It is great to partner with a... More
A very friendly and highly technical team available to extend all possible help at any time. Excellent services – all issue... More
My experiences with Hyve have been very good. The response time is quick so you don't spend your time on a telephone waiting.... More