High Level Oracle Database Migration Plan – Datapump

 Pre-Migration Phase: No Downtime

• Review the Source database configuration
• Build target environment in AWS Cloud
• Prepare target database 

 Migration Phase (cutover) : Downtime

• Source database backup 
• Transfer the backup to target
• Import backup in target database
• Validate the migrated database

 

Post-Migration Phase : Downtime

• Handover database to application team
• Application team start validation
• Decide Go-Live /No Go-Live
• Target database golden backup
• Release database and application

 

Note : Normally good for small database 

High Level Maria DB Migration Plan

Pre-migration Phase (No -downtime)

• Validate source and target database versions and engines.
• Identify hardware requirements for the target server instance.
• Identify storage requirements (storage type and capacity).
• Choose the proper instance type based on capacity, storage features, and network features.
• Identify the network access security requirements (firewall, port etc. ) for source and target databases.
• Prepare target database
• Configure and start an Amazon RDS DB instance running MariaDB.

 

Migration Phase (downtime)

• Using native tools to migrate database objects and data.
• In the source database, use mysqldump or mariadb-dump to create an output file that contains database objects and data.
• Transfer the backup to target (AWS RDS)
• In the target database, use mysql or mariadb to restore the data.
• Validate the migrated database.

 Post-migration Phase (downtime)

• Handover database to application team
• Switch the application clients over to the new migration database in AWS RDS .
• Application team start validation
• Decide Go-Live /No Go-Live
• Target database golden backup
• Release database and application

Rollback Plan 

• Start source database (Assume no data chnage on target database  after migration)
• Connect & validate Application with source database 

What Is a RACI Matrix ?

What Is a RACI Matrix ?

RACI matirix is very important when we are working on project  and this helps to align  who is reposible for what .

Like who will take decision , who will resposible for technical task , what resposiblity of cutomer and what information needs to share with custmers etc . 

R  => (Responsible)  : This member is resposible to taks done ---- like create infrastructure goes to infra team - Person1 ,Person2

A  => (Accountable) : This member is taking decision and ensure everythig is aligned and meet all standards ----which tool going to use for database assessment goes to db team -  Person2,Person1

C  => (Consulted) : Share the outcome and should be meet all criteria with input & feedback to improve the business process  - Person 3

I  = > (Informed) : Any other team ,team memebers, stakeholder who needs to informed about project status,progress ,blockers  etc -  Person 4 , Person 5

How to check what port MariaDB is running on ?

 check what port MariaDB is running on 

Option : 1- Login in database 

[root@10.1.1.1]#

[root@10.1.1.1]# mysql

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 11

Server version: 10.3.35-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'PORT';

+---------------+-------+

| Variable_name | Value |

+---------------+-------+

| port          | 3306  |

+---------------+-------+

1 row in set (0.001 sec)

MariaDB [(none)]>

MariaDB [(none)]> status

--------------

mysql  Ver 15.1 Distrib 10.3.35-MariaDB, for Linux (x86_64) using readline 5.1

Connection id:          11

Current database:

Current user:           root@localhost

SSL:                    Not in use

Current pager:          stdout

Using outfile:          ''

Using delimiter:        ;

Server:                 MariaDB

Server version:         10.3.35-MariaDB MariaDB Server

Protocol version:       10

Connection:             Localhost via UNIX socket

Server characterset:    latin1

Db     characterset:    latin1

Client characterset:    utf8

Conn.  characterset:    utf8

UNIX socket:            /var/lib/mysql/mysql.sock

Uptime:                 35 min 22 sec

Threads: 6  Questions: 15  Slow queries: 0  Opens: 18  Flush tables: 1  Open tables: 11  Queries per second avg: 0.007

--------------

MariaDB [(none)]>

Option :2 - host level command

[root@10.1.1.1]# netstat -tlpn | grep mysql

tcp6       0      0 :::3306                 :::*                    LISTEN      22163/mysqld

[root@10.1.1.1]#