Toolserver:Admin:Trainwreck

From mediawiki.org

This page was moved from the Toolserver wiki.
Toolserver has been replaced by Toolforge. As such, the instructions here may no longer work, but may still be of historical interest.
Please help by updating examples, links, template links, etc. If a page is still relevant, move it to a normal title and leave a redirect.

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