Re: [Maria-developers] Fwd: possible bug in MySQL 5.6.7-rc slave replication crash safety?

2012-10-24 Thread Kristian Nielsen
Zardosht Kasheff writes: > For me, the biggest design goal is to have a way for slaves to be > crash safe without requiring the storage engine to fsync every > transaction it processes. This would be a huge performance win. Right. This basically requires [*] that everything goes through a single

Re: [Maria-developers] Fwd: possible bug in MySQL 5.6.7-rc slave replication crash safety?

2012-10-23 Thread Zardosht Kasheff
Hello Kristian, Thanks for the feedback. For me, the biggest design goal is to have a way for slaves to be crash safe without requiring the storage engine to fsync every transaction it processes. This would be a huge performance win. In a world where slave replication is single threaded, I solut

Re: [Maria-developers] Fwd: possible bug in MySQL 5.6.7-rc slave replication crash safety?

2012-10-23 Thread Kristian Nielsen
Thinking more about this, I cannot quite make up my mind of the best approach. I would like to get some input. On the one hand, when binlog is enabled on a slave, it really is the best solution for storing replication state and crash safety. On the other hand, running a slave with innodb_flush_lo

Re: [Maria-developers] Fwd: possible bug in MySQL 5.6.7-rc slave replication crash safety?

2012-10-21 Thread Kristian Nielsen
Zardosht Kasheff writes: > Thank you for the reply. I want to make sure I understand this > correctly. Is the planned design for crash safe replication to be that > the slave must have the binary log enabled, so that slaves may use the > GTID and XA to ensure that the slave and master are in sync

Re: [Maria-developers] Fwd: possible bug in MySQL 5.6.7-rc slave replication crash safety?

2012-10-19 Thread Zardosht Kasheff
Hello Kristian, Thank you for the reply. I want to make sure I understand this correctly. Is the planned design for crash safe replication to be that the slave must have the binary log enabled, so that slaves may use the GTID and XA to ensure that the slave and master are in sync? If the binary lo

Re: [Maria-developers] Fwd: possible bug in MySQL 5.6.7-rc slave replication crash safety?

2012-10-19 Thread Kristian Nielsen
Zardosht Kasheff writes: > What is that solution? Is the solution in MariaDB 5.5? Is there a way > for another engine to also have this solution? 1. http://www.percona.com/doc/percona-server/5.5/reliability/innodb_recovery_update_relay_log.html 2. Yes (I think it's even in MariaDB 5.1) 3. No,

Re: [Maria-developers] Fwd: possible bug in MySQL 5.6.7-rc slave replication crash safety?

2012-10-19 Thread Zardosht Kasheff
What is that solution? Is the solution in MariaDB 5.5? Is there a way for another engine to also have this solution? Thanks -Zardosht On Fri, Oct 19, 2012 at 3:16 AM, Kristian Nielsen wrote: > Zardosht Kasheff writes: > >> Does Maria 10.0 implement crash safe replication that is found in >> MyS

Re: [Maria-developers] Fwd: possible bug in MySQL 5.6.7-rc slave replication crash safety?

2012-10-19 Thread Kristian Nielsen
Zardosht Kasheff writes: > Does Maria 10.0 implement crash safe replication that is found in > MySQL 5.6.7? If so, does this issue exist there? No (not yet at least). So the issue does not exist at the moment. Note that XtraDB in MariaDB has another solution for crash safe replication. - Kris

[Maria-developers] Fwd: possible bug in MySQL 5.6.7-rc slave replication crash safety?

2012-10-18 Thread Zardosht Kasheff
Hello, Does Maria 10.0 implement crash safe replication that is found in MySQL 5.6.7? If so, does this issue exist there? Thanks -Zardosht -- Forwarded message -- From: Zardosht Kasheff Date: Wed, Oct 17, 2012 at 8:59 AM Subject: possible bug in MySQL 5.6.7-rc slave replication