Toolserver:Admin:Trainwreck

trainwreck is a tool we use to handle MySQL replication when one server needs to replicate from several masters. It runs externally to MySQL, connecting as the dbsyncer user.

The configuration file is in /etc/trainwreck, and the software is in /opt/local. The SMF FMRI is svc:/network/trainwreck:instance. The default instance is usually used for commons; some servers have other instances as well.


 * Start it: svcadm enable trainwreck:instance
 * Stop it: svcadm disable trainwreck:instance
 * Restart it: svcadm restart trainwreck:instance

Sometimes, trainwreck gets stuck and won't stop properly. In this case, find the PID and kill it manually (kill -9). Then restart it using svcadm. This will be resolved if/when we move to TW2, the new version.

Category:Admin:Database