PartitionDB Hybrid Solution Installation – Cloud Side on Amazon EC2

This article is a step by step guide explaining how to setup a machine in the AWS for the purpose of running PartitionDB hybrid service.

For general information about deployment planning in AWS please refer to Amazon EC2 Capacity Planning.

1. Find PartitionDB AMI in the market place

PartitionDB AMI contains SQL 2016 Express Edition and PartitionDB hybrid service already installed.  For other products from PartitionDB please check Amazon market place.

  • In the search line write “PartitionDB” and click search.

  • Click ‘PartitionDB hybrid solution for SQL-DB’ AMI on view the PartitionDB product page.

  • Click ‘Continue’ button. This will take you Launch on EC2 page.

  • Click ‘Manual Launch’ tab. Then click “Launch with EC2 console” to select a region you want to use (US regions are recommended).

2. Choose an instance type

The instance type that fits best to your needs depends on your database storage requirements. To start with, you can select the free tier of t2.micro. For best performance we recommend using any i2, d2, m4 or r3 instances.

Continue by clicking ‘Next: Configure Instance Details’ button

3. Configure Instance Details

PartitionDB Hybrid service requires the cloud instance to be opened so the on premise instance will be able to push, stream and load data to it.

Make sure to set the ‘Auto-assign Public IP’ to enable.

To continue click ‘Next: Add Storage’ button.

4. Add Storage

Set your storage size to at least 50 GB. Additional storage can be added at later time.

Click ‘Next: Add Tags’ button to continue.

5. Add Tags

Tags are optional.

Click ‘Next: Configure Security Group’ button to continue.

6. Configure Security Group

PartitionDB service requires opening two ports: 1433 and 135. The ports definition is included in the AMI. However, if you have your instance already set up (not from PartitionDB AMI) you will have to go through this step.

Click ‘Add Rule’ button for each of the ports:

The following table contains the settings to be filled out for the rules, refer also to the screenshot below:

Type Protocol Port Source Description
Custom TCP TCP 1433 Anywhere Microsoft SQL Server
Custom TCP TCP 135 Anywhere Distributed Transaction Coordinator

When finished click ‘Review and Launch’ button.

7. Review Instance Launch

The below screen lists the attributes of the instance that is created:

Review and click ‘Launch’ button:

8. Key Pair

Create a key pair to securely access your instance. If you already have a key pair, you can choose to use it.

Give the new key a name and download it by clicking on ‘Download Key Pair’ button. A .pem file will be downloaded to your machine.

When finished press ‘Launch Instances’ button.

9. Launch Status

Review the launch status. Continue by clicking ‘View Instances’.

10. Instances

Here you can see the list of your instances. The new instance will be in ‘Initializing’ status at first (in the ‘status check’ field). Once initialization is completed the status check becomes ‘2/2 checks passed’.

 

Select the instance and click ‘Connect’ button.

11. Connect To Your Instance

To connect to your instance click on ‘Get Password’ button. You will have to choose your .pem file that you have downloaded before.

Click on ‘Decrypt Password’ button to get your password.

Click on ‘Download Remote Desktop File’ button and login to your instance using your password that was generated for you.

12. What’s next

Using PartitonDB AMI a Microsoft SQL Server 2016 Express Edition is now installed on your instance including Microsoft SQL Server Management Studio. PartitionDB required setup is currently installed as well.

To continue to log in to your SQL server, please refer to Connect to SQL Sever document.