The CA API Gateway uses MySQL replication to leverage a mechanism database failover. This failover is used to ensure that a database host is always available to serving policies and auditing requests. This replication relationship between database hosts must be configured in advance by a system administrator or operator. The procedure may fail under certain circumstances due to a misconfiguration of the MySQL server configuration file. This article will prescribe the steps to configure the database server appropriately.
The following error message may be printed in the console when attempting to initialize replication for the first time or when reinitializing replication after a failure or restoration event:
Error creating database when saving configuration 'Cannot create database: 'This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)' [code:-1, UNKNOWN_FAILURE]'
All supported versions of the API Gateway
If this error message is printed in a log or console message then execute the following procedure to resolve.
server-id=1
server-id=2