Unsupported Features
Some features of MySQL Server are not natively supported in HeatWave Service, but you can use the alternative functionalities.
Table 5-16 Unsupported Features
| Self-Managed MySQL Server | HeatWave Service |
|---|---|
Setting global variables or persisted
system variables (SET
PERSIST)
|
Use HeatWave Configurations. See Configuration of a DB System. |
Direct modification of system tables
(mysql schema)
|
Not supported. |
| Error logging to system log | Limited to SQL access. No direct file access. See Viewing the Error Log. |
| Binary log access | Limited to SQL access. No direct file
access. Use SHOW BINLOG EVENTS or
mysqlbinlog
--read-from-remote-server |
| Audit log access | Limited to SQL access. No direct file access. |
| Slow query log | Not supported. Use
SYS,
PERFORMANCE_SCHEMA tables, or
Audit query statistics. See MySQL Enterprise Audit
Plugin.
|
| Group replication plugin | Use high availability. See High Availability. |
| Asynchronous replication (inbound) | Use HeatWave Channels. See Inbound Replication. |
| Replication filters | Use HeatWave Channels filters. See Channel Filter Rules. |
| Delayed replication | Use HeatWave Channels delay. See Creating a Replication Channel. |
| Multi-source replication | Not supported. |
| Semisynchronous replication | Not supported. |
| Transportable tablespace | Not supported. |
| READ ONLY and SUPER READ ONLY | Not supported. |
| InnoDB Tablespace Encryption (TDE) | HeatWave volumes are always encrypted at rest using keys managed by Oracle. Customers managed keys are not supported. See Data Security. |
| Authentication Plugins | Use OCI IAM integration. See Authenticating Using authentication_oci Plugin and Plugins and Components. |
| Custom TLS certificates | Use OCI Certificates integration. See Advanced Option: Connections. |
| Password Validation Plugin | Available, but currently not configurable. Implement password policies at the application level when necessary. See Plugins and Components. |
| Granting privileges using wildcards | You must use fully-qualified database grants. By default, the system variable partial-revokes is enabled and you cannot disable it. As a result, wildcards in database name are treated literally. See partial_revokes. |
| Adding loadable functions - previously known as User-Defined Functions (UDFs) | Not supported. |