tag:blogger.com,1999:blog-23496029.post278304241592578840..comments2024-01-11T10:27:57.989+01:00Comments on MySQL Musings: Statement-based replication is disabled for FalconMats Kindahlhttp://www.blogger.com/profile/07528917029894926261noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-23496029.post-37449266569094923792008-06-06T15:54:00.000+02:002008-06-06T15:54:00.000+02:00I still want the original statements for audit and...I still want the original statements for audit and debugging purposes. I have spent a lot of time getting comments into SQL statements to identify application owners. With the scheme you have proposed, I will get the row changes but have no idea what the original statement and I won't have the comment. Why can't there be an option to create a new no-op event that includes the original SQL statement?Mark Callaghanhttps://www.blogger.com/profile/09590445221922043181noreply@blogger.comtag:blogger.com,1999:blog-23496029.post-47895980788147106862008-06-06T10:30:00.000+02:002008-06-06T10:30:00.000+02:00Swany, you can use RBR can still be able to get SB...Swany, you can use RBR can still be able to get SBR like statements. Just take a look at:<BR/><BR/>http://jan.kneschke.de/2008/5/30/mysql-proxy-rbr-to-sbr-decoding<BR/><BR/>If column names aren't too important the released code is already good enough. If later releases we will mix in scripting to allow users to map in the original column-names.Unknownhttps://www.blogger.com/profile/11415977709348410535noreply@blogger.comtag:blogger.com,1999:blog-23496029.post-55436004844246996682008-06-05T21:19:00.000+02:002008-06-05T21:19:00.000+02:00Well this is pretty foobar in my opinion. I use s...Well this is pretty foobar in my opinion. I use statement binary logs for auditing purposes like determining the insert/update/delete rate for individual tables, etc.<BR/><BR/>As Mark said, Falcon should be able to set locks like InnoDB does to ensure serializable order.Justin Swanharthttps://www.blogger.com/profile/08193089637089861226noreply@blogger.comtag:blogger.com,1999:blog-23496029.post-442385226040503272008-06-05T18:02:00.000+02:002008-06-05T18:02:00.000+02:00Is there a description with more details that desc...Is there a description with more details that describes why this can't be done?<BR/><BR/>Why can't they use the technique that is used by InnoDB - for statements like 'insert into Foo select * from Bar' read locks are taken on the rows from Bar?Mark Callaghanhttps://www.blogger.com/profile/09590445221922043181noreply@blogger.com