Skip to content

use-rds-for-code-dx-database.md

Latest commit

 

History

History
36 lines (22 loc) · 2.31 KB

use-rds-for-code-dx-database.md

File metadata and controls

36 lines (22 loc) · 2.31 KB

Use Amazon RDS with MariaDB engine for your Code Dx database

Here are the steps required to use Code Dx with an external database hosted with AWS RDS:

Note: Code Dx currently requires MariaDB version 10.6.x.

  1. Your new MariaDB RDS database instance must use a configuration that's compatible with Code Dx. Follow the Create a DB Parameter Group instructions to create a new DB Parameter Group named codedx-mariadb-recommendation. Then edit the parameters of your new group by using the Modifying Parameters in a DB Parameter Group instructions to set the following parameter values:
  • optimizer_search_depth=0
  • character_set_server=utf8mb4
  • collation_server=utf8mb4_general_ci
  • lower_case_table_names=1
  • log_bin_trust_function_creators=1

Note: When editing a parameter value, the column to the right of the edit box shows the allowable values (not the current values).

The log_bin_trust_function_creators parameter is required when using MariaDB SQL replication, which is enabled by default with the AWS MariaDB Production template.

  1. Provision a new Amazon RDS MariaDB database instance with the codedx-mariadb-recommendation DB Parameter Group by following the installation instructions.

  2. Connect to your RDS MariaDB database instance.

  3. Create a database user for Code Dx. You can customize the following statement to create a Code Dx database user named codedx (remove 'REQUIRE SSL' when not using TLS).

    CREATE USER 'codedx'@'%' IDENTIFIED BY 'enter-a-password-here' REQUIRE SSL;

  4. Create a Code Dx database. The following statement creates a Code Dx database named codedxdb.

    CREATE DATABASE codedxdb;

  5. Grant required privileges on the Code Dx database to the database user you created. The following statements grant permissions to the codedx database user.

    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, CREATE TEMPORARY TABLES, ALTER, REFERENCES, INDEX, DROP, TRIGGER ON codedxdb.* to 'codedx'@'%'; FLUSH PRIVILEGES;