Q&A - Cloud Database

Tilaa's Cloud database is a newly introduced product that offers fully managed database services, relieving customers of the burden of performing maintenance on their databases at the software layer.

When is the maintenance planned?

Tilaa will meticulously plan and organise maintenance activities for the Cloud databases. Once the schedule is prepared, customers will be promptly notified via email.

Connecting to the databases takes a long time

When attempting to establish a connection to the databases, it is possible that the process may take a few minutes. This delay may occur due to the absence of an IPv6 address in the whitelist.

In such cases, your machine will initially attempt to utilize an IPv6 connection string. If the connection is unsuccessful, it will automatically switch to an IPv4 connection.

To ensure seamless connectivity, remember to add your IPv6 address to your Cloud Database configuration during setup.

I'm not allowed to use " as command

If you encounter an error similar to the one below:

mysql> show fields in "sbtest1";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"sbtest1"' at line 1

You can resolve it by adding the following parameter to your connection string:

 <connection string> --sql-mode="ansi_quotes"

What are the default values for sql_mode that has been set

For your convenience, below are the default values for the sql_mode that are set up during the database creation process:

ONLY_FULL_GROUP_BY
  STRICT_TRANS_TABLES
  NO_ZERO_IN_DATE
  NO_ZERO_DATE
  ERROR_FOR_DIVISION_BY_ZERO
  NO_ENGINE_SUBSTITUTION

These values are applied to ensure proper functionality and compliance with relevant standards.