How to Change Amazon RDS MariaDB Parameters Easily

Leave a reply

Changing the parameters of an Amazon RDS instance running MariaDB involves modifying the DB parameter group associated with your RDS instance. Here are the steps to achieve this:

Steps to Modify MariaDB Parameters on AWS

  1. Identify the Parameter Group
    • Each RDS instance uses a DB parameter group to configure the database settings. Identify the parameter group associated with your RDS instance.
  2. Modify the Parameter Group
    • Modify the necessary parameters in the parameter group. This can be done through the AWS Management Console, AWS CLI, or AWS SDKs.
  3. Apply the Changes
    • Some parameter changes take effect immediately, while others require a reboot of the RDS instance.

Detailed Steps

Using AWS Management Console

  1. Sign in to the AWS Management Console
  2. Select the Parameter Groups
    • In the navigation pane, choose Parameter groups.
  3. Choose the Parameter Group
    • Select the parameter group associated with your MariaDB instance. If your instance is using the default parameter group, you will need to create a new custom parameter group as the default one cannot be modified.
  4. Create a New Parameter Group (if needed)
    • Choose Create parameter group.
    • Select the parameter group family that matches your MariaDB version.
    • Enter a name and description for your new parameter group, then choose Create.
  5. Modify Parameters
    • Select your custom parameter group.
    • Choose Edit parameters.
    • Modify the parameters as needed. Common parameters you might change include max_connections, innodb_buffer_pool_size, etc.
    • After making changes, choose Save changes.
  6. Associate the Parameter Group with Your RDS Instance
    • In the navigation pane, choose Databases.
    • Select the DB instance you want to modify.
    • Choose Modify.
    • In the DB Parameter Group section, select your custom parameter group.
    • Choose Continue and then Modify DB Instance.
  7. Reboot Your Instance (if needed)
    • Some parameter changes require a reboot. If this is the case, choose Reboot on the Database page for your instance.

Using AWS CLI

Create or Modify Parameter Group

    aws rds create-db-parameter-group \
    --db-parameter-group-name my-mariadb-param-group \
    --db-parameter-group-family mariadb10.3 \
    --description "My custom MariaDB parameter group"

    Modify Parameters

    aws rds modify-db-parameter-group \
    --db-parameter-group-name my-mariadb-param-group \
    --parameters "ParameterName=max_connections,ParameterValue=200,ApplyMethod=immediate"

    Associate Parameter Group with RDS Instance

    aws rds modify-db-instance \
    --db-instance-identifier mydbinstance \
    --db-parameter-group-name my-mariadb-param-group

    Reboot Your Instance (if needed)

      aws rds reboot-db-instance --db-instance-identifier mydbinstance

      Tips

      • Parameter Changes: Always review which parameters require a reboot and plan accordingly to minimize downtime.
      • Testing: If possible, test parameter changes in a staging environment before applying them to production.
      • Documentation: Refer to the Amazon RDS Documentation for detailed information on parameters and their effects.

      By following these steps, you can successfully modify the parameters of your MariaDB instance on AWS.

      Leave a Reply