To add more storage, the process is very similar - once you click on Yes, the service will become temporary unavailable (you might want to do this during the green zone in case this is a production database):Ĭonnecting to the MySQL Database - SSH Access To scale up and down, we can select the option Scale Up/Down option and select the new requirenments:
In this example, we have one application using this database (that we will learn how to do this link in the next article).Īnd if we need to, we can also scale up and down and add storage to the database:
On the bottom, we can also see all other services that are linked or using this database. On the top right corner we can start, stop, restart the service and also display monitoring information.
Once the service has been created, we can click on it and we can see its overview: You will receive an email once the service is ready to be used:Įxploring the Oracle MySQL Cloud Service instance It might take up to 20-30 minutes to be created. On the Oracle MySQL Cloud Service console page we will see that the service is being created: Once completed, click on Next, review and confirm the details by clicking on Create. The wizard will automatically populate the SSH details.
Don’t forget to download the sshkeybundle.zip file that contains the private and public keys. If you already have an SSH Public Key, you can enter its details, otherwise, click on the Edit button and select Create a New Key and click on Enter. You will also need to configure an SSH Public Key, that can be used to login to the VM instance on which MySQL Cloud service instance is running.
Next, enter the details of the database (default values are already populated), such as how much compute power it is required, database administrator username and password, backup configuration (select none if you are creating an instance for testing purposes only):Ī full explanation of all fields are available in the documentation as well. You can also create tags to easily identify the database later: If you don’t have any instances created yet, click on Create Instance button:Įnter the instance name and choose the compute region. The link looks like: Ĭlick on the menu icon -> Services.
Developers and DBAs can quickly and easily convert existing applications to run on MySQL both on Windows and other platforms. MySQL Workbench now provides a complete, easy to use solution for migrating Microsoft SQL Server, Microsoft Access, Sybase ASE, PostreSQL, and other RDBMS tables, objects and data to MySQL. Plus, with 1 click, developers can see where to optimize their query with the improved and easy to use Visual Explain Plan. Performance Reports provide easy identification and access to IO hotspots, high cost SQL statements, and more. DBAs can quickly view key performance indicators using the Performance Dashboard. MySQL Workbench provides a suite of tools to improve the performance of MySQL applications. Learn more » Visual Performance Dashboard Developers and DBAs can use the visual tools for configuring servers, administering users, performing backup and recovery, inspecting audit data, and viewing database health. MySQL Workbench provides a visual console to easily administer MySQL environments and gain better visibility into databases. The Object Browser provides instant access to database schema and objects. The Database Connections Panel enables developers to easily manage standard database connections, including MySQL Fabric.
The SQL Editor provides color syntax highlighting, auto-complete, reuse of SQL snippets, and execution history of SQL. MySQL Workbench delivers visual tools for creating, executing, and optimizing SQL queries. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort. MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases.