GoldenGate Setup (Oracle GoldenGate 12.2)
Example Extract Parameter File EXTRACT <extract_group_name> SETENV(MYSQL_HOME='/var/lib/mysql') SETENV (MYSQL_UNIX_PORT='/var/lib/mysql/mysql.sock') DBOPTIONS CONNECTIONPORT <mysql_port> DBOPTIONS HOST <mysql_host_name> SOURCEDB <database_name> useridalias <user_id_alias> ... TRANLOGOPTIONS ALTLOGDEST "/var/lib/mysql/bin-log.index" FILTERTABLE <database_name>.checkpoint_tbl Creating an Extract Group
add extract <group_name>, tranlog, begin now add exttrail <trail_file_location_and_name>, extract <group_name>, megabytes <max_trail_file_size_in_megabytes> Example Replicat Parameter File
Replicat <replicat_group_name> SETENV(MYSQL_HOME='/var/lib/mysql') SETENV (MYSQL_UNIX_PORT='/var/lib/mysql/mysql.sock') DBOPTIONS CONNECTIONPORT <mysql_port> DBOPTIONS HOST <mysql_host_name> TARGETDB <database_name> USERID <user_name>, PASSWORD <password> ... MAP <source_db.schema>, TARGETDB <target_db.schema> Creating an Replicat Group
add replicat <group_name>, exttrail <trail_file> checkpointtable <checkpoint_table> |
MySQL Setup
MySQL Command
-- Show Databases mysql>show databases; -- Show Tables mysql> show tables; -- Show MySQL Port mysql>show variables where variable_name = 'port'; -- Show Binlog Status mysql> show variables like 'log_bin'; -- Show Binlog directory mysql>show variables like 'datadir'; Enable Binlog
-- my.cnf log-bin=bin.log log-bin-index=bin-log.index max_binlog_size=100M binlog_format=row |
Jinyu's Blog |
|