New answers tagged percona
0
Please look at the following view of the InnoDB/XtraDB Architecture
Please notice the Percona Server Documentation on This
Performance Impact of the Doublewrite Buffer
In usual workloads the performance impact is low-5% or so. As a
consequence, you should always enable the doublewrite buffer because
the strong guarantee against data ...
1
it seems the binlog doesn't include the new inserts
I'm not sure whether you're saying the binlog actually doesn't include them, and you have confirmed this with mysqlbinlog, or that it "seems" like it doesn't, because they don't replicate.
PXC needs log_slave_updates turned on at the node serving as master to the asynchronous slave, otherwise, not ...
1
Binary Log Format : I was thinking that since Percona XtraDB Cluster (PXC) required using binlog_format as ROW, all the read-only Slaves should also have that setting.
binlog_do_db : It will record every option for a given database only. Notwithstanding, this is an option that is sometimes misunderstood. Please read this blog entry from mysqlperformanceblog ...
2
Percona xtrabackup documentation indicates that you should point xtrabackup_55 to the backup-my.cnf file taken with your backup, rather than your live my.cnf file.
If you're doing the prep on the same server as the backup was taken, I'm not sure if it will make a difference.
1
It turned out to be a bug in percona-xtrabackup-2.1.2-611.rhel6.x86_64. Downgrading to percona-xtrabackup-2.0.7-552.rhel6.x86_64 solved the issue.
Top 50 recent answers are included
