Step 1: Provision an Empty Aurora Database

You first need to start up a new instance of Aurora, using the desired instance type and other custom settings as explained in Deploy the Controller on AWS. Ensure that the database instance is created using port 3388.

Step 2: Use mysqldump to Export from MySQL

To use mysqldump, run the mysqldump executable, passing the root username, password, and output file:

1. Run the following command to navigate to the executable directory:

   cd <controller_home>/db/bin

2. Use the following command to export the database from MySQL:

   ./mysqldump -u root --databases controller licensing mds_auth mds_configuration mds_entitysearch mds_infra_core mds_infra_server mds_license mds_metadata mds_metering mds_rbac mds_topology --single-transaction --compress --order-by-primary -p "<password>" > backup.sql

3. In order to import the resulting file into Aurora, you need to replace the following line:

   /*!50013 DEFINER=`controller`@`localhost` SQL SECURITY DEFINER */

   With:

   /*!50013 DEFINER=`controller`@`%` SQL SECURITY DEFINER */

Step 3: Use mysqldump to export stored procedures from the Splunk AppDynamics database

Run the following command to export the stored procedures from the Splunk AppDynamics database.

./mysqldump -u root -p --protocol=TCP -h 127.0.0.1 -P <controller_mysql_port> --no-create-db --skip-add-drop-table --no-create-info --skip-disable-keys mysql proc --result-file=/staging/path/for/mysql.proc.sql

This command, through the --result-file option, dumps the stored procedures to /staging/path/for/mysql.proc.sql.

Step 4: Use mysql to Import to Aurora

1. Run the following command to navigate to the executable directory:

   cd <controller_home>/db/bin

2. Connect to the new Aurora instance:

   ./mysql -u root -p"<password>" -h <hostname>.<aws-region>.rds.amazonaws.com -P 3388 --protocol=TCP

3. Then create the Controller user, and grant it permissions:

   CREATE USER 'controller'@'%' IDENTIFIED BY 'controller';
   GRANT USAGE ON *.* TO 'controller'@'%';
   GRANT ALL PRIVILEGES ON `controller`.* TO 'controller'@'%';
   GRANT ALL PRIVILEGES ON `licensing`.* TO 'controller'@'%';
   GRANT ALL PRIVILEGES ON `mds_auth`.* TO 'controller'@'%';
   GRANT ALL PRIVILEGES ON `mds_configuration`.* TO 'controller'@'%';
   GRANT ALL PRIVILEGES ON `mds_entitysearch`.* TO 'controller'@'%';
   GRANT ALL PRIVILEGES ON `mds_infra_core`.* TO 'controller'@'%';
   GRANT ALL PRIVILEGES ON `mds_infra_server`.* TO 'controller'@'%';
   GRANT ALL PRIVILEGES ON `mds_license`.* TO 'controller'@'%';
   GRANT ALL PRIVILEGES ON `mds_metadata`.* TO 'controller'@'%';
   GRANT ALL PRIVILEGES ON `mds_metering`.* TO 'controller'@'%';
   GRANT ALL PRIVILEGES ON `mds_rbac`.* TO 'controller'@'%';
   GRANT ALL PRIVILEGES ON `mds_topology`.* TO 'controller'@'%';
   FLUSH PRIVILEGES;

   Note:

   Note

   The Aurora database is protected by security groups to prevent access from unauthorized sources.

4. Import the database backup:

   ./mysql -u controller -P 3388 -H <hostname>.<aws-region>.rds.amazonaws.com -p "controller" --protocol=TCP < backup.sql

5. Import the stored procedures:

   Warning: The import must be made by an admin or root user.

   ./mysql -u admin -P 3388 -H <hostname>.<aws-region>.rds.amazonaws.com -p "controller" --protocol=TCP < /staging/path/for/mysql.proc.sql

Step 5: Configure the Controller to Use the Aurora Database

1. In Controller, configure the jetty/etc/webapp-common.xml file with the Aurora DB parameters.

   <Call name="setProperty">
   <Arg>database.url</Arg>
   <Arg>jdbc:mysql://[aurora-db].[aws-region].rds.amazonaws.com:3388/controller?nullNamePatternMatchesAll=true&allowLoadLocalInfile=true&cachePrepStmts=true&prepStmtCacheSize=25&dumpQueriesOnException=true&rewriteBatchedStatements=true&useSSL=false&maxAllowedPacket=104857600</Arg>
   </Call>
   <Call name="setProperty">
   <Arg>database.servername</Arg>
   <Arg>[aurora-db].[aws-region].rds.amazonaws.com</Arg>
   </Call>
   <Call name="setProperty">
   <Arg>database.port</Arg>
   <Arg>[aurora-db-port]</Arg>
   </Call>

2. In the file <controller_home>/bin/controller_maintenance.xml, set the property db-host to the value of your Aurora database:

   <property name="db-host" value="<aurora-db>.<aws-region>.rds.amazonaws.com"/>
   <property name="db-port" value="[aurora-db-port]"/>

3. In the file <controller_home>/bin/setup.xml, set the property db-host to the value of your Aurora database:

   <property name="db-host"value="<aurora-db>.<aws-region>.rds.amazonaws.com"/>
   <property name="db-port" value="[aurora-db-port]"/>

4. With the Controller service installed, start the Controller with root:

   platform-admin.sh start-controller-appserver

5. Verify that the Controller is running successfully. The local MySQL database should be shut down, and you should see the migrated data in Aurora, which can be verified via the Controller UI.