{"id":23321,"date":"2022-12-22T11:13:15","date_gmt":"2022-12-22T02:13:15","guid":{"rendered":"https:\/\/www.skyarch.net\/blog\/?p=23321"},"modified":"2023-01-04T11:10:52","modified_gmt":"2023-01-04T02:10:52","slug":"aws-database-migration-service-aws-dms-%e3%81%ae-cdc-%e3%83%ac%e3%83%97%e3%83%aa%e3%82%b1%e3%83%bc%e3%82%b7%e3%83%a7%e3%83%b3%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%a6%e3%81%bf%e3%81%9f","status":"publish","type":"post","link":"https:\/\/www.skyarch.net\/blog\/aws-database-migration-service-aws-dms-%e3%81%ae-cdc-%e3%83%ac%e3%83%97%e3%83%aa%e3%82%b1%e3%83%bc%e3%82%b7%e3%83%a7%e3%83%b3%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%a6%e3%81%bf%e3%81%9f\/","title":{"rendered":"AWS Database Migration Service (AWS DMS) \u306e CDC \u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u4f7f\u3063\u3066\u307f\u305f"},"content":{"rendered":"<h2>\u306f\u3058\u3081\u306b<\/h2>\n<p>AWS Database Migration Service (AWS DMS) \u306e CDC \u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u6a5f\u80fd\u3092\u5229\u7528\u3057\u3066 EC2 MySQL \u304b\u3089 RDS MySQL \u3078\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u7d99\u7d9a\u7684\u306a\u79fb\u884c\u3092\u691c\u8a3c\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<h2>\u691c\u8a3c\u6e96\u5099<\/h2>\n<ul>\n<li>\u30bd\u30fc\u30b9\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f EC2 \u3092 Amazon Linux2 \u3067\u8d77\u52d5\u3057\u3001MySQL 8.0\u7cfb\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u7528\u610f\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">CDC \u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u5229\u7528\u3059\u308b\u5834\u5408\u3001\u30bd\u30fc\u30b9\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5074\u306e mysql \u30d1\u30e9\u30e1\u30fc\u30bf\u3068\u3057\u3066\u306f\u4e0b\u8a18\u8a2d\u5b9a\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n<p style=\"padding-left: 40px;\"><strong>server_id<\/strong> \u2192 1\u4ee5\u4e0a<br \/>\n<strong>log-bin<\/strong> \u2192 \u30d5\u30a1\u30a4\u30eb\u30d1\u30b9\u3092\u6307\u5b9a<br \/>\n<strong>binlog_format<\/strong> \u2192 ROW<br \/>\n<strong>expire_logs_days<\/strong> \u2192 1\u4ee5\u4e0a<br \/>\n<strong>binlog_checksum<\/strong> \u2192 NONE<br \/>\n<strong>binlog_row_image<\/strong> \u2192 FULL<\/p>\n<p style=\"padding-left: 40px;\">\u53c2\u8003 : https:\/\/docs.aws.amazon.com\/ja_jp\/dms\/latest\/userguide\/CHAP_Source.MySQL.html<\/p>\n<ul>\n<li>RDS MySQL \u306f MySQL 8.0\u7cfb\u3067\u8d77\u52d5\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/li>\n<li>\u30c7\u30fc\u30bf\u306e\u66f8\u304d\u8fbc\u307f\u306f mysqlslap \u3067\u5bfe\u5fdc\u3057\u307e\u3059\u3002<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">mysqlslap \u306f MySQL \u516c\u5f0f\u306e\u8ca0\u8377\u30a8\u30df\u30e5\u30ec\u30fc\u30b7\u30e7\u30f3\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3067\u3059\u3002<br \/>\nmysql-community-client-8.0 \u306e rpm \u30d1\u30c3\u30b1\u30fc\u30b8\u306b\u540c\u68b1\u3055\u308c\u3066\u3044\u307e\u3059\u3002<br \/>\nEC2\u5185\u3067\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u767a\u884c\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30c6\u30fc\u30d6\u30eb\u3001\u30e9\u30f3\u30c0\u30e0\u30c7\u30fc\u30bf\u3092\u4f5c\u6210\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<pre style=\"padding-left: 40px;\">mysqlslap \n  --no-defaults \n  --host=localhost \n  --engine=innodb \n  --create-schema=test_1 \n  --no-drop \n  --auto-generate-sql \n  --auto-generate-sql-guid-primary \n  --auto-generate-sql-load-type=write \n  --auto-generate-sql-write-number=100000 &amp;<\/pre>\n<p style=\"padding-left: 40px;\">test_1 \u3068\u3044\u3046\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u4f5c\u6210\u3055\u308c\u3001mysqlslap \u304c\u4f5c\u6210\u3059\u308b\u30c6\u30fc\u30d6\u30eb\u306b\u3001100000\u884c\u304c INSERT \u3055\u308c\u307e\u3059\u3002\u307e\u305f\u3001--no-drop \u3092\u6307\u5b9a\u3059\u308b\u4e8b\u3067\u3001\u8ca0\u8377\u30a8\u30df\u30e5\u30ec\u30fc\u30b7\u30e7\u30f3\u304c\u7d42\u4e86\u3057\u3066\u3082\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30c6\u30fc\u30d6\u30eb\u3001\u30c7\u30fc\u30bf\u3092\u4fdd\u6301\u3057\u307e\u3059\u3002<\/p>\n<p style=\"padding-left: 40px;\">\u53c2\u8003 : https:\/\/dev.mysql.com\/doc\/refman\/5.6\/ja\/mysqlslap.html<\/p>\n<ul>\n<li>DMS \u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4f5c\u6210<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">\u300c\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3002<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012208.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23356\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012208-300x146.png\" alt=\"\" width=\"631\" height=\"307\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012208-300x146.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012208-1024x499.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012208-768x374.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012208-1536x749.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012208-728x355.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012208.png 1920w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/a><br \/>\n\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u540d\u524d\u3092\u5165\u529b\u3059\u308b\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012525.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23364\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012525-300x81.png\" alt=\"\" width=\"630\" height=\"170\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012525-300x81.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012525-1024x277.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012525-768x208.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012525-1536x416.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012525-728x197.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-012525.png 1920w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\" \/><\/a><br \/>\n\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u30af\u30e9\u30b9\u3001\u30a8\u30f3\u30b8\u30f3\u30d0\u30fc\u30b8\u30e7\u30f3\u3001\u30de\u30eb\u30c1 AZ\u9805\u76ee\u3092\u305d\u308c\u305e\u308c\u9078\u629e\u3059\u308b\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-013254.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23365\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-013254-300x107.png\" alt=\"\" width=\"631\" height=\"225\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-013254-300x107.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-013254-1024x366.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-013254-768x275.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-013254-1536x550.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-013254-728x260.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-013254.png 1920w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/a><br \/>\nStorage \u30b5\u30a4\u30ba\u3092\u5165\u529b\u3002Network type\u3001VPC\u3001\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30b5\u30d6\u30cd\u30c3\u30c8\u30b0\u30eb\u30fc\u30d7\u3092\u9078\u629e\u3059\u308b\u3002<br \/>\nAdvanced settings\u3092\u958b\u304d\u3001\u30a2\u30d9\u30a4\u30e9\u30d3\u30ea\u30c6\u30a3\u30fc\u30be\u30fc\u30f3\u3001\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u30b0\u30eb\u30fc\u30d7\u3092\u9078\u629e\u3059\u308b\u3002<br \/>\n\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u3001\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u3001\u30bf\u30b0\u9805\u76ee\u3092\u5165\u529b\u3059\u308b\u3002\u6700\u5f8c\u306b\u300c\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3002<\/p>\n<ul>\n<li>DMS \u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306e\u4f5c\u6210 (\u30bd\u30fc\u30b9\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8)<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">\u300c\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306e\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015506.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23369\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015506-300x136.png\" alt=\"\" width=\"631\" height=\"286\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015506-300x136.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015506-1024x466.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015506-768x349.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015506-1536x698.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015506-728x331.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015506.png 1920w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/a><br \/>\n\u30bd\u30fc\u30b9\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3092\u9078\u629e\u3059\u308b\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015814.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23370\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015814-300x62.png\" alt=\"\" width=\"629\" height=\"130\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015814-300x62.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015814-1024x210.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015814-768x158.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015814-1536x315.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015814-728x149.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-015814.png 1920w\" sizes=\"auto, (max-width: 629px) 100vw, 629px\" \/><\/a><br \/>\n\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u8b58\u5225\u5b50\u3001\u30bd\u30fc\u30b9\u30a8\u30f3\u30b8\u30f3\u3092\u5165\u529b\u3059\u308b\u3002<br \/>\n\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u30a2\u30af\u30bb\u30b9\u306f\u4eca\u56de\u9069\u5207\u306a\u5024\u3092\u624b\u52d5\u3067\u5165\u529b\u3059\u308b\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-020820.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23371\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-020820-300x130.png\" alt=\"\" width=\"630\" height=\"273\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-020820-300x130.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-020820-1024x443.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-020820-768x332.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-020820-1536x664.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-020820-728x315.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-020820.png 1919w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\" \/><\/a><br \/>\nVPC\u3001\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u9078\u629e\u3057\u3001\u300c\u30c6\u30b9\u30c8\u306e\u5b9f\u884c\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3002<br \/>\n\u30b9\u30c6\u30fc\u30bf\u30b9\u304c successful \u3068\u306a\u3063\u305f\u4e8b\u3092\u78ba\u8a8d\u3057\u3001\u300c\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306e\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3002<\/p>\n<ul>\n<li>DMS \u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306e\u4f5c\u6210 (\u30bf\u30fc\u30b2\u30c3\u30c8\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8)<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">\u30bf\u30fc\u30b2\u30c3\u30c8\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u3092\u9078\u629e\u3059\u308b\u3002\u300cRDS DB \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u9078\u629e\u300d\u306b\u30c1\u30a7\u30c3\u30af\u3092\u3059\u308b\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024116.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23372\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024116-300x76.png\" alt=\"\" width=\"632\" height=\"160\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024116-300x76.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024116-1024x261.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024116-768x196.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024116-1536x392.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024116-728x186.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024116.png 1918w\" sizes=\"auto, (max-width: 632px) 100vw, 632px\" \/><\/a><br \/>\n\u300cRDS DB \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u9078\u629e\u300d\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u305f\u5834\u5408\u3001\u3042\u308b\u7a0b\u5ea6\u5165\u529b\u304c\u7701\u304b\u308c\u308b\u304c\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u306a\u3069\u306f\u5165\u529b\u304c\u5fc5\u8981\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024256.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23373\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024256-300x129.png\" alt=\"\" width=\"630\" height=\"271\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024256-300x129.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024256-1024x441.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024256-768x331.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024256-1536x661.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024256-728x314.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-024256.png 1918w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\" \/><\/a><br \/>\nVPC\u3001\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u9078\u629e\u3057\u3001\u300c\u30c6\u30b9\u30c8\u306e\u5b9f\u884c\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3002<br \/>\n\u30b9\u30c6\u30fc\u30bf\u30b9\u304c successful \u3068\u306a\u3063\u305f\u4e8b\u3092\u78ba\u8a8d\u3057\u3001\u300c\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8\u306e\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3002<\/p>\n<ul>\n<li>\u30c7\u30fc\u30bf\u79fb\u884c\u30bf\u30b9\u30af\u306e\u4f5c\u6210<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">\u300c\u30c7\u30fc\u30bf\u79fb\u884c\u30bf\u30b9\u30af\u306e\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-025942.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23374\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-025942-300x137.png\" alt=\"\" width=\"631\" height=\"288\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-025942-300x137.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-025942-1024x466.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-025942-768x350.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-025942-1536x699.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-025942-728x331.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-025942.png 1918w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/a><br \/>\n\u30bf\u30b9\u30af\u8b58\u5225\u5b50\u3001\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u5165\u529b\u3001\u9078\u629e\u3059\u308b\u3002<br \/>\n\u79fb\u884c\u30bf\u30a4\u30d7\u304b\u3089\u300c\u65e2\u5b58\u306e\u30c7\u30fc\u30bf\u3092\u79fb\u884c\u3057\u3066\u3001\u7d99\u7d9a\u7684\u306a\u5909\u66f4\u3092\u30ec\u30d7\u30ea\u30b1\u30fc\u30c8\u3059\u308b\u300d\u3092\u9078\u629e\u3059\u308b\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030311.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23376\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030311-300x48.png\" alt=\"\" width=\"631\" height=\"101\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030311-300x48.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030311-1024x162.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030311-768x122.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030311-1536x243.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030311-728x115.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030311.png 1918w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/a><br \/>\n\u7de8\u96c6\u30e2\u30fc\u30c9\u306f\u300c\u30a6\u30a3\u30b6\u30fc\u30c9\u300d\u3092\u9078\u629e\u3059\u308b\u3002<br \/>\n\u300c\u30bd\u30fc\u30b9\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u30ab\u30b9\u30bf\u30e0 CDC \u505c\u6b62\u30e2\u30fc\u30c9\u300d\u2192\u300c\u30ab\u30b9\u30bf\u30e0 CDC \u505c\u6b62\u30e2\u30fc\u30c9\u3092\u7121\u52b9\u306b\u3059\u308b\u300d<br \/>\n\u300c\u30bf\u30fc\u30b2\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u6e96\u5099\u30e2\u30fc\u30c9\u300d\u2192\u300c\u4f55\u3082\u3057\u306a\u3044\u300d<br \/>\n\u300c\u30d5\u30eb\u30ed\u30fc\u30c9\u306e\u5b8c\u4e86\u5f8c\u306b\u30bf\u30b9\u30af\u3092\u505c\u6b62\u3059\u308b\u300d\u2192\u300c\u505c\u6b62\u3057\u306a\u3044\u300d<br \/>\n\u300c\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b LOB \u5217\u3092\u542b\u3081\u308b\u300d\u2192\u300c\u5236\u9650\u4ed8\u304d LOB \u30e2\u30fc\u30c9\u300d<br \/>\n\u300c\u6700\u5927 LOB \u30b5\u30a4\u30ba (KB)\u300d\u2192\u300c32\u300d<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030603.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23377\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030603-300x121.png\" alt=\"\" width=\"630\" height=\"254\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030603-300x121.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030603-1024x414.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030603-768x310.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030603-1536x621.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030603-728x294.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-030603.png 1920w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\" \/><\/a><br \/>\n\u30c6\u30fc\u30d6\u30eb\u30de\u30c3\u30d4\u30f3\u30b0\u306e\u7de8\u96c6\u30e2\u30fc\u30c9\u306f\u300c\u30a6\u30a3\u30b6\u30fc\u30c9\u300d\u3092\u9078\u629e\u3059\u308b\u3002<br \/>\n\u9078\u629e\u30eb\u30fc\u30eb\u3067\u306f\u9069\u5207\u306a\u30eb\u30fc\u30eb\u3092\u8a2d\u5b9a\u3059\u308b\u3002\u4e0b\u8a18\u4f8b\u3067\u306f\u3001\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u306b <code>test_<\/code> \u3068\u4ed8\u304f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u307f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u884c\u3046\u8a2d\u5b9a\u3067\u3059\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031253.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23379\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031253-300x129.png\" alt=\"\" width=\"633\" height=\"272\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031253-300x129.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031253-1024x440.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031253-768x330.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031253-1536x660.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031253-728x313.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031253.png 1918w\" sizes=\"auto, (max-width: 633px) 100vw, 633px\" \/><\/a><br \/>\n\u79fb\u884c\u30bf\u30b9\u30af\u306e\u30b9\u30bf\u30fc\u30c8\u30a2\u30c3\u30d7\u8a2d\u5b9a\u3067\u300c\u5f8c\u3067\u624b\u52d5\u3067\u884c\u3046\u300d\u3092\u9078\u629e\u3057\u3001\u300c\u30bf\u30b9\u30af\u306e\u4f5c\u6210\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031533.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23380\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031533-300x84.png\" alt=\"\" width=\"632\" height=\"177\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031533-300x84.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031533-1024x285.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031533-768x214.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031533-1536x428.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031533-728x203.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031533.png 1920w\" sizes=\"auto, (max-width: 632px) 100vw, 632px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2>\u691c\u8a3c<\/h2>\n<ul>\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u79fb\u884c\u306e\u958b\u59cb (\u30d5\u30eb\u30ed\u30fc\u30c9)<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u79fb\u884c\u30bf\u30b9\u30af\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u304c\u300c\u6e96\u5099\u5b8c\u4e86\u300d\u3068\u306a\u308b\u4e8b\u3092\u78ba\u8a8d\u3059\u308b\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031754.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23382\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031754-300x54.png\" alt=\"\" width=\"633\" height=\"114\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031754-300x54.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031754-1024x184.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031754-768x138.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031754-1536x275.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031754-728x131.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031754.png 1919w\" sizes=\"auto, (max-width: 633px) 100vw, 633px\" \/><\/a><br \/>\n\u5bfe\u8c61\u306e\u30bf\u30b9\u30af\u3092\u9078\u629e\u3057\u3001\u300c\u30a2\u30af\u30b7\u30e7\u30f3\u300d\u304b\u3089\u300c\u518d\u8d77\u52d5\/\u518d\u958b\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031931.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23383\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031931-300x51.png\" alt=\"\" width=\"629\" height=\"107\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031931-300x51.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031931-1024x172.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031931-768x129.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031931-1536x259.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031931-728x123.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-031931.png 1918w\" sizes=\"auto, (max-width: 629px) 100vw, 629px\" \/><\/a><br \/>\n\u5bfe\u8c61\u306e\u30bf\u30b9\u30af\u306e\u30b9\u30c6\u30fc\u30bf\u30b9\u304c\u300c\u30ed\u30fc\u30c9\u5b8c\u4e86\u3001\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u9032\u884c\u4e2d\u300d\u3068\u306a\u308c\u3070\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u6210\u529f\u3068\u306a\u308b\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-032111.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23384\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-032111-300x52.png\" alt=\"\" width=\"629\" height=\"109\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-032111-300x52.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-032111-1024x178.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-032111-768x133.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-032111-1536x267.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-032111-728x126.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-20221221-032111.png 1919w\" sizes=\"auto, (max-width: 629px) 100vw, 629px\" \/><\/a><br \/>\n\u30bd\u30fc\u30b9\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30bf\u30fc\u30b2\u30c3\u30c8\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u540c\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066 CHECKSUM TABLE \u6587\u3092\u767a\u884c\u3057\u3066\u5dee\u5206\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n<pre>[root@replication ~]# mysql -e 'CHECKSUM TABLE test_1.t1;'\n+-----------+-----------+\n| Table     | Checksum  |\n+-----------+-----------+\n| test_1.t1 | 275846867 |\n+-----------+-----------+\n[root@replication ~]# mysql -u admin -h xxxxx.yyyy.ap-northeast-1.rds.amazonaws.com -e 'CHECKSUM TABLE test_1.t1;'\n+-----------+-----------+\n| Table     | Checksum  |\n+-----------+-----------+\n| test_1.t1 | 275846867 |\n+-----------+-----------+\n[root@replication ~]#<\/pre>\n<p style=\"padding-left: 40px;\">Checksum \u306e\u5024\u304c\u540c\u3058\u3067\u3042\u308b\u70ba\u3001\u6b63\u5e38\u306b\u79fb\u884c\u3067\u304d\u305f\u4e8b\u304c\u308f\u304b\u308a\u307e\u3057\u305f\u3002<\/p>\n<ul>\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u79fb\u884c\u306e\u958b\u59cb (<span style=\"color: #ff0000;\">CDC \u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3<\/span>)<\/li>\n<\/ul>\n<p style=\"padding-left: 40px;\">\u3053\u3053\u304b\u3089\u304c\u672c\u756a\u3067\u3059\u3002\u30d5\u30eb\u30ed\u30fc\u30c9\u304c\u7d42\u4e86\u3057\u305f\u72b6\u614b\u3067\u3001\u30bd\u30fc\u30b9\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u66f4\u65b0\u3092\u304b\u3051\u3066\u884c\u304d\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<br \/>\n\u518d\u5ea6\u3001mysqlslap \u3067\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u767a\u884c\u3057\u307e\u3059\u3002<\/p>\n<pre>mysqlslap \n--no-defaults \n--host=localhost \n--engine=innodb \n--create-schema=test_2 \n--no-drop \n--auto-generate-sql \n--auto-generate-sql-guid-primary \n--auto-generate-sql-load-type=write \n--auto-generate-sql-write-number=100000 &amp;<\/pre>\n<p style=\"padding-left: 40px;\">mysqlslap \u306e\u4ed5\u69d8\u4e0a\u3001\u65e2\u5b58\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u66f4\u65b0\u3092\u304b\u3051\u308b\u4e8b\u304c\u3067\u304d\u307e\u305b\u3093\u3002\u305d\u3053\u3067\u5225\u540d\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u5b9a\u7fa9\u3057\u3001\u521d\u56de\u3068\u540c\u69d8\u306e\u30ec\u30b3\u30fc\u30c9\u6570\u3092 INSERT \u3057\u3066\u307f\u307e\u3059\u3002<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23388\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-14-300x100.png\" alt=\"\" width=\"633\" height=\"211\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-14-300x100.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-14-1024x342.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-14-768x257.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-14-1536x513.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-14-728x243.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-14.png 1919w\" sizes=\"auto, (max-width: 633px) 100vw, 633px\" \/><\/a><br \/>\n\u65b0\u305f\u306b test_2 \u3068\u3044\u3046\u30b9\u30ad\u30fc\u30de\u304c\u8ffd\u52a0\u3055\u308c\u305f\u4e8b\u304c\u308f\u304b\u308a\u307e\u3059\u3002\u8ffd\u52a0\u3055\u308c\u305f\u3068\u540c\u6642\u306b\u3001\u633f\u5165\u6570\u3082\u4e0a\u6607\u3057\u3066\u3044\u308b\u4e8b\u304c\u308f\u304b\u308a\u307e\u3059\u3002\u3046\u307e\u304f CDC \u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u304c\u52d5\u3044\u3066\u3044\u307e\u3059\u306d\u3002<br \/>\n<a href=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-15.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-23392\" src=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-15-300x117.png\" alt=\"\" width=\"631\" height=\"246\" srcset=\"https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-15-300x117.png 300w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-15-1024x399.png 1024w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-15-768x299.png 768w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-15-1536x599.png 1536w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-15-728x284.png 728w, https:\/\/www.skyarch.net\/blog\/wp-content\/uploads\/2022\/12\/image-15.png 1919w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/a><br \/>\nCDC \u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u4e2d\u306f\u300cCloudWatch\u30e1\u30c8\u30ea\u30af\u30b9\u300d\u30bf\u30d6\u304b\u3089 CDC \u95a2\u9023\u306e\u8ca0\u8377\u72b6\u6cc1\u3092\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002\u30bd\u30fc\u30b9\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u7a3c\u50cd\u3059\u308b EC2 \u306e\u30ea\u30bd\u30fc\u30b9\u72b6\u6cc1\u3084\u3001\u30bf\u30fc\u30b2\u30c3\u30c8\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3042\u308b RDS \u306e\u30ea\u30bd\u30fc\u30b9\u72b6\u6cc1\u3082\u5225\u9014 CloudWatch\u30e1\u30c8\u30ea\u30af\u30b9\u3067\u78ba\u8a8d\u3057\u3066\u304a\u304d\u305f\u3044\u3067\u3059\u306d\u3002<\/p>\n<p style=\"padding-left: 40px;\">\u30d5\u30eb\u30ed\u30fc\u30c9\u6642\u3068\u540c\u69d8\u306b\u3001\u30bd\u30fc\u30b9\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3068\u30bf\u30fc\u30b2\u30c3\u30c8\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u540c\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066 CHECKSUM TABLE \u6587\u3092\u767a\u884c\u3057\u3066\u5dee\u5206\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n<pre>[root@replication ~]# mysql -e 'CHECKSUM TABLE test_2.t1;' \n+-----------+------------+\n| Table     | Checksum   |\n+-----------+------------+\n| test_2.t1 | 3170474354 |\n+-----------+------------+\n[root@replication ~]# mysql -u admin -h xxxxx.yyyy.ap-northeast-1.rds.amazonaws.com -e 'CHECKSUM TABLE test_2.t1;'  \n+-----------+------------+\n| Table     | Checksum   |\n+-----------+------------+\n| test_2.t1 | 3170474354 |\n+-----------+------------+\n[root@replication ~]#<\/pre>\n<p style=\"padding-left: 40px;\">CDC \u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306b\u304a\u3044\u3066\u3082\u3001Checksum \u306e\u5024\u304c\u540c\u3058\u3067\u3042\u308b\u70ba\u3001\u6b63\u5e38\u306b\u79fb\u884c\u3067\u304d\u305f\u4e8b\u304c\u308f\u304b\u308a\u307e\u3057\u305f\u3002<\/p>\n<h2>\u307e\u3068\u3081<\/h2>\n<p>AWS DMS \u306f2016\u5e74\u9803\u306bGA\u3055\u308c\u305f\u30b5\u30fc\u30d3\u30b9\u3068\u306a\u308a\u3001\u73fe\u5728\u306b\u81f3\u308b\u307e\u3067\u69d8\u3005\u306a\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u304c\u8d70\u3063\u3066\u307e\u3059\u3002UI\u306a\u3069\u3082\u524d\u3068\u6bd4\u3079\u3066\u3068\u3066\u3082\u4f7f\u3044\u3084\u3059\u304f\u306a\u3063\u3066\u3044\u307e\u3059\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u79fb\u884c\u306b\u7279\u5316\u3057\u305f\u79fb\u884c\u30c4\u30fc\u30eb\u3068\u3057\u3066\u3001\u30de\u30a4\u30b0\u30ec\u30fc\u30b7\u30e7\u30f3\u8a08\u753b\u306b\u6b20\u304b\u305b\u306a\u3044\u30b5\u30fc\u30d3\u30b9\u3060\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n<p>\u307e\u305f\u3001\u4eca\u56de\u691c\u8a3c\u3057\u305f AWS DMS \u306e CDC \u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u6a5f\u80fd\u3092\u4f7f\u3046\u4e8b\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u79fb\u884c\u306b\u4f34\u3046\u30b5\u30fc\u30d3\u30b9\u65ad\u3092\u6700\u5c0f\u9650\u306b\u3059\u308b\u4e8b\u304c\u3067\u304d\u307e\u3059\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u79fb\u884c\u3092\u3054\u691c\u8a0e\u306e\u65b9\u306f\u662f\u975e\u3054\u76f8\u8ac7\u304f\u3060\u3055\u3044\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u306f\u3058\u3081\u306b AWS Database Migration Service (AWS DMS) \u306e CDC \u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u6a5f\u80fd\u3092\u5229\u7528\u3057\u3066 EC2 MySQL \u304b\u3089 RDS MySQL \u3078\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u7d99\u7d9a\u7684\u306a\u79fb\u884c\u3092\u691c\u8a3c\u3057\u3066&#8230;<\/p>\n","protected":false},"author":16,"featured_media":23431,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_locale":"ja","_original_post":"https:\/\/www.skyarch.net\/blog\/?p=23321","footnotes":""},"categories":[20,1194],"tags":[],"class_list":{"0":"post-23321","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-aws","8":"category-dms","9":"ja"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/23321","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/comments?post=23321"}],"version-history":[{"count":24,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/23321\/revisions"}],"predecessor-version":[{"id":23646,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/23321\/revisions\/23646"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/media\/23431"}],"wp:attachment":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/media?parent=23321"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/categories?post=23321"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/tags?post=23321"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}