Optimizing database migration in high availability and disaster recovery computing environments
Disclosed herein are methods, systems, and processes to optimize migration of databases in high availability and disaster recovery (HADR) computing environments. An endpoint associated with a new primary database server is modified to be compatible with a first encryption mechanism and a second encryption mechanism. Database mirroring between an old primary database server and an old secondary database server is disabled, and database mirroring is configured between the old primary database server and the new primary database server. A failover operation is performed by migrating one or more databases from the old primary database to the new primary database, and database mirroring between the old primary database server and the new primary database server is disabled.
1. A computer-implemented method comprising:
operating an old primary database server and an old secondary database server in a mirroring configuration to mirror a database on the old primary database server to the old secondary database server, wherein the database on the old secondary database server that is mirrored from the old primary database server is not readable while accessible from the old primary database server, wherein the mirroring configuration employs a first encryption method to connect the old primary database server with the old secondary database server, the old primary database server and the old secondary database server operate exterior to a high availability group cluster as a result of the mirroring configuration;
providing a new primary database server having an endpoint, wherein the endpoint is compatible with the first encryption method and a second encryption method, wherein the new primary database server is configured for inclusion in the high availability group cluster, wherein the second encryption method is an encryption method employed in the high availability group cluster and is different from the first encryption method;
disabling database mirroring between the old primary database server and the old secondary database server;
configuring database mirroring between the old primary database server and the new primary database server using the endpoint while the endpoint is configured to connect with the old primary database server using the first encryption method;
performing mirroring of the database between the old primary database server and a database of the new primary database server while the endpoint is configured to connect to the old primary database server using the first encryption method, wherein the mirroring of the database between the old primary database server and the database of the new primary database server occurs exterior to the high availability group cluster, the new primary database server operates as a non-readable secondary database server while performing the mirroring;
performing a failover operation upon synchronization of the database between the old primary database server and the database of the new primary database server, wherein the failover operation comprises executing migration operations to enable functioning of the database at the new primary database server;
disabling the database mirroring between the old primary database server and the new primary database server; and
enabling the new primary database server and the database of the new primary database server for operation in the high availability group cluster, wherein the endpoint of the new primary database server is operable for connection with other servers in the high availability group cluster using the second encryption method, wherein the high availability group cluster is capable of concurrently using one or more readable secondary databases.
2. The computer-implemented method of claim 1 , wherein the second encryption method is an Advanced Encryption Standard (AES), and the first encryption method is a Rivest Cipher 4 (RC4).
3. The computer-implemented method of claim 1 , further comprising:
communicating a copy of a replica of the database from the new primary database server to a new secondary database server in the high availability group cluster, wherein the new secondary database server and new primary database server are configured for communication using the second encryption method, and wherein the replica of the database is generated pursuant to mirroring of the old primary database server to the new primary database server.
4. The computer-implemented method of claim 3 , further comprising:
determining that the endpoint indicates the first encryption method and the second encryption method.
5. The computer-implemented method of claim 3 , further comprising:
generating a full backup of the database and corresponding database logs from the new primary database server; and
restoring the full backup of the database and the corresponding database logs on the new secondary database server.
6. The computer-implemented method of claim 1 , further comprising:
generating a full backup of the database and at least one log backup for the database on the old primary database server; and
restoring the full backup of the database and the log backup on the new primary database server to facilitate the database mirroring.
7. The computer-implemented method of claim 1 , further comprising:
as part of the migration operations, changing a connection string of an application from the old primary database server to the new primary database server so as to require a single connection string change.
8. A non-transitory computer readable storage medium comprising program instructions executable to:
operate an old primary database server and an old secondary database server in a mirroring configuration to mirror a database from the old primary database server to the old secondary database server, wherein the database on the old secondary database server that is mirrored from the old primary database server is not readable while accessible from the old primary database server, wherein the mirroring configuration employs employing a first encryption method to connect the old primary database server with the old secondary database server, the old primary database server and the old secondary database server operate exterior to a high availability group cluster as a result of the mirroring configuration;
provide a new primary database server having an endpoint, wherein the endpoint is compatible with the first encryption method and a second encryption method, wherein the new primary database server is configured for inclusion in the high availability group cluster, wherein the second encryption method is an encryption method employed in the high availability group cluster and is different from the first encryption method;
disable database mirroring between the old primary database server and the old secondary database server;
configure database mirroring between the old primary database server and the new primary database server using the endpoint while the endpoint is configured to connect with the old primary database server using the first encryption method;
perform mirroring of the database between the old primary database server and a database of the new primary database server while the endpoint is configured to connect to the old primary database server using the first encryption method, wherein the mirroring of the database between the old primary database server and the database of the new primary database server occurs exterior to the high availability group cluster, the new primary database server operates as a non-readable secondary database server while performing the mirroring;
perform a failover operation upon synchronization of the database between the old primary database server and the database of the new primary database server, wherein the failover operation comprises executing migration operations to enable functioning of the database at the new primary database server;
disable the database mirroring between the old primary database server and the new primary database server; and
enable the new primary database server and the database of the new primary database server for operation in the high availability group cluster, wherein the endpoint of the new primary database server is operable for connection with other servers in the high availability group cluster using the second encryption method, wherein the high availability group cluster is capable of concurrently using one or more readable secondary databases.
9. The non-transitory computer readable storage medium of claim 8 , wherein the second encryption method is an Advanced Encryption Standard (AES), and the first encryption method is a Rivest Cipher 4 (RC4).
10. The non-transitory computer readable storage medium of claim 8 , wherein the instructions are further executable to:
configure a new secondary database server for connection with the new primary database server in the high availability group cluster, wherein the new secondary database server and new primary database server are configured for connection using the second encryption method.
11. The non-transitory computer readable storage medium of claim 8 , wherein the instructions are further executable to:
generate a full backup of the database and corresponding database logs from the new primary database server;
restore the full backup of the database and the corresponding database logs on a new secondary database server;
configure a high availability group cluster using the new primary database server and the new secondary database server; and
configure one or more endpoints in the new primary database server to use both the first encryption method and the second encryption method to facilitate the database mirroring and communication with other servers in the high availability group cluster.
12. A system comprising:
a plurality of networked servers, wherein each of the plurality of networked servers includes one or more processors, and a memory coupled to the one or more processors, wherein the memory stores program instructions executable by the one or more processors to:
operate an old primary database server and an old secondary database server in a mirroring configuration to mirror a database from the old primary database server to the old secondary database server, wherein the database on the old secondary database server that is mirrored from the old primary database server is not readable while accessible from the old primary database server, wherein the mirroring configuration employs employing a first encryption method to connect the old primary database server with the old secondary database server;
provide a new primary database server having an endpoint, wherein the endpoint is compatible with the first encryption method and a second encryption method, wherein the new primary database server is configured for inclusion in the high availability group cluster, wherein the second encryption method is an encryption method employed in the high availability group cluster and is different from the first encryption method;
disable database mirroring between an old primary database server and an old secondary database server;
configure database mirroring between the old primary database server and the new primary database server using the endpoint while the endpoint is configured to connect with the old primary database server using the first encryption method;
perform mirroring of the database between the old primary database server and a database of the new primary database server while the endpoint is configured to connect to the old primary database server using the first encryption method, wherein the mirroring of the database between the old primary database server and the database of the new primary database server occurs exterior to the high availability group cluster;
perform a failover operation upon synchronization of the database between the old primary database server and the database of the new primary database server, wherein the failover operation comprises executing migration operations to enable functioning of the database to the new primary database server;
disable the database mirroring between the old primary database server and the new primary database server; and
enable the new primary database server and the database of the new primary database server for operation in the high availability group cluster, wherein the endpoint of the new primary database server is operable for connection with other servers in the high availability group cluster using the second encryption method, wherein the high availability group cluster is capable of concurrently using one or more readable secondary databases.
13. The system of claim 12 , wherein
the second encryption method is an Advanced Encryption Standard (AES), and
the first encryption method is a Rivest Cipher 4 (RC4).
14. The system of claim 12 , wherein the instructions are further executable to:
configure a new secondary database server for connection with the new primary database server in the high availability group cluster, wherein the new secondary database server and new primary database server are configured for connection using the second encryption method.
15. The system of claim 12 , wherein the instructions are further executable to:
generate a full backup of the database and corresponding database logs from the new primary database server;
restore the database and the corresponding database logs on a new secondary database server;
configure a high availability group cluster using the new primary database server and the new secondary database server; and
configure one or more endpoints in the new primary database server to use both the first encryption method and the second encryption method to facilitate the database mirroring and communicate with other servers in the high availability group cluster.