[Maria-developers] TCP CRCs - relevant for client/server including replication communications
Hi all See http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.27.7611 In a nutshell, you cannot expect TCP streams to be error free, instead expect a packet to go wrong every few days; that's quite significant, particularly when talking about replication streams. And most if not all of us in the real world have encountered this. It's a serious case for having CRCs in the binlog (yes I know it's put in from Google patches to later versions in 5.5+ but I really want it in MariaDB, urgently!), but also as a potential consideration for other communications, including client/server. The replication streams are the most critical though, that's where stuff has been seen to break in practice - and that's when your lucky and the fail results in a syntax error - if it changes data rather than keywords, it can remain invisible. (in such cases you could have a replication slave copying a transaction perfectly except it has wrong data...) Regards, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Remote expertise maintenance for MySQL/MariaDB server environments. Follow us at http://openquery.com/blog/ http://twitter.com/openquery ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
Re: [Maria-developers] TCP CRCs - relevant for client/server including replication communications
Arjen Lentz ar...@openquery.com writes: It's a serious case for having CRCs in the binlog (yes I know it's put in from Google patches to later versions in 5.5+ but I really want it in MariaDB, urgently!), but also as a potential consideration for other communications, including client/server. http://kb.askmonty.org/en/binlog-event-checksums Checksums are in MariaDB 5.3. It's also in the MariaDB 5.2 replication preview. - Kristian. ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
Re: [Maria-developers] TCP CRCs - relevant for client/server including replication communications
Hi Kristian From: Kristian Nielsen kniel...@knielsen-hq.org http://kb.askmonty.org/en/binlog-event-checksums Checksums are in MariaDB 5.3. It's also in the MariaDB 5.2 replication preview. Off by default? Cheers, Arjen. -- Arjen Lentz, Exec.Director @ Open Query (http://openquery.com) Remote expertise maintenance for MySQL/MariaDB server environments. Follow us at http://openquery.com/blog/ http://twitter.com/openquery ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
Re: [Maria-developers] Fwd: [Commits] Rev 3071: Fix LP bug lp:802979 in file:///home/tsk/mprog/src/5.3-mwl89/
Hi Timour, On Mon, Jul 04, 2011 at 03:40:49PM +0300, Timour Katchaounov wrote: Sergey Could you please review my fix for bug lp:802979. I need you specifically because I needed to touch the range optimzizer to disable evaluation of single-row subqueries. Please consider if I chose the best place in the range optimizer to disable this evaluation of single-row subqueries. I will be back from vacation on Tuesday, so if there is need for discussion, we can talk on Tuesday evening or Wednesday any time. I think I have some questions about this fix. Could you catch me on irc so we could discuss it? BR Sergey -- Sergey Petrunia, Software Developer Monty Program AB, http://askmonty.org Blog: http://s.petrunia.net/blog ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp