Upgrade JCS for MySQL Version

Here is the description on how to upgrade the JCS for MySQL version to a higher version JCS for MySQL. Take the upgrade of JCS for MySQL 5.7 to MySQL 8.0 for example as below.

Precautions

Please ensure the installation of the MySQL 8.0 client.
The new Virtual Machines need to be in a same VPC as the MySQL 5.7 instance.
The new MySQL 8.0 instance needs to be in a same VPC as the MySQL 5.7 instance.
It shall ensure that the capacity space of the new MySQL 8.0 instance is not less than that of the original MySQL 5.7 instance.

Operation Steps

Create VM instance, and for specific creation steps, see Create VM instance, when creating VM instance, the following points need to be noted
- Please ensure that the Virtual Machines are in a same VPC as the JCS for MySQL 5.7 instance requiring version upgrade.
- New Virtual Machines need an EIP to enable public network access, otherwise it cannot remotely log in the Virtual Machines.
- Please ensure that network ACL of subnet that the Virtual Machines are located at allows local ssh to connect to Virtual Machines.
After VM instance creation, remotely log in the Virtual Machines to install the client of MySQL 8.0. For client installation document, see Download Link, for client, see Installation Tutorial
After installing client, begin to export the data from JCS for MySQL 5.7 to local Virtual Machines and execute the command
复制成功
```
 mysqldump -u User name -p Password -R -E --skip-tz-utc --opt --skip-add-drop-table --single-transaction --hex-blob --default-character-set=binary --master-data=2 -B Database name > /Path/Export file name.sql
 
```
Parameter description
User name: User name of Cloud Database
Password: Password of Cloud Database
Database name: Fill in database names to be outputted and separate several database names with spaces
JCS for MySQL 8.0 will start to be created after exporting the data of JCS for MySQL 5.7. For specific steps for creation, please refer to Create JCS for MySQL instance.
Create the database through the console. It shall ensure that the name of JCS for MySQL 5.7 to be exported has been created in JCS for MySQL 8.0 as well. For specific steps for creation, please refer to Create Database.
Create a database account through the console, and then give the account ** read-write** permissions to the database created in step 5. For specific steps, please refer to Create accounts.
Import the data that is exported in Step 3 to the new JCS for MySQL 8.0 and execute the command
复制成功
```
 mysql -u User name -p Password -h Cloud database domain --default-character-set=binary < /Path/Export file name.sql
 
```
Parameter description
User name: User name in actions of step 6.
Password: Corresponding password of the user in actions of step 6
Database domain: Please view domain of JCS for MySQL 8.0 in the Details of instance.
If there is no error notification, it means the import is successful. You can log in JCS for MySQL 8.0 to view whether the data has been actually imported.

Upgrade Database MySQL Version

Products

开始与售前顾问沟通

可直接拨打电话 400-098-8505转1