Appendix G. Frequently Asked Questions (FAQ)

G.1.
G.2. One of my hosts is regularly a number of seconds behind my other slaves?
G.3. Does the replicate filter (i.e. replicate.do and replicate.ignore) address both DML and DDL?
G.4. How do you change the replicator heap size after installation?
G.5. On a Tungsten Replicator slave, how do I set both the local slave THL listener port and the upstream master's THL listener port?

G.1.

G.2.

One of my hosts is regularly a number of seconds behind my other slaves?

The most likely culprit for this issue is that the time is different on the machine in question. If you have ntp or a similar network time tool installed on your machine, use it to update the current time across all the hosts within your deployment:

shell> ntpdate pool.ntp.org

Once the command has been executed across all the hosts, trying sending a heartbeat on the master to slaves and checking the latency:

shell> trepctl heartbeat

G.3.

Does the replicate filter (i.e. replicate.do and replicate.ignore) address both DML and DDL?

Both filters replicate.do and replicate.ignore will either do or ignore both DML and DDL

DDL is currently ONLY replicated for MySQL to MySQL or Oracle to Oracle topologies, or within MySQL Clusters, although it would be advisable not to use ignore/do filters in a clustered environment where data/structural integrity is key.

With replicate.do, all DML and DDL will be replicated ONLY for any database or table listed as part of the do filter.

With replicate.ignore, all DML and DDL will be replicated except for any database or table listed as part of the ignore filter.

G.4.

How do you change the replicator heap size after installation?

You can change the configuration by running the following command from the staging directory:

shell> ./tools/tpm --host=host1 --java-mem-size=2048

G.5.

On a Tungsten Replicator slave, how do I set both the local slave THL listener port and the upstream master's THL listener port?

You need to specify two options: thl-port to set the slave THL listener port and master-thl-port to define the upstream master THL listener port. Otherwise thl-port alone sets BOTH.