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.
- Go to AWS market place at https://aws.amazon.com/marketplace/
- Log in to your AWS account
- 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
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:
|Custom TCP||TCP||1433||Anywhere||Microsoft SQL Server|
|Custom TCP||TCP||135||Anywhere||Distributed Transaction Coordinator|
When finished click ‘Review and Launch’ 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.