Availability Group setup in Active Roles
If you have the Active Roles Administration Service installed, you can configure it to use a database belonging to an Always On availability group (also called an availability database). When configuring Active Roles, you must store the Management History data and Configuration data in separate databases. Each of the two databases (or both) can belong to an availability group.
NOTE: Active Roles does not support the replication of availability databases. Therefore, if the Administration Service is configured to use an availability database (either for the Management History Database or for the Configuration Database), then the data of that database cannot be replicated.
For more information on how to install and configure the Administration Service, see the Active Roles Quick Start Guide.
By using the availability group listener, the Administration Service can connect to the current primary replica of the availability group that holds the Active Roles database without knowing the name of the physical instance of the SQL Server that hosts the primary replica. The listener also enables support for failover redirection. This means that in case of a failover, the listener automatically redirects the Administration Service connection to the new primary replica.
Prerequisites
-
The Active Roles database is added to an Always On availability group on the SQL Server.
For instructions on how to configure an availability group, and how to add a database to an availability group, see Getting Started with Always On Availability Groups (SQL Server) in the Microsoft SQL documentation.
-
Active Roles replication is not configured for the Configuration data and the Management History data.
To configure the Active Roles Administration Service to connect to the database via the availability group listener
-
Start the Active Roles Configuration Center on the computer running the Administration Service, or connect the Active Roles Configuration Center to that computer.
-
On the Active Roles Configuration Center Dashboard, in Administration Service, click Manage Settings.
The Connection to Database page opens.
-
To modify the database connection of the Administration Service, in Connection to Database > Active Roles databases, click Change.
-
If either or both of the databases belong to an availability group in your Active Roles environment, specify the availability group listener. Otherwise, do not change the value of SQL Server.
-
If the Configuration database belongs to an availability group, enter the DNS host name and, optionally, the TCP port of the listener of that availability group in Connection to Database > SQL Server.
-
If the Management History database belongs to an availability group, enter the DNS host name and, optionally, the TCP port of the listener of that availability group in Connection to Management History Database > SQL Server.
The value of SQL Server must be identical to the DNS host name and, optionally, the TCP port of the listener of the availability group to which the database belongs.
Example: Specifying the availability group listener in the SQL Server
If the DNS host name of the listener is AGListener and the TCP port used by this listener is 1234
, the value is AGListener,1234. You can omit the port number in case of the default port, 1433.
-
Click Next.
-
To complete the configuration, follow the instructions of the wizard.
Using database mirroring
Active Roles can use the Microsoft SQL Server database mirroring technology to improve the availability of the Administration Service. Database mirroring provides a standby database server that supports failover. Once the current database server fails, the Administration Service can recover quickly by automatically reconnecting to the standby server.
Database mirroring increases database availability by supporting rapid failover. This technology can be used to maintain two copies of a single Active Roles database on different server instances of SQL Server Database Engine. One server instance serves the database to the Administration Service; this instance is referred to as the principal server. The other instance acts as a standby server; this instance is referred to as the mirror server.
Role switching
Within the context of database mirroring, the mirror server acts as the failover partner for the principal server. In the event of a disaster, the mirror server takes over the role of the principal server, bringing the mirror copy of the database online as the new principal database. The former principal server, if available, then assumes the role of the mirror server. This process, known as role switching, can take the form of:
- Automatic failover If the principal server becomes unavailable, quickly brings the mirror copy of the database online as the new principal database.
- Manual failover Allows the database owner to reverse the roles of the failover partners, if necessary.
- Forced service If the principal server becomes unavailable, allows the database owner to restore access to the database by forcing the mirror server to take over the role of the principal server.
In any role-switching scenario, as soon as the new principal database comes online, the Administration Service can recover by automatically reconnecting to the database.
For more information about the database mirroring technology, and instructions on how to set up and administer database mirroring on SQL Server, see the “Database Mirroring” topics in the SQL Server product documentation at http://msdn.microsoft.com/en-us/library/bb934127.aspx.
|
NOTE: The Active Roles replication function is not supported for the databases that have mirroring set up. If you attempt to perform the “Promote to Publisher” or “Add Subscriber” operation on such a database, you receive an error. |
Database Mirroring setup in Active Roles
Database Mirroring setup in Active Roles
Here we assume that mirroring for the database of Active Roles is already set up on the SQL Server side in accord with the recommendations and instructions found in Microsoft’s documentation, so that the following conditions are fulfilled:
- The Administration Service is connected to the Configuration database on the principal database server.
- Replication is not configured for the Configuration database (the database server acts as a stand-alone server as applied to Active Roles replication).
- The Administration Service is connected to the Management History database on the principal database server (by default, the Management History database is the same as the Configuration database).
- Replication is not configured for the Management History database (the database server acts as a stand-alone server as applied to Active Roles replication).
Under these conditions, the Administration Service can be instructed to automatically connect to the new principal database in the event of database server role switching. On the computer running the Administration Service, add a string value to each of these two registry keys, and then restart the Administration Service:
- Key: HKLM\SOFTWARE\One Identity\Active Roles\7.6.2\Service\DatabaseConnectionString\
Value Name: Failover Partner
Value Data: <Identifies the SQL Server instance that currently owns the mirror server role for the Configuration database>
- Key: HKLM\SOFTWARE\One Identity\Active Roles\7.6.2\Service\CHDatabaseConnectionString\
Value Name: Failover Partner
Value Data: <Identifies the SQL Server instance that currently owns the mirror server role for the Management History database>
If the default instance is used, the value data is the short name of the computer running SQL Server. Otherwise, the value data is the short name of the computer, followed by a backslash, followed by the name of the instance (such as ComputerName\InstanceName).
By default, the same database is used for the Configuration and Management History data; therefore, the value data would be the same in the DatabaseConnectionString and CHDatabaseConnectionString keys.
To restart the Administration Service, open Configuration Center and click the Restart button at the top of the Administration Service page in the Configuration Center main window. For instructions on how to run Configuration Center, see Running Configuration Center later in this document.
In the Active Roles console, you can view the mirroring status of the Configuration or Management History database that is used by a particular instance of the Administration Service:
- In the console tree, select Configuration | Server Configuration | Administration Services.
- In the details pane, double-click the name of the Administration Service whose database you want to examine.
- In the Properties dialog box, click the Configuration Database or Management History Database tab, and observe the information in the Database mirroring area:
- Role Current role of the database in the database mirroring session (Principal or Mirror).
- Partner The instance name and computer name for the other partner in the database mirroring session.
- State Current state of the mirrored database and of the database mirroring session. For more information about this field, see the “Mirroring States” topic at http://msdn.microsoft.com/en-us/library/ms189284.aspx
If no information is displayed in the Database Mirroring area, then database mirroring is not configured.
You can also view the mirroring status of a Configuration database or a Management History database on the General tab in the Properties dialog box for the object representing that database in the Configuration/Server Configuration/Configuration Databases or Configuration/Server Configuration/Management History Databases container, respectively.