Change configuration options

You can manage instance groups in KakaoCloud MySQL using the default stored procedures provided.

caution

All parameters except read_only cannot be modified using this procedure.

Change configuration options

This stored procedure allows modification of parameters on a running MySQL instance.

Procedure name

mysql.mnms_set_configuration

Procedure parameters

Name	Data type	Description
p_name	varchar(200)	Name of the parameter to modify.
p_value	varchar(200)	New value to apply to the parameter.

How to use

CALL mysql.mnms_set_configuration('read_only', 1);

Example

1. Example of applying global and session-level change

2. Check after reconnecting to session

   caution

   Parameters listed as [Non-modifiable parameters] cannot be changed using this procedure.