Alauda Database Service for MySQL-PXC

Parameter Configuration

Configuring appropriate MySQL parameters based on business scenarios can help the database achieve optimal performance and better support business operations. By default, MySQL-PXC instances use system parameters provided by MySQL and Percona. You can also conveniently configure these parameters through the interface.

The platform provides parameter templates to define a series of MySQL parameters that you expect. When creating an instance, you can batch modify the default parameters using the parameter template, while parameters not covered in the template will retain their default values. After the instance is running normally, you can update MySQL parameters.

For more parameter information, please refer to the MySQL Official Website and Percona Official Website .

TOC

Note

Modifying parameter configurations will restart the Pods one by one, potentially causing a brief interruption to the business.

Procedure

CLI
Web Console
kubectl patch mysql -n <namespace> <name> --type='merge' --patch '
spec:
  params:
    mysql:
      mysqld:
        max_connections: "1000"
        expire_logs_days: "7"
'

You can modify parameters by changing the spec.params.mysql in the CR, with the corresponding parameter keys matching the MySQL parameters. As shown above, set max_connections to 1000 and expire_logs_days to 7.

ON THIS PAGE