Amazon Aurora MySQL
Amazon Aurora is a fully managed relational database service from AWS that is compatible with MySQL, offering high performance, scalability, and availability with automated backups and replication. Aurora also automates and standardizes database clustering and replication, which are typically among the most challenging aspects of database configuration and administration.
Prerequisites
The following prerequisites must be met in order for a user to create and test a successful connection.
- The Amazon Aurora MySQL server must be accessible from iceDQ server.
- Valid credentials to access the database.
- Amazon Aurora MySQL JDBC version 8.0 or above.
Authentication Mechanism
The following authentication mechanism is supported.
- Username & Password
Connection Properties
Use the properties create a valid connection. Properties marked with an asterisk (*) are required.
| Name | Description | Example Values |
|---|---|---|
| Connection Name * | Name that uniquely identifies the connection. | Aurora_Prod_conn |
| Driver * | Driver used to establish the connection. One driver is available by default. | Amazon Aurora MySQL Native JDBC |
| Custom JDBC URL | Standardized string used to define the connection details. Use this format supported by the driver: jdbc:mysql://[host]:[port]/[database] | jdbc:mysql://aurora-cluster.cluster-582045208563.us-east-1.rds.amazonaws.com:3306/my_database |
| Host * | The endpoint (hostname) of the Amazon Aurora MySQL cluster or instance. | aurora-cluster.cluster-582045208563.us-east-1.rds.amazonaws.com |
| Port * | Port on which the Aurora MySQL server listens. The default is 3306. | 3306 |
| Database * | Name of the target database in Aurora MySQL. | my_database |
| Type * | The connection type – either System Connection or User Connection. Refer to Connections for more details. | System or User |
| Username * | Database login username with necessary privileges. | john_doe |
| Password * | Password associated with the specified username. | aurora_password |
Custom Properties
Custom properties are optional connection parameters in the Amazon Aurora MySQL driver that allow customization of settings such as timeouts and proxy configurations. A list of supported properties is available here. The availability and behavior of custom connection properties may vary depending on the Amazon Aurora MySQL JDBC driver version in use.
Supported Datatypes
The following data types are supported:
- DATE
- TIME
- DATETIME
- TIMESTAMP
- TINYINT
- SMALLINT
- MEDIUMINT
- INT
- BIGINT
- FLOAT
- DECIMAL
- DOUBLE
- CHAR
- VARCHAR
- TEXT
- TINYTEXT
- MEDIUMTEXT
- LONGTEXT
- BIT
- BINARY
Unsupported Datatypes
The following data types are not supported:
- JSON
- BLOB
- TINYBLOB
- MEDIUMBLOB
- SET (AS CHAR)
- ENUM (AS CHAR)