CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Changing the Binary Log Location or Base Name

After you run CDC sessions that extract change data for MySQL sources, avoid changing the base name of the binary log files or the name or location of the directory that contains the binary log files to minimize the potential for change data loss.

If you must change the binary log location, perform the following tasks:

Stop all CDC sessions that process data from the MySQL source.

Shut down the MySQL server.

In the log-bin option for binary logging, add the new binary log location, including the path and directory, before the base name.

Copy the existing binary log files and index to the new location.

Restart the MySQL server.

Warm start the CDC sessions.

If you must change the binary log base name, or if you want to change the binary log location without copying the existing binary log files to the new location, perform the following tasks:

Stop all CDC sessions that process data from the MySQL source.

Shut down the MySQL server.

In the log-bin option for binary logging, add the new base name or add the new location with the new or existing base name.

Use the PWXCATMY utility to remove, or unregister
, the source table definitions from the catalog. Then use the utility to re-create, or re-register
, snapshots of the source definitions in the catalog.

Restart the MySQL server.

Cold start the CDC sessions.

Managing MySQL CDC

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal