tag:blogger.com,1999:blog-9188714267863327820.post8197295706495113723..comments2024-03-20T03:06:52.713-04:00Comments on J-F Gagné's MySQL Blog: MySQL Master Replication Crash Safety Part #4: benchmarks of high and low durabilityJean-François Gagnéhttp://www.blogger.com/profile/12267071794432977020noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-9188714267863327820.post-63092764425447766622019-07-13T06:32:59.060-04:002019-07-13T06:32:59.060-04:00I decided to not publish a comment that had a susp...I decided to not publish a comment that had a suspicious link in it. If you want to maximise your chances to successfully pass my moderation, do not include unrelated links in your comments.Jean-François Gagnéhttps://www.blogger.com/profile/12267071794432977020noreply@blogger.comtag:blogger.com,1999:blog-9188714267863327820.post-56676919010343283832019-07-12T14:14:21.218-04:002019-07-12T14:14:21.218-04:000) Thanks Mark.
2) I have some of what you mentio...0) Thanks Mark.<br /><br />2) I have some of what you mention in my next post to be published Tuesday July 16.<br /><br />1) Yes, replication can do more work per fsync, and this is the subject of a later post in the series.Jean-François Gagnéhttps://www.blogger.com/profile/12267071794432977020noreply@blogger.comtag:blogger.com,1999:blog-9188714267863327820.post-28150766526216804962019-07-12T12:55:12.198-04:002019-07-12T12:55:12.198-04:000) Excellent post
1) Can replication replay do mo...0) Excellent post<br /><br />1) Can replication replay do more work per fsync? Run N transactions, then commit changes rather than fsync per transaction today.<br /><br />2) SSD is fast usually means reads are fast. Fsync on SSD can be much slower. Would be interesting to document this across clouds and devices.<br />Mark Callaghanhttps://www.blogger.com/profile/09590445221922043181noreply@blogger.comtag:blogger.com,1999:blog-9188714267863327820.post-77000095694382278532019-07-12T12:28:06.574-04:002019-07-12T12:28:06.574-04:00Hello Unknown, good to know RDS allows reducing du...Hello Unknown, good to know RDS allows reducing durability. But this probably impacts their availability solution. I have to check that in more details.Jean-François Gagnéhttps://www.blogger.com/profile/12267071794432977020noreply@blogger.comtag:blogger.com,1999:blog-9188714267863327820.post-25164488260762912792019-07-12T12:21:46.147-04:002019-07-12T12:21:46.147-04:00Great article JF. To your point, Amazon RDS does s...Great article JF. To your point, Amazon RDS does support modifying innodb_flush_log_at_trx_commit and sync_binlog. Hope Google implements that soon.Anonymousnoreply@blogger.com