#Database - Tech Note

<style>/*<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

<!-- data-ad-client=ca-pub-1189446586273460 -->

</head><body>*/</style>

Aurora Performance

Aurora MySQL Binlog 副本级联复制

概述在企业级数据库架构中，经常需要将 Aurora MySQL 的数据变更实时同步到外部系统，例如通过 binlog 订阅实现数据变更捕获（CDC）驱动下游数据处理管道。当数据库存在过多的 binlog 下游应用（通过 MySQL replication protocol ...

iX. 2025-12-19

Aurora AWS

Aurora 蓝绿部署 Binlog 复制回滚指南

回滚方案对比当蓝绿部署切换到绿环境后发现问题需要回滚时，有以下几种方案：方案对比表方案回滚时间数据丢失复杂度成本 Binlog 复制 10分钟-2小时 ✅ 无低无额外成本快照恢复 30分钟-4小时 ⚠️ 快照后...

iX. 2025-12-17

Aurora AWS

Aurora 集群蓝绿部署升级指南

概述 Amazon Aurora 蓝绿部署（Blue/Green Deployment）是一种零停机升级方案，通过创建同步的测试环境库版本升级、参数修改等操作，切换时停机时间通常小于 1 分钟。适用场景：主版本升级（如 Aurora 3.04 → 3.10）次版本...

iX. 2025-11-10

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/851759228-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AAPvtVnb_AnoyBCuQbLldh9k9rec:1789643393661';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7630626813003569974','//t.creast.win/search/label/%23Database?max-results\x3d10','7630626813003569974');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7630626813003569974', 'title': 'Tech Note', 'url': 'https://t.creast.win/search/label/%23Database?max-results\x3d10', 'canonicalUrl': 'https://t.creast.win/search/label/%23Database?max-results\x3d10', 'homepageUrl': 'https://t.creast.win/', 'searchUrl': 'https://t.creast.win/search', 'canonicalHomepageUrl': 'https://t.creast.win/', 'blogspotFaviconUrl': 'https://t.creast.win/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'G-RXM44HT0EL', 'analytics4': true, 'encoding': 'UTF-8', 'locale': 'zh-CN', 'localeUnderscoreDelimited': 'zh_cn', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Tech Note - Atom\x22 href\x3d\x22https://t.creast.win/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Tech Note - RSS\x22 href\x3d\x22https://t.creast.win/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Tech Note - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/7630626813003569974/posts/default\x22 /\x3e\n', 'meTag': '\x3clink rel\x3d\x22me\x22 href\x3d\x22https://www.blogger.com/profile/00061260980836260911\x22 /\x3e\n', 'adsenseClientId': 'ca-pub-1189446586273460', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'isGoogleEverywhereLinkTooltipEnabled': true, 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/31d4351e075118ef', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': '\u83b7\u53d6\u94fe\u63a5', 'key': 'link', 'shareMessage': '\u83b7\u53d6\u94fe\u63a5', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': '\u5206\u4eab\u5230 Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': '\u5206\u4eab\u5230 X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': '\u5206\u4eab\u5230 Pinterest', 'target': 'pinterest'}, {'name': '\u7535\u5b50\u90ae\u4ef6', 'key': 'email', 'shareMessage': '\u7535\u5b50\u90ae\u4ef6', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27zh_CN\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': '\u9605\u8bfb\u5168\u6587', 'pageType': 'index', 'searchLabel': '#Database', 'pageName': '#Database', 'pageTitle': 'Tech Note: #Database', 'metaDescription': '\u4e00\u4e2aIT\u6280\u672f\u6587\u6863\u5907\u5fd8\x26\u5206\u4eab\u5c0f\u7ad9\u3002'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': '\u4fee\u6539', 'linkCopiedToClipboard': '\u94fe\u63a5\u5df2\u590d\u5236\u5230\u526a\u8d34\u677f\uff01', 'ok': '\u786e\u5b9a', 'postLink': '\u535a\u6587\u94fe\u63a5'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': '\u81ea\u5b9a\u4e49', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Tech Note', 'description': '\u4e00\u4e2aIT\u6280\u672f\u6587\u6863\u5907\u5fd8\x26\u5206\u4eab\u5c0f\u7ad9\u3002', 'url': 'https://t.creast.win/search/label/%23Database?max-results\x3d10', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': false, 'isArchive': false, 'isSearch': true, 'isLabelSearch': true, 'search': {'label': '#Database', 'resultsMessage': '\u76ee\u524d\u663e\u793a\u7684\u662f\u6807\u7b7e\u4e3a\u201c#Database\u201d\u7684\u535a\u6587', 'resultsMessageHtml': '\u76ee\u524d\u663e\u793a\u7684\u662f\u6807\u7b7e\u4e3a\u201c\x3cspan class\x3d\x27search-label\x27\x3e#Database\x3c/span\x3e\u201d\u7684\u535a\u6587'}}}, {'name': 'widgets', 'data': [{'title': 'Tech Note (\u6807\u9898)', 'type': 'Header', 'sectionId': 'header-main', 'id': 'Header01'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList01'}, {'title': 'Icons, Dark, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList02'}, {'title': 'Featured Post', 'type': 'FeaturedPost', 'sectionId': 'before-blog', 'id': 'FeaturedPost12', 'postId': '5674764548888878808'}, {'title': '\u535a\u6587', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog22', 'posts': [{'id': '6413959203395167858', 'title': 'Aurora MySQL Binlog \u526f\u672c\u7ea7\u8054\u590d\u5236', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEiuexLivFPDRXe-qzT9zPdi-NAYybCQUr7B0kiVCstE3zZBvMIxM_RsAKOyMG4Ydk8nNBP5OkUo1kpzv0zncaVmK7UrlrGW_MJB1ekGScip8-UtwlXfz8PWeoIR0ZgyJzmV2rOCuruzesjQPnk96El_NAauxnL05vL_j5XpN_D_qf51AS6kWPi5eVma8q8\x3dw562-h640', 'showInlineAds': false}, {'id': '2354857549624524875', 'title': 'Aurora \u84dd\u7eff\u90e8\u7f72 Binlog \u590d\u5236\u56de\u6eda\u6307\u5357', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEj15xi8uvYXI4gSY8RDYK2mS3mTKfIjn0OeHC3LxsparaeJ2s2iHBfg5fCr9hIvxNEs0eMOvKVoDCs8Zum5JLjv2GzIRe0jp2fSaMXY2pTdSJpMZQpBwUeyj6FkTppLyCHjnqVjRHM7BjGQOv6E3ip93KS0jSjtKBONY0gn5QkbPbExCMPGECeIjWSLFGw\x3dw640-h208', 'showInlineAds': false}, {'id': '2919276204105220538', 'title': 'Aurora \u96c6\u7fa4\u84dd\u7eff\u90e8\u7f72\u5347\u7ea7\u6307\u5357', 'featuredImage': 'https://blogger.googleusercontent.com/img/a/AVvXsEimF_nmUfU_uXlPo9kQ12MRUjPz-Fz4G9UMG1TFDPiJsBoREFaM6hN4QsN5mtlfDXj0ckypZ_p14uWvO9TaEykl3CQ2cFFNtaOZSSr7Rv0u87nczBYXp-ONxyERpligP0v_rC-G4AjPFKO3hXGp6-uflAnVNb83goWq8amn89g-FiZRjngfLg_SO1mAgZ8\x3dw640-h402', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': '\u53d1\u5e16\u8005'}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': '\u6807\u7b7e\uff1a'}]}], 'allBylineItems': [{'name': 'author', 'label': '\u53d1\u5e16\u8005'}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'share', 'label': ''}, {'name': 'labels', 'label': '\u6807\u7b7e\uff1a'}]}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts31', 'posts': [{'title': 'OpenClaw \u63a5\u5fae\u4fe1 ClawBot \u914d\u7f6e\u6307\u5357', 'id': 2515646992498400763}, {'title': '\u8be6\u89e3 Kiro CLI Session \u5b58\u50a8\u673a\u5236', 'id': 3620393762710754486}, {'title': 'OpenClaw Gateway \u5bf9\u63a5 Lark/\u98de\u4e66\u914d\u7f6e\u6307\u5357', 'id': 6293949410624443339}, {'title': 'Amazon Bedrock \u6a21\u578b\u8c03\u7528\u6307\u5357\uff1aMantle\u3001InvokeModel\u3001Converse \u4e09\u6761\u8def\u5f84\u8be6\u89e3', 'id': 5691884969487849687}, {'title': 'OpenClaw \u5b89\u5168\u6a21\u578b\u4e0e\u90e8\u7f72\u52a0\u56fa\u6307\u5357', 'id': 5674764548888878808}]}, {'title': 'Categories', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label31'}, {'title': 'Labels', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label32'}, {'title': 'Archive', 'type': 'BlogArchive', 'sectionId': 'sidebar-static', 'id': 'BlogArchive1'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML51'}]}]);
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header01', 'header-main', document.getElementById('Header01'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList01', 'header-main', document.getElementById('LinkList01'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList02', 'header-main', document.getElementById('LinkList02'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost12', 'before-blog', document.getElementById('FeaturedPost12'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog22', 'blog-post', document.getElementById('Blog22'), {'cmtInteractionsEnabled': false, 'navMessage': '\u663e\u793a\u6807\u7b7e\u4e3a\u201c\x3cb\x3e#Database\x3c/b\x3e\u201d\u7684\u535a\u6587\u3002\x3ca href\x3d\x22https://t.creast.win/\x22\x3e\u663e\u793a\u6240\u6709\u535a\u6587\x3c/a\x3e'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts31', 'sidebar-static', document.getElementById('PopularPosts31'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label31', 'sidebar-static', document.getElementById('Label31'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label32', 'sidebar-static', document.getElementById('Label32'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive1', 'sidebar-static', document.getElementById('BlogArchive1'), {'languageDirection': 'ltr', 'loadingMessage': '\u6b63\u5728\u52a0\u8f7d\u2026'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML51', 'copyright', document.getElementById('HTML51'), {}, 'displayModeFull'));
</script>
</body>*/</style>