Azure MySQL PaaS Environment Migration

Steps to create PAAS environment migration.

 

Step 1: PAAS Service will be created by IT Support Team, they will be provided    DB credentials and Azure portal access with DB Team

Step 2: Login with Azure Portal and make sure to go in correct directory and subscription.

Step 3: Choose the respective PAAS Service.

Step 4: choose the Server Parameters option from left side bar.

Step 5: Make the below changes

#server_id=1 (it can be greater than 1)

#innodb_buffer_pool_size=17179869184 (It can be less than 80% of the System RAM)

max_allowed_packet=128M (it can be greater than 128M and less than 1GB)

#log-bin="binlog"  (it can be any path as generated by Azure)

log_bin_trust_function_creators=ON

character_set_server=utf8

#character_set_client=utf8

#character_set_connection=utf8

#character_set_database=utf8

#character_set_results=utf8

collation_server=utf8_general_ci

#collation_connection=utf8_general_ci

#collation_database=utf8_general_ci

connect_timeout=500

#innodb_print_all_deadlocks=ON

long_query_time=5

#max_binlog_size=536870912

max_connections=10000

max_digest_length=10240

slow_query_log=ON

sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

wait_timeout=28800

 

Step 6: Restart the Service

Step 7: Now take the web server RDC for respective client and open the workbench. Server RDC credentials will be provided by Release Team (Ramachandran).

Note: If Workbench not available, please install and go to next step.

Step 8: Connect the new PaaS service with DB credentials.

Step 9: Check the MySQL Parameters values as we changed step 5.

Query: show global variables like 'max_allowed_packet';

Step 10: Once all the values are matched with our configuration. Then proceed with the Db Migration.

Migration:

Step 1: Take the full database structural backup from the Source server.

Step 2: Take the full database data backup from the Source server.

Step 3: Remove the definer from the structural backup and save it.

Step 4: Restore the structural backup in the New PaaS service.

Step 5: Restore the Data backup in the New PaaS service.

Step 6: Verify the object count after migration.

Step 7: Create the necessary users for the new PaaS service.