Wednesday, 28 September 2016

AWS Database migraton gets more fantastic with AWS

AWS Database Migration Service is a web service you can use for migrating data from database. Various scenarios that DMS supports :--
Database that is on-premises, to an Amazon Relational Database Service (Amazon RDS) DB instance
 Database that is on-premises, to a database on an Amazon Elastic Compute Cloud (Amazon EC2)
Migrate a database from an AWS service to an on-premises database.
Supported DB types and versions
Oracle versions 10g, 11g, 12c, for the Enterprise, Standard, Standard One, and Standard Two edition
Microsoft SQL Server versions 2005, 2008, 2008R2, 2012, 2014, and 2016 for the Enterprise, Standard, Workgroup, and Developer editions.
MySQL versions 5.5, 5.6, and 5.7
PostgreSQL versions 9.3 and later
Types of DB migrations
The DB migrations between the same engine type versions.
The DB migrations between the different engine type versions.
                      DMS Components

AWS DMS uses a replication server that connects to the source database, reads the source data, formats the data for consumption by the target database, and loads the data into the target database
At Source DB endpoint DMS collates the data and collects necessary information to convert them in a meaningful way.

At Target DB endpoint DMS migrate all objects to the specified database and schema or create each database and schema for you as it finds the schema on the source

Typically DMS can have 3 types of tasks

Migrate existing data (Full Load)
Take a outage and migrate the complete data from source to target.

Migrate existing data and replicate ongoing changes
This option performs a full data load while capturing changes on the source. Once the
full load is complete, captured changes are applied to the target

Replicate data changes only
In some situations AWS DMS can be used only to replicate changes starting when you
start your bulk load( using any other tool) and keep your source and target databases in

!!Keep experimenting!!

Friday, 22 July 2016

AWS Storage Service called EBS

Hi People!!

Will get more and more information on various AWS services. 

Lets start with Storage, and will cover EBS.
uEBS provides block level storage  for use with Amazon EC2 instances.
uEBS volumes are highly available,reliable and scalable.
uOne can create EBS volumes within range of 1GB to 16 TB.
uEBS volumes behave like raw, unformatted block devices.You can create a file system on top of these
uYou can create point-in-time snapshots of EBS volumes providing long term durability.
uEBS volumes can be used primary storage for data that requires frequent updates, such as the system drive for an instance or storage for a database application.
uEBS volumes support encryption.


Sunday, 1 May 2016

!! AWS !! ...the next big thing

Hi folks,

Thanks you so much for visiting my blog and liking my posts.

I was thinking of writing about AWS for long time but didn't find much time , but enough of wait and excuses it's high time to equip you all with insight on AWS.

AWS (Amazon Web Services) is the leader Cloud service provider and by all means the next big revolution of IT world.

Over the past decade they have established themselves as a partner to the Fortune 500 and when they won the $600MM government contract to build out a datacenter for the CIA they established themselves as a highly trusted partner.
If the CIA trusts them to host their infrastructure, then why wouldn't anyone of the Fortune 500 which are the latest adopters
AWS allows you to do great things as a Solution architect, any requirement of client can be implemented in 5 or more different ways using AWS services thereby giving the clients a leverage to have tailormade solutions created which are scalable,redundant,durable and very cost effective.
Now, I can keep on writing about AWS and glorify it, but I want you all to start tinkering your minds with the word "AWS" and let me know all your queries.
 I recently got AWS certified and I must say the journey with AWS has only begun and its really exciting process of getting certified which definitely gives you the edge and opens you up to AWS world.
Let your queries regarding training and certification flow on
!!Keep Experimenting!!