https://bugzilla.wikimedia.org/show_bug.cgi?id=38945
Siebrand Mazeland <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |l, [email protected], | |[email protected] --- Comment #8 from Siebrand Mazeland <[email protected]> --- Adding some information from an email by Sean: Nothing built into MariaDB 5.5, but Percona Toolkit has a decent tool: http://www.percona.com/doc/percona-toolkit/2.2/pt-slave-delay.html However it will depend on how accurate a delay is needed to be useful. The tool starts and stops the replication SQL thread predictably but the minimum time granularity is one transaction, which fluctuates, obviously. Essentially a delay in the order of minutes is easy to maintain. Seconds... sort of. Oracle's MySQL 5.6 has slave delay built-in using CHANGE MASTER TO MASTER_DELAY = <sconds>. The next MariaDB major relase may get that port -- havn't checked -- but that doesn't help us today. - the DB are Ubuntu Lucid instances with MySQL installed manually (aka no puppet class applied) Ubuntu has percona toolkit packages in our repos. At least coredb have them installed by default. Only depends on perl. -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
