Tag Info

New answers tagged

0

Another topology would be a 3-node Galera cluster, plus 2 ordinary readonly slaves hanging off each Galera node. Send non-critical-read requests to any of the 6 slaves; send writes to any of the 3 cluster nodes. The reason for failure to scale writes is that all writes must be written to all nodes. Row Based Replication (required by Galera) helps lighten ...


0

PXC and Galera Cluster do not write scale very well. I mentioned this in my answer to the old post Transaction speed benchmarks for mySQL v5.6 replication - seems very slow where I said the following: Please keep in mind that Percona XtraDB Cluster does not write scale very well to begin with. Note what the Documentation says under its drawbacks (Second ...


1

I have seen your problem before Problem #1 You have /etc/mysql/conf.d/mycustom.cnf and the log-bin line is not being read Problem #2 Chances are /etc/mysql/conf.d/my.cnf exists and has the following line [mysqld] log-bin=OFF That's why the binlogs start with a filename of OFF Some feel log-bin=OFF disables binlogging. The MySQL Documentation on ...


2

If you apply the redo log right after a backup copy is taken you can greatly reduce time to restore. Sometimes --apply-log step fails. Due to a bug or tablespace corruption. In either case you don't want to learn that in the emergency. That's one more argument to do the --apply-log after the backup. People don't apply the redo log because it brings in more ...



Top 50 recent answers are included