Microsoft SQL Server Witness - Beta (v14 Infinity)
Service-level response times are the same as for general-release features. Although this new feature/technology has undergone significant testing and is not expected to change significantly prior to general release, the use of this feature/technology is not recommended for production environments. You are encouraged to use this feature/technology for development and testing purposes only.
| Table of Contents | |||
|
Infinity
Leading edge features |
|
Description
Configures a Microsoft SQL Server Express database server that can be used to add a mirroring witness to a Microsoft SQL Server mirroring pair. The witness is an optional instance of SQL Server that enables the mirror server in a high-safety mode session to recognize whether to initiate an automatic failover. Unlike the two partners, the witness does not serve the database. Supporting automatic failover is the only role of the witness.
Features
- Performs automatic failover of a mirrored pair of SQL Server Database servers.
- Microsoft SQL Server Express is included (no license required).
- Does NOT store database content locally.
Technical Overview
Example Reference Architecture
Software Application Versions
The following applications are included in the image (and are not installed using boot scripts like other lightweight applications) in order to reduce boot times.
- .Net 3.5 SP1
- .Net 4.0
- .Net 4.5
- SQL Server Express 2008R2 (on Windows 2008R2 image)
- SQL Server Express 2012 (on Windows 2012 image)
Supported Clouds
- Amazon Web Services EC2
- Citrix CloudStack (3.0.6) (XenServer, VMWare and KVM)
- Rackspace Open Cloud (US, UK)
- SoftLayer
- Windows Azure
- Openstack Folsom
Supported MultiCloud Images
- Windows 2012 - Amazon, Cloudstack, Rackspace Open Cloud, Windows Azure, Openstack Folsom
- Windows 2008R2 - Amazon, CloudStack, Rackspace Open Cloud, SoftLayer, Windows Azure, Openstack Folsom
- © Copyright 2015 RightScale Technical Support