不同RDS实例间的数据迁移

<p>使用数据传输服务DTS可以实现平安云上不同RDS实例间的数据迁移。本文以将某RDS-MySQL实例下名为testmysql的数据库数据迁移到另一RDS-MySQL实例为例说明。</p> <p><span style="font-size:18px"><strong>前提条件</strong></span></p> <ul> <li>您已成功在目标RDS-MySQL实例上创建名为testmysql数据库。目标RDS-MySQL实例需包含与源RDS-MySQL实例中待迁移数据库名称相同的数据库。</li> <li>您已成功在源RDS-MySQL实例和目标RDS-MySQL实例上创建用户并授权用户账号对testmysql数据库的读写权限,可参考<a href="https://www.pinganyun.com/ssr/help/database/RDS/Getting_Started.RDS_MySQL.Create_User" target="_blank">创建用户</a>和<a href="https://www.pinganyun.com/ssr/help/database/RDS/Getting_Started.RDS_MySQL.Binding_Account" target="_blank">授权账号与数据库权限</a>。</li> </ul> <p><span style="font-size:18px"><strong>操作步骤</strong></span></p> <p>1.&nbsp;&nbsp; 创建迁移任务。</p> <p>&nbsp; &nbsp; &nbsp;a)&nbsp;&nbsp; 登录<a href="https://pinganyun.com/console/dts/overview" target="_blank">数据传输服务DTS管理控制台</a>。</p> <p>&nbsp; &nbsp; &nbsp;b)&nbsp;&nbsp; 单击左侧导航栏的<strong>迁移任务</strong>。</p> <p>&nbsp; &nbsp; &nbsp;c)&nbsp;&nbsp; 在<strong>迁移任务管理</strong>页面,单击页面右上角<strong>创建</strong>。</p> <p>2.&nbsp;&nbsp; 在<strong>创建迁移任务</strong>页面,配置<strong>源库信息</strong>及<strong>目标库信息</strong>。</p> <p>&nbsp; &nbsp; &nbsp; a)&nbsp;&nbsp; 填写源库及目标库的相关信息。</p> <p>&nbsp;&nbsp; &nbsp; &nbsp;&bull;&nbsp;&nbsp;&nbsp;<strong>实例类型</strong>:均选择RDS实例。</p> <p>&nbsp;&nbsp; &nbsp; &nbsp;&bull;&nbsp;&nbsp;&nbsp;<strong>实例地区</strong>:选择源库和目标库实例所在的地域。</p> <p>&nbsp;&nbsp; &nbsp; &nbsp;&bull;&nbsp;&nbsp;&nbsp;<strong>RDS实例ID</strong>: 选择源库和目标库实例的ID。</p> <p>&nbsp;&nbsp; &nbsp; &nbsp;&bull;&nbsp;&nbsp;&nbsp;<strong>数据库库名</strong>:RDS-MySQL不需要输入。</p> <p>&nbsp;&nbsp; &nbsp; &nbsp;&bull;&nbsp;&nbsp;&nbsp;<strong>数据库账号</strong>:填写源数据库及目标数据库的账号名称。</p> <p>&nbsp;&nbsp; &nbsp; &nbsp;&bull;&nbsp;&nbsp;&nbsp;<strong>数据库密码</strong>:填写源数据库及目标数据库账号所对应的密码。</p> <p>&nbsp; &nbsp; &nbsp;&nbsp;<img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20200209172227-128a1d4993c9.png" style="height:392px; width:750px" /></p> <p>&nbsp; &nbsp; &nbsp; b)&nbsp;&nbsp; 单击<strong>开通白名单</strong>,允许DTS访问源实例及目标实例。</p> <p>&nbsp; &nbsp; &nbsp;&nbsp;<img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20200209172317-1ce158fd9010.png" style="height:397px; width:750px" /></p> <p>&nbsp; &nbsp; &nbsp; c)&nbsp;&nbsp; 单击<strong>测试连接</strong>,测试与源数据库及目标数据库的连通性。</p> <p>&nbsp; &nbsp; &nbsp;&nbsp;<img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20200209172411-14068bbd95cb.png" style="height:398px; width:750px" /></p> <p>&nbsp; &nbsp; &nbsp; d)&nbsp;&nbsp; 测试连接成功后,单击<strong>下一步</strong>。</p> <p>3.&nbsp;&nbsp; 配置<strong>迁移类型</strong>和<strong>迁移对象</strong>。</p> <p>&nbsp; &nbsp; &nbsp; a)&nbsp;&nbsp; 根据实际情况选择<strong>迁移类型</strong>,本文以<strong>结构迁移</strong>+<strong>全量迁移</strong>为例。</p> <p>&nbsp;&nbsp; &nbsp; &nbsp;&bull;&nbsp;&nbsp;&nbsp;若目标数据库为空,迁移类型需要包括<strong>结构迁移。</strong></p> <p>&nbsp;&nbsp; &nbsp; &nbsp;&bull;&nbsp;&nbsp;&nbsp;不停服迁移,迁移类型请选择:<strong>结构迁移</strong>+<strong>全量迁移</strong>+<strong>增量迁移</strong>。</p> <p>&nbsp;&nbsp; &nbsp; &nbsp;&bull;&nbsp;&nbsp;&nbsp;仅需要进行增量迁移,迁移类型选择<strong>增量迁移</strong>。</p> <p>&nbsp; &nbsp; &nbsp;&nbsp;<img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20200209172510-1b83fd5a9aa9.png" style="height:403px; width:750px" /></p> <p>&nbsp; &nbsp; &nbsp; b)&nbsp;&nbsp; 勾选<strong>迁移对象</strong>,单击<img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20200209172532-1b5a33f09ce2.png" style="height:18px; margin:0px; width:20px" />,将其添加到<strong>已选择对象</strong>区域。</p> <p>&nbsp; &nbsp; &nbsp;&nbsp;<img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20200209172613-1350c04c9ab9.png" style="height:407px; width:750px" /></p> <p>4.&nbsp;&nbsp; 预检查。</p> <p>&nbsp; &nbsp; &nbsp; a)&nbsp;&nbsp; 单击<strong>预检查并启动</strong>,进入<strong>预检测</strong>页面。系统将针对各检查项目进行预检查。若检查结果为失败,请修改配置后重新进行预检查,直到100%检查通过。</p> <p>&nbsp; &nbsp; &nbsp;&nbsp;<img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20200209172646-15014d1f9462.png" style="height:394px; width:750px" /></p> <p>&nbsp; &nbsp; &nbsp; b)&nbsp;&nbsp; 单击<strong>下一步</strong>,进入<strong>迁移配置</strong>页面。</p> <p>5.&nbsp;&nbsp; 配置迁移链路规格。</p> <p>&nbsp; &nbsp; &nbsp; a)&nbsp;&nbsp; 在<strong>购买配置确认</strong>区域,选择<strong>迁移链路规格</strong>,可参考<a href="https://www.pinganyun.com/ssr/help/database/DTS/DtsProductProfile.5d71d01017bbc82d1477b70c" target="_blank">数据迁移链路规格</a>。</p> <p>&nbsp; &nbsp; &nbsp;&nbsp;<img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20200209172707-1599d2379375.png" style="height:364px; width:425px" /></p> <p>&nbsp; &nbsp; &nbsp; b)&nbsp;&nbsp; 单击<strong>购买并开通</strong>,进入<strong>订单确认</strong>页面,确认DTS相关信息。</p> <p>6.&nbsp;&nbsp; 单击<strong>确认开通</strong>后即可开启迁移任务。在<strong>迁移任务管理</strong>页面,通过任务<strong>状态</strong>栏可以查看迁移进度。</p> <p><img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20200209172726-16c79e4c9c2e.png" style="height:65px; width:830px" /></p>
以上内容是否解决了您的问题?
请补全提交信息!
咨询·建议

电话咨询

400-151-8800

邮件咨询

cloud@pingan.com

在线客服

工单支持

解决云产品相关技术问题