Database

Applications can use the database provided with the service. The database is Amazon Aurora MySQL 3 (MySQL 8.0 compatible), and you can create MySQL-compatible databases and tables. You can build database objects such as databases, tables, and views using a GUI. SQL syntax follows MySQL 8.0. Open the database from the side menu [Databases] menu.

Serverless Option

The database has a serverless option.
By subscribing to the serverless option, the database instance specifications can scale automatically.
You can check the serverless option subscription status from the basic information of the execution environment.

Relationship Between Database and Serverless Option

Database	Serverless Option
Database instance specifications are fixed	Database instance specifications scale automatically
Database instance specifications vary depending on the Pricing Plan.	Database instance specifications are represented by ACU (Aurora Capacity Unit). ACU consists of a combination of CPU and memory. The larger the ACU value, the higher the database instance specifications.

Note

• Depending on Pricing, the specifications of the database instance will vary.

• There are restrictions on naming databases, tables, columns, indexes, aliases, views, stored procedures, and functions.
  Please note that restricted naming may generate invalid or ambiguous formatted names.

• Restrictions:

  • Number-only strings are not acceptable.
  • String beginning with Number+e is not acceptable.
  • No quotation marks (single or double quotation marks)
  • Spaces are not allowed.
  • The string “tmp” is not allowed.
  • Reserved words are not allowed. (See MySQL 8.0 Keywords and Reserved Words)