Get Started – Configure RDS SQL Server AlwaysOn/Geo-Replication (Multi-AZ/Multi-AR) w/ Readable-Replicas

Get Started - Configure Multi-AZ or Multi-AR (Cross-Region/Geo-Replication) w/ Readable-Replicas

If launching an instance outside of the AWS Marketplace, you will receive an AMI ID and an activation key over email. Locate the AMI ID in the list of Community AMIs and launch as an EC2 server within or outside of your VPC. Once the instance is running, and port 80 opened in the security group, connect to it by pointing a browser to the public DNS root URL (or IP) at default www port 80 (it might take a while for all services to initialize). Activate with the provided activation key. Login with user: admin, initial temporary password: {EC2 Instance ID} (required for security reasons). Upon successful login, you will land on the Quick Setup page, which will allow you to initiate Hybrid/RDS/EC2 SQL Server replication in various scenarios, in just a few clicks. For more information, visit the Prerequisites section of the documentation.

Note: If the VPC does not allow public access, the activation process will switch to manual activation mode, in which case you would open an URL pointing to CloudBasic activation servers on AWS outside of your VPC. You will be asked to copy and paste back an activation code.

You can choose to contact CLOUDBASIC for training and support, have a support representative walk you through the replication process:

 

Welcome screen for "CloudBasic RDS AlwaysOn/Geo-Replicate (Multi-AZ/Multi-AR) for MS SQL Server"
In the Cloudbasic RDS Multi-AR for MS SQL Server/S3/EMR/RedShift product version you will be presented with the following screen instead:

Welcome screen for "CloudBasic RDS Multi-AR for MS SQL Server/S3/EMR/RedShift"
Multi-AR features S3 (RedShift, EMR Hadoop) data feeds. It allows to continuously feed data from RDS/EC2 SQL Server or from On-Premise to S3 (SCD Types 1-3) from where data can be loaded into RedShift or EMR/Hadoop for BI/Reporting/DWH with i.e. Tibco SpotFire/JaperSoft or Tableau. Note: S3-to-RedShift data loading is not available for self-service in this version. Contact CloudBasic for managed Redshift DWH options.

If you choose to continue on your own, follow the instructions below. You will be presented with three options:

Option 1. Continuous replication w/ automatic seeding and change tracking activation

Replicate entire MS SQL Server or a single database w/ automatic seeding (no backup/restore required; destination/read-replica databases are created automatically). Upon successful completion of the seeding, a change tracking schedule (under Replication Schedules) will be configured automatically.

This option is suitable for replicating smaller size databases. It can be utilized to replicate large size databases if MS SQL Server backup/restore is not available.

All RDS and EC2 SQL Server version 2008 and above, and including Web Edition are supported.

Replication scenarios include but are not limited to continuous replication of:

  • On-Premise, RDS or EC2 SQL Server to the pre-installed (contact support for other MS SQL Server edition options) on this server. The Read-Replicas created locally on this server can be used for Reporting or DR.
  • On-Premise, RDS or EC2 SQL Server to one or multiple RDS or EC2 SQL Server instances for Reporting or DR.
  • RDS to one or multiple RDS Multi-AZ Readable-Replica instances for HA and/or to offload primary
  • RDS to one or multiple RDS Cross-Region (Multi-AR) Readable-Replica instances located in same or multiple regions for DR and/or Data-Locality.

Learn more about supported Use Cases.

Option 2. Continuous replication w/ semi-automatic seeding (backup/restore) and change tracking activation

Replicate a single database w/ semi-automatic seeding. Manual database backup and restore on the replica MS SQL Server is required, before change tracking can be activated.

This option is suitable for replicating large size databases or migrations without downtime. Very large backup files can be delivered to AWS utilizing AWS Snowball.

Learn more about supported Use Cases.

Option 3. One-time replication w/ automatic seeding without change tracking activation

One-time replication of all MS SQL Server databases or a single database without change tracking activation (cannot be activated at a later time). Destination replica database(s) are created automatically.

For information regarding integrating this process into DevOps DLM tools, see API Documentation.

On the next screen, you would only need to enter the source and destination connection details.

If your destination MS SQL Server is RDS, we recommend that the root RDS account provided by AWS to not be used for replication. You can create a new user to be used for replication, and also another read-only user to be created under the replication user, to be used for read-only access to the destination RDS SQL Server.

Click here to obtain the recommended scripts to be used to create the above mentioned users.

Enter the source and destination connection details (Basic settings)
Depending on your use case, you may need to switch to the advanced connections configuration screen, where you can select:

  • To encrypt the MS SQL Server connections.
  • Select to not replicate the compatibility level of the source database.
  • Enter a custom destination database creation script.
  • Enter a post-initial replication SQL script.

Advanced connections configuration
Upon successful initiation of the replication process, you will be redirected to the Runtime logs page, where you should see the your initial replication process running along with other seeding and continuous replications processes.

Runtime logs
Clicking on "Tabular" will take you to a page where you can monitor the table seeding progress.

Table seeding progress

Clicking on "Runtime" in the list of running replication processed will take you to a detailed runtime logs console windows, where you can monitor (or see complete detailed about the seeding process upon completion) detailed runtime logs information about the seeding process.

Detailed runtime logs console windows

If the replication process finishes successfully, the status will change from "Running"  to "Success".

if during the seeding process non-critical errors occur, the status will change from "Running" to "RunningWithErrors" or  "RunningWithWarnings". In this case the seeding process will finish with status "CompletedWithErrors" or "CompletedWithWarnings" respectively.

Possible non-critical errors are i.e. failure to create a stored procedure or a view due to non-existing referenced table.

If a critical error occurs, the process will end with status "Failed". You would need to review the logs for detailed error description or contact support. You have the option to [Email Logs to Support] with a single click (after configuring SMTP).

If your replication was initiated under the default replication option ("Replicate entire database and schedule continuous data replication /structure and data plus scheduled CDC/"), and it completes successfully (completion statuses "Success", "CompletedWithWarnings", "CompletedWithErrors"), a schedule to execute replication processes will be created under [AdvancedSchedules] with the default parameters for the server instance type (Compare Instance Types).

.

.

.