[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

Arjen Lentz <arjen@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.

Hi Kristian
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
participants (2)
-
Arjen Lentz
-
Kristian Nielsen