Posted by peter |
…0) – there is enough gotchas with
replication itself and getting things right with …be very helpful in advanced cases allowing
replication to control what will be logged to… get into classical issues of chain
replication – the latency will increase a bit (…
Posted by peter |
… before you run ALTER TABLE query.
Replication Overload Many tutorials out where will … of time.
Idea: MySQL Should add “
Replication Load Average” metric which would … execution time of queries being
replicated. Unfortunately MySQL Slow Query Log …
Posted by yves |
…popular HA solution for MySQL,
replication.
High Availability solution for MySQL…impact backups
Automatic failover with
replication
I already mentioned that for…to manage automatic failover with
replication like MMM, Flipper and Tungsten…
Posted by peter |
… in low hanging fruit troubleshooting MySQL
Replication Lag
First fact you absolutely need to remember is MySQL
Replication is single threaded, which means if … there is enough breathing room for
replication thread.
You can also have …
Posted by peter |
…, even on completely unrelated table,
replication lag may increase dramatically. Besides …would go using simple master slave
replication ?
- Small database size. Small meaning … may however want to structure
replication with median servers to avoid …
Posted by Baron Schwartz |
… fired up my master-and-two-slaves
replication sandbox, flushed all the logs, and …’s clearly an opportunity to break
replication here. It looks like this doesn’t… temporary tables with MySQL statement-based
replication without some risk of breaking slaves….
Posted by peter |
… can be used in Master-Master
replication in Active-Passive mode, just think …and improving scalability by use of simple
replication. If using this approach you should … should not forget to monitor if
replication is running properly and if
replication …
Posted by peter |
Kevin Burton writes about making MySQL
Replication Parallel. Many of us have been … it right without changing MySQL
Replication semantics – which is – Slave database … implemented for many applications Parallel
Replication could be implemented simply by …
Posted by peter |
… posted very nice post about MySQL
Replication Performance. There are however few points I …in fact they are quite different for
Replication. As you probably know MyISAM uses … will not be used effectively as
replication SQL thread will typically submit IO …
Posted by peter |
…a bug regarding slow queries executed by
replication thread are not being logged to the… on your server – in certain configurations
replication load itself may be very significant …10 seconds on the slave and your
replication is well loaded, this means at …
del.icio.us
digg