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. |