文章详情

  • 游戏榜单
  • 软件榜单
关闭导航
热搜榜
热门下载
热门标签
php爱好者> php文档>MySQL Row Change Event Extraction and Publish

MySQL Row Change Event Extraction and Publish

时间:2009-06-30  来源:tclwp

MySQL Row Change Event Extraction and Publish
Average rating
 
(5.00, 1 rating)
Add your rating
Gene Pang (Google)
2:00pm Thursday, 04/23/2009
Replication and Scale-Out
Location: Ballroom A

This talk introduces a MySQL row change extraction system we built at Google. We have modified MySQL 5.1 source code to generate row-level change logs without use of triggers. The system continuously extracts row change events out of a large-scale replicated MySQL server cluster, converts these events sequentially to self-contained protocol buffer records, and then stores them to permanent GFS storage. The result real-time row change event streams are also replicated to various data centers and fed to various proprietary applications. As these row change event streams offer a complete and ordered sequence of transaction changes, they can be used for many purposes. They are used by many applications to track changes to databases and combined with simple filters, they are used to maintain derived views out of MySQL databases. As each row change record contains both the old and new table entry data, a lot of applications can avoid costly periodical full table extractions. Another usage case is to maintain database replicas in a non-relational storage infrastructure. Applications with high read bandwidth but low transaction consistency requirements can read from the non-relational storage infrastructure instead of MySQL servers.

相关阅读 更多 +
排行榜 更多 +
步行僵尸2无限金币版

步行僵尸2无限金币版

体育竞技 下载
狐狸一号特殊任务无限金币版

狐狸一号特殊任务无限金币版

体育竞技 下载
忍者之雷复仇无限金币钻石版

忍者之雷复仇无限金币钻石版

体育竞技 下载