Managed MySQL databases support customizing SQL modes through the Settings tab to control database behavior and error handling
Yes, Vultr Managed MySQL clusters allow you to configure SQL modes. SQL modes control the behavior of MySQL for aspects such as strictness, compatibility, and error handling. You can apply these modes through the Settings tab of your database cluster in the Vultr Customer Portal.
Vultr supports configuring both individual SQL modes and combination modes. For example, the ANSI (Combination Mode) includes: REAL_AS_FLOAT, PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, and ONLY_FULL_GROUP_BY. If ANSI mode is enabled, its settings take precedence over individual mode toggles.
Similarly, the TRADITIONAL (Combination Mode) includes: STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION.
NO_BACKSLASH_ESCAPES and PAD_CHAR_TO_FULL_LENGTH, are not supported in Vultr Managed Databases.
Some configuration options that cannot be set globally can be applied per session. For instance:
mysql> SET SESSION binlog_row_value_options = partial_json;
For detailed information on configuring SQL modes, refer to the Global SQL Modes documentation.