![]() Select the high-availability state of the service. In this case I'm using the non-production option. When you've made your choice, click the "Next Step" button.Įnter the database details. Once you are happy with the settings click the "Next Step" button.Įnter the advanced settings, making sure the backup and maintenance settings are correct for your service. Open MySQL Workbench, and choose the sign beside MySQL Connections to set up a new connection. Once you are happy with the settings click the "Launch DB Instance" button.Ĭlick the "View Your DB Instances" button to see the status of your service. ![]() In the Setup New Connection dialog box, enter a suitable name for your connection. To connect to your remote MySQL database server using MySQL Workbench, you have to allow remote connections to the server. ![]() ![]() The resulting page shows the status of your services. Once your MySQL server is configured to accept remote connections, you can connect to it using MySQL Workbench. Follow these steps: Launch MySQL Workbench. Click the + symbol in the MySQL Connections tab to add. Once the status is "available", you can connect to the service. If you want to see the monitoring information for the specific service, click the checkbox next to the service and click the "Show Monitoring" button. The following picture shows the monitoring graphs. Open MySQL Workbench and create a new connection using the endpoint information from the "Instances" page and the credentials you used while setting up the service. You will be logged into the console just like any other MySQL instance. To create a new schema, click the new schema button on the toolbar.Įnter the details for the new schema and click the "Apply" button. Review the SQL and click the "Apply" button. The new schema is now listed in the console.Hello Sébastien, I'm sorry to hear that your DB session disconnected. When executing long-running operations (DCLs like OPTIMIZE, DDLs like ALTER, and even large DMLs or selects) the database can go an extended period of time where it does not send/receive anything from the network. ![]() #Mysql workbench redshift installDownload the latest version of MySQL Workbench, and install it on the workstation from which you will be connecting to the Aurora MySQL DB cluster.Do not run long-running operations from your personal computer.To prevent such disconnections from happening, we recommend This can cause the session to hit network-level or DB-level timeouts, which can happen on the client, on a network device (think firewalls for example) in the network path, or on the server. Reduce the network "distance" between the client machine that connects to the database, and the database. From the AWS CloudFormation console, on the BastionStack Outputs tab, note the value for EIP1, as shown in Figure 2. In RDS and Aurora's case we recommend this client be an EC2 machine on the same VPC and AZ as the database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |