"DbiResourceId": "db-BXQWHEI54YFTFUODG32WYLOWDB", The following command example replace the MySQL default port number (3306) with a non-default one, i.e. In order to avoid any downtime in production, skip adding the -apply-immediately command parameter and the RDS service will apply the port number change during the next maintenance window. (!) IMPORTANT: the following example is using the Apply Immediately option to apply the change asynchronously and trigger an immediate outage. The valid port numbers that can be used are between 115 for MySQL/MariaDB/Aurora/PostgreSQL/Oracle and between 115 except for 1434, 3389, 47001, 49152, and 49152-49156 for the SQL Server. "DBSnapshotIdentifier": "mysql-prod-db-snapshot",Ġ3 Run modify-db-instance command (OSX/Linux/UNIX) to modify the selected RDS instance configuration in order to change the default port number to a custom one. "LicenseModel": "general-public-license", 4 – 12 for each RDS database instance that runs on the default port number, available in the current region.ġ4 Change the AWS region from the navigation bar and repeat the process for other regions. During the modification process the instance status should change from available to modifying and back to available (it may take few minutes depending on the instance configuration).ġ2 Once the database configuration is successfully updated, you can change the endpoint port number at your application level to match the non-default port set at step no. If Apply Immediately is not selected, the database port number change will be processed during the next maintenance window.ġ0 Click the Continue button to continue the process.ġ1 Review the database port changes and click Modify DB Instance to apply the changes. If the selected database instance is used in production consider leaving Apply Immediately option disabled before applying the changes in order to avoid any downtime. (!) IMPORTANT: when you modify the database instance port number, an immediate outage will occur if a custom parameter group is used. At the bottom of the page select Apply Immediately checkbox to apply the endpoint port number change immediately. The valid port numbers that can be used are 1150 to 65535 for MySQL/MariaDB/Aurora/PostgreSQL/Oracle and 1150 to 65535 except for 1434, 3389, 47001, 49152, and 49152-49156 for SQL Server. In the Database Port box, replace the database default port number with your custom port number.03 In the navigation panel, under RDS Dashboard, click Instances.Ġ4 Select the RDS database instance that you want to reconfigure (see Audit section part I to identify the right resource).Ġ5 Click Instance Actions button from the dashboard top menu and select Take Snapshot to create a database snapshot (backup).Ġ6 On the Take DB Snapshot page, in the Snapshot Name box, enter a unique name for the database backup then click Take Snapshot to send the request.Ġ7 Go back to the Instances page and select again the RDS instance that you want to modify.Ġ8 Click Instance Actions button from the dashboard top menu and select Modify.Ġ9 On the Modify DB Instance: page, perform the following actions:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |