Expected Behavior
dSource ingestion fails when the MySQL server's global environment variable "log_bin" is enabled. Even though the default setting of the binary logging is disabled, there are situations where customer may use existing server with log_bin enabled.
Actual Behavior
dSource ingestion to complete successfully whether binary logging is enabled or disabled on staging. The ingestion process anyway enables log_bin at the end of ingestion.
Steps To Reproduce the Problem
Set the log_bin option on MySQL staging server to "ON" and run the dSource ingestion. The process fails with error "unable to start database on stage".
Version
MySQL 5.7.19
Additional Context
restore_stage.sh script of the plugin is using mysqld initialize without log_bin directory option. In order to initialize a database on a sever with log_bin as "ON" we need to use log_bin option in mysqld initialize command (which was missing)
Expected Behavior dSource ingestion fails when the MySQL server's global environment variable "log_bin" is enabled. Even though the default setting of the binary logging is disabled, there are situations where customer may use existing server with log_bin enabled.
Actual Behavior dSource ingestion to complete successfully whether binary logging is enabled or disabled on staging. The ingestion process anyway enables log_bin at the end of ingestion.
Steps To Reproduce the Problem Set the log_bin option on MySQL staging server to "ON" and run the dSource ingestion. The process fails with error "unable to start database on stage".
Version MySQL 5.7.19
Additional Context restore_stage.sh script of the plugin is using mysqld initialize without log_bin directory option. In order to initialize a database on a sever with log_bin as "ON" we need to use log_bin option in mysqld initialize command (which was missing)