Migrate the SugarCRM to AWS(Amazon Web Service) server (Part I)

To Migrate SugarCRM to AWS server first we have to create an instance of the production/test server and a database server instance on AWS server. So we will see the same step by step.

Create Basic AWS EC2 On-Demand instances :

Login to Amazon console.

Go to All Service -> Compute -> ECS2

MigrateSugarCRMtoAWS_EC2

 

Click Launch Instance.

MigrateSugarCRMtoAWS_launch

 

Choose AMI (Amazon Machine Image):

Here we choose the operating system of the server instance. I choose the Ubuntu Server.

Anyone can choose other option as per the needs.

MigrateSugarCRMtoAWS_AMI

 

Choose Instance Type:

Select the instance type as per requirement. There is the range of types of the instance

which varies in the cost as well as in terms of the performance. Here we are selecting t2 micro.

You can change the instance type in future. 

MigrateSugarCRMtoAWS_instancetype

 

See Charges using AWS Calculator.

Configure Instance:

Here we don’t have to do any changes. Simply move to the next step to add storage.

If any changes are needed, do it carefully.

MigrateSugarCRMtoAWS_configureinstance

 

Add Storage:

Specify the size of storage you need, it will be allocated the respective server instance.
Select the volume typeGeneral Purpose (SSD).

MigrateSugarCRMtoAWS_storage

 

Add Tags:

Here no need to do anything. Simply move to next step.

MigrateSugarCRMtoAWS_tags

 

Configure Security Group

Add Rule for SSH, Mysql, https, HTTP, SMTP, SMTP, etc. Here if you are not sure about the rules

just add All Traffic option from the drop down. Later you can alter the security groups as per the needs.

MigrateSugarCRMtoAWS_securitygroup

 

Review & Launch

Create Server then Generate and save .pem file.

(Keep Backup of .pem file it will be required for logging in to server using WinSCP which we will see in Part II).

MigrateSugarCRMtoAWS_generatepem

 

Go to EC2 -> Instance

Here you can see that new instance is being initialized.

MigrateSugarCRMtoAWS_initializing

 

Add Elastic IP:

Go to EC2 Dashboard -> Elastic IPs -> Allocate New Address

MigrateSugarCRMtoAWS_elasticaddress

We don’t have to do anything click on Allocate button and it will automatically assign an elastic IP.

MigrateSugarCRMtoAWS_allocateaddress

 

Associate Address:

After this, we have to associate the address with elastic IP.

Select the instance and the click on the Associate address in Actions.

MigrateSugarCRMtoAWS_associateaddress1

Select Instance and Private IP then click Associate.

MigrateSugarCRMtoAWS_associateaddress_2

Goto ES2 Dashboard -> Instance

Check the status of the new instance. If it is “running“. Basic AWS EC2 instance is ready to use.

 

Create RDS (Relational Database Server) Instance 

Go to Services -> Database -> RDS

MigrateSugarCRMtoAWS_rds

 

Launch a DB Instance

MigrateSugarCRMtoAWS_instace

 

Select Engine

As we are using the MySQL Database so select the database engine.

Select database engine as per the needs.

Select MySQL -> MySQL Community Edition

MigrateSugarCRMtoAWS_db

 

Do you plan to use this database for production purpose or testing?

Select Production or Dev/Test according to requirement.

Then Press Next.

MigrateSugarCRMtoAWS_dbtype

 

Specify DB Details

Select DB Instance : db.t2.micro

Storage Type: General Purpose (SSD)

Allocated Storage: 15 GB (As per the requirement)

DB Instance Identifier (MySQL server instance name)

Master Username (DB Username eg. root)

Master Password (DB password)

Confirm Password (DB password)

(Note down this password, it will be used in later MySQL configuration.)

MigrateSugarCRMtoAWS_dbsetting

 

Configure Advanced Settings

Database Name: (DB name)

MigrateSugarCRMtoAWS_dbsetting

 

Launch DB Instance. 

Basic RDS instance is ready to use.

Go to RDS -> Instance and you can see that new database instance is being created.

MigrateSugarCRMtoAWS_awsrdsinstance

After the instance is activated, it is ready to use.

dbhostaddress

Above red marked is the database host address which you will need later, to restore the database. 

This is the first part of Migrate SugarCRM to AWS.

Further, we have to install LAMP on the production server which includes Linux, Apache, MySQL, PHP.

We also have to configure Apache.

As well as we have to dump the database of SugarCRM on the new database server.

We will see it in Part II.

If any queries, please contact us here.

PHP and SugarCRM Developer @ Techaroha Solutions Private Limited, always ready to learn and explore new possibilities in technology.
Facebook Comments

6 Comments

Leave a Reply