Enabling KOVAE

After KOVAE is installed, you need to enable KOVAE in the database and ensure that the SQL statements related to the target tables are executed in KOVAE. This section uses the test table t1 as an example.

Procedure

Log in to the MySQL service through the MySQL client. For example:
```
mysql -uroot -p -S /data/mysql/run/mysql.sock
```
Change the path of the /data/mysql/run/mysql.sock file based on actual requirements.
Run the following statement on the MySQL client to set the secondary engine of the target table to kovae. Each table needs to be configured only once. Reconfiguration is not required after the MySQL service is restarted. t1 indicates the name of the target table. Change it based on actual requirements.
```
ALTER TABLE t1 SECONDARY_ENGINE = kovae;
```
If the following information is displayed, the operation is successful:
```
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0
```

Check the secondary engine settings of the table. t1 indicates the name of the target table. Change it based on actual requirements.

show create table t1;

If SECONDARY_ENGINE=kovae is displayed in the target table creation information, the operation is successful:

+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table
              |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t1    | CREATE TABLE `t1` (
  `a` int DEFAULT NULL,
  `b` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci SECONDARY_ENGINE=kovae |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Load the target table to KOVAE, so that the SQL statements related to the target table can be executed in KOVAE. t1 indicates the name of the target table. Change it based on actual requirements.
Each table needs to be configured only once. The target table needs to be loaded to KOVAE again after the MySQL service is restarted.
```
ALTER TABLE t1 SECONDARY_LOAD;
```
If the following information is displayed, the operation is successful:
```
Query OK, 0 rows affected (0.00 sec)
```

Parent topic: KOVAE Deployment