MySQL

Manage instance

Create an instance

1. You can create an instance on the MySQL page: click the blue string create an instance or you can also click the + button on the upright corner and it will turn to the purchasing page, as shown below:
   

2. On the purchasing page, you can adjust the Location, Version, Series, Storage Type, Product, Storage Space, Quantity and the Duration as you need, then click Buy Now to turn to the order page, as you can see below:
   

3. On the order page, please confirm the Order details and you can choose to pay by Balance or with PayPal, as shown below:
   

Note: If you need to pay with your balance, please keep your account balance sufficient.

Manage instance

On MySQL page, select the instance to be managed, click Manage in the Actions colomn and then you can view and manage the Basic Information, Accounts, Databases, Backup & Restoration, Monitoring, Logs, and the Parameters sections, as shown below:

Rename instance

1. On Basic Information page, you can view the Basic Information, Connection Information, Running State, Configuration Information and the Usage Statistics of the instance. You can rename your instance in the Basic Information part by clicking the blue icon beside the name, as shown below:
   

2. In the pop-out window, enter a new name in the textarea as you need, then click Done to complete, as shown below:
   

Apply for public endpoint

1. On Basic Information page, click Apply for Public Endpoint in the Connection Information part, as shown below:
   

2. In the pop-out window, read the note and click Confirm to complete, as shown below:
   

Edit extranet address

1. After applying for public endpoint successfully, a public IP address will be given below, and you can click the blue writing icon next to the blue string to edit the extranet address as you need, as shown below:
   

2. In the Edit Extranet Address window that pops out, edit the name in the textarea as requested below, then click Done to complete, as shwon below:
   

Release extranet address

1. After applying for public endpoint successfully, you can release it anytime as you want. Click the blue ashcan icon after the blue string, as shown below:
   

2. In the pop-out window, read the note and click Release to complete, as shown below:
   

Edit extranet whitelist

1. After applying for public endpoint successfully, you can edit the extranet whitelist as you need. Click Edit Extranet Whitelist, as shown below:
   

2. In the pop-out window, add the IPs to be allowed to access the extranal network address into the textarea as you need. Read the note below and click Done to complete, as shown below:
   

Upgrade bandwidth

1. After applying for public endpoint successfully, you can increase the bandwidth from 5M to 10M for 24 hours as you need. Click the blue upward arrow next to the maximum bandwidth of extranet, as shown below:
   

2. In the pop-out window, confirm the information and read the note, then click Speed Up to complete, as shown below:
   

Edit maintainable period

1. You can edit the maintainable period in the Configuration Information part on the Basic Information page. Click the blue writing icon next to the maintainable period, as shown below:
   

2. In the pop-out window, set the maintenance period as you need in the textarea then click Done to complete, as shown below:
   

Create account

1. You can create an account on the Accounts page: click Create Account to start, as shown below:
   

2. In the pop-out window, enter a database account, choose the privilege type, enter a new password, confirm the new password and you can also remark the description for the account in the corresponding textarea. Then click Done to complete, as shown below:
   

Edit description

1. After creating an account successfully, you can edit the description on the Accounts page: click Edit Desc to start, as shown below:
   

2. In the pop-out window, enter the description as you need in the textarea, and click Done to complete, as shown below:
   

Reset password

1. On the Accounts page, click ... in the Actions column and then click Reset Password to start resetting, as shown below:
   

2. In the pop-out window, enter a new password and confirm it in the corresponding textarea, then click Done to complete, as shown below:
   

Delete account

1. On the Accounts page, click ... in the Actions column and then click Delete, as shown below:
   

2. In the pop-out window, read the note, then click Done to complete, as shown below:
   

Create database

1. You can create databases on the Databases page: click Create Database to start, as shown below:
   

2. In the pop-out window, set the database name and choose the character set. If needed, authorize an account if you have already had one; or you can also create one as you need by clicking the + Create an Account. You can also edit description as you need in the corresponding textarea. Then click Done to complete, as shown below:
   

Edit description of database

1. After creating a database successfully, you can edit the description on the Databases page: click Edit Desc to start, as shown below:
   

2. In the pop-out window, enter the remarks as you need in the textarea, and click Done to complete, as shown below:
   

Delete database

1. On the Databases page, click Delete in the Actions column, as shown below:
   

2. In the pop-out window, read the note, then click Done to complete, as shown below:
   

Back up instance

1. On the Manage page in MySQL, click Back Up on the right side of the page to start to back up the instance, as shown below:
   

2. In the pop-out window, choose a backup mode as you need then click Back Up to complete, as shown below:
   

Restart instance

1. On the Manage page in MySQL, click Restart on the right side of the page, as shown below:
   

2. In the pop-out window, confirm the information and then click Restart to complete, as shown below:
   

Backup & restoration

Restore indivdual database/table

1. Click Database/Table Level Recovery on the Backup & Restoration page, as shown below:
   

2. In the pop-out window, set the restoration method; select the backup set, database and tables to be restored, and read the note. Then click Done to complete, as shown below:
   

Download instance backup file

1. On the the Backup & Restoration page, click Data Backup and select the one you need to download, then click Download, as shown in below:
   

2. In the pop-out window, read the note and click Download to complete, as shown below:
   

Convert file to SQL

1. On the the Backup & Restoration page, click Data Backup and select the one you need to convert, then click Convert to SQL, as shown in below:
   

2. In the pop-out window, read the note and click Convert to complete, as shown below:
   

Configure backup settings

1. On the the Backup & Restoration page, click Backup Settings and here you can view the information of the data backup retention, backup cycle and the approximate time of next backup. Click Configure to adjust the backup settings, as shown below:
   

2. In the pop-out window, you can adjust the the data backup retention, backup cycle and the backup time as you need, then read the note and click Done to complete, as shown below:
   

Monitoring

Resource monitoring

• On the Monitoring page, click Resource Monitoring and you can view the condition of the CPU and Memory Utilization, Disk Space, IOPS, Current Total Number of Connections and the Network Traffic, as shown below:
  

Engine monitoring

• On the Monitoring page, click Engine Monitoring and you can view the condition of

  • Transactions Per Second/ Queries Per Second
  • InnoDB Buffer Pool Read Hit Ratio, Utilization Rate, Dirty Block Rate
  • InnoDB Read/Write Volume
  • InnoDB Buffer Pool Read/Write Frequency
  • InnoDB Log Read/Write/fsync
  • Temporary Tables Automatically Created on Hard Disk when MySQL Statements Are Executed
  • MySQL_COMDML
  • MySQL_RowDML
  • MyISAM Read/Write Frequency
  • MyISAM Key Buffer Read/Write/Usage Ratio

  

Set monitoring frequency

1. You can click Set Monitoring Frequency to set the monitoring frequency on the Monitoring page, as shown below:
   

2. In the pop-out window, adjust the monitoring frequency as you need, then click Done to complete, as shown below:
   

Logs

Slow log details

• On the Logs page, click Slow Log Details and you can view the details of the slow log of the instance, as shown below:
  

Set slow query

1. On the Logs page, click Slow Log Details and then click Slow Query Setting to start, as shown below:
   

2. In the pop-out window, adjust the slow query time and the slow query switch as you need, then click Done to complete. as shown below:
   

Slow log summary

• On the Logs page, click Slow Log Summary and you can view the summary of the slow log of the instance, as shown below:
  

Parameters

Edit setting of parameters

1. On Parameters page, click Edit on the Action column, as shown below:
   

2. In the pop-out window, confirm the information and select the value as you need,then click Done to complete, as shown below: