We’ve written about replication slaves lagging behind masters before, but one of the other … storage engines, then your options are to either try and time delay slaves (to keep them close to up to date), or…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…time_zoneblogpercona.commanual default_week_formatblogpercona.commanual defaults_extra_fileblogpercona.commanual defaults_fileblogpercona.commanual defaults_group_suffixblogpercona.commanual delay_key_writeblogpercona.commanual Delayed…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…; abnormal things happen constantly. It’s useful to spend time investigating abnormalities, but in general, you should try to …failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly. …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… much to me. According to the NTP standard, if the delay between the hosts is greater than 128 ms, NTP won… achieve a high throughput despite the response time limitations. Even with parallel replication, the response time limits the number of transactions / second that… parallel replication. In this case the cost of latency on commit will be 5 ms each time. Q: Can I change the replication…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…corrupted on crash. delayed_insert_limit, delayed_insert_timeout, delayed_queue_size Delayed inserts configuration. Technically…related. expire_logs_days This is replication/binlogging related options – when to delete…after query is complete or every flush_time seconds. This is technically variable …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… “real-time” analysis. Our customers often want their systems to provide the freshest data to their own clients, with no delays… replication lag badly. More about this later. Another way to say “aggregate” is to say “pre-compute.” If you have time… A day at a time, for example. There are a lot of other ways you can make replication faster. I wrote…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… your scaling path – it becomes very easy to overload the replication, especially as it has to serialize transactions on the slave… + another mysql instance (or simply the database which is not replicated) to log updates in heap/myisam/archive table and aggregate… doing these delayed updates you can not only reduce number of updates, say if popular object viewed 1000 times within an hour…
Post: Emulating global transaction ID with pt-heartbeat
November 4, 2011 By 6 Comments
… datacenters. Once upon a time, one of our customers had a very “tall” replication topology, with servers replicating back and forth across datacenters… works. Everyone who runs replication should be running pt-heartbeat already to get a reliable indicator of actual replication delay. This avoids the many problems with Seconds_behind_master, which pop up continually. But now it’s time to…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 10 Comments
… is not new to the toolkit. We developed it some time ago for a client and quietly included it, without knowing… key is that it is replication-aware and inspects replicas, throttles its operation to avoid causing replication delay, watches for load on the… on Tuesday Daniel will talk about using it to verify replication Peter will discuss using it to verify upgrades I’ll…
Post: MySQL should have dynamic durability settings
April 8, 2008 By 4 Comments
… default way set for the session, COMMIT DELAYED to flush transaction log some time in the future and COMMIT FORCE to force… replication is asynchronous anyway you do not have to flush logs for each transaction. Replication option could be implemented to utilize delayed commit for the replication thread. This is surely not…
