LabEx - Guide to Database Synchronization on Alibaba Cloud MySQL Server

How to Achieve Database Synchronization

For data disaster recovery, ETL, and remote data access purposes, you need to implement master-slave replication between RDS for MySQL instances and your own offline MySQL instances. This experiment describes how to configure master-slave replication and how it works to help you quickly get started with relevant configurations.

The course will be valid after purchased until you exceed the maximum number of use

[limit use]

Some of the lab environments are special, which will limit the use times. Yet you are free to view lab steps after running out of times.

Join Course for $ 5.00

Labs

Lab

How to Achieve Database Synchronization

Start Lab

Submit

Most recent comments

click 'start lab', get 404 response next.$content-divide$The tested ECS has an EIP address assigned, it may be a network problem, you can restart the experiment and try$content-divide$It should be that the RDS is still being created$content-divide$In the RDS, I can't "Create Account", the button is gray and can't click$content-divide$In my Achieve Database Synchronization , the ESC didn't have the EIP, no Internet IP address. How can I connect the RDS using the Internet IP Address ?$content-divide$Thank you for your feedback, we will refer to your suggestions to improve this experiment$content-divide$After database is sync to slave, there should be more guidance on further create the table and insert record, and examine how the data is sync over. Managed only to replicate database and table. When attempted to insert record and create second table, replication did not happen. Hope this can be added as part of the demo.$content-divide$complete successfully lab$content-divide$For data disaster recovery, ETL, and remote data access purposes, you need to implement master-slave replication between RDS for MySQL instances and your own offline MySQL instances. This experiment describes how to configure master-slave replication and how it works to help you quickly get started with relevant configurations.$content-divide$

{
              list: [
                
                {
                  id: 3625,
                  content: "",
                  author: {
                    id: "68948",
                    nickname: "AlibabaCloudSaTest",
                    avatar: "/upload/J/X/H/ELiu3scAhHjI.png",
                  },
                  created: "56 days ago",
                  replyText: "Reply",
                  
                  
                  
                },
                
                {
                  id: 3419,
                  content: "",
                  author: {
                    id: "1",
                    nickname: "LabEx-admin",
                    avatar: "/upload/L/S/I/kMchzfOhOqVk.png",
                  },
                  created: "2021-12-29",
                  replyText: "Reply",
                  
                  parent: {
                    id: 3409,
                    author: {
                      nickname: "labex798243",
                    },
                  },
                  
                  
                  
                },
                
                {
                  id: 3418,
                  content: "",
                  author: {
                    id: "1",
                    nickname: "LabEx-admin",
                    avatar: "/upload/L/S/I/kMchzfOhOqVk.png",
                  },
                  created: "2021-12-29",
                  replyText: "Reply",
                  
                  parent: {
                    id: 3410,
                    author: {
                      nickname: "labex798243",
                    },
                  },
                  
                  
                  
                },
                
                {
                  id: 3410,
                  content: "",
                  author: {
                    id: "62242",
                    nickname: "labex798243",
                    avatar: "/upload/H/S/G/2P1kjpMLerQD.png",
                  },
                  created: "2021-12-22",
                  replyText: "Reply",
                  
                  
                  
                },
                
                {
                  id: 3409,
                  content: "",
                  author: {
                    id: "62242",
                    nickname: "labex798243",
                    avatar: "/upload/H/S/G/2P1kjpMLerQD.png",
                  },
                  created: "2021-12-22",
                  replyText: "Reply",
                  
                  
                  
                },
                
                {
                  id: 2547,
                  content: "",
                  author: {
                    id: "1",
                    nickname: "LabEx-admin",
                    avatar: "/upload/L/S/I/kMchzfOhOqVk.png",
                  },
                  created: "2021-01-05",
                  replyText: "Reply",
                  
                  parent: {
                    id: 2545,
                    author: {
                      nickname: "chrisv",
                    },
                  },
                  
                  
                  
                },
                
                {
                  id: 2545,
                  content: "",
                  author: {
                    id: "48582",
                    nickname: "chrisv",
                    avatar: "/upload/G/K/L/wm47uZwS1jHr.png",
                  },
                  created: "2021-01-04",
                  replyText: "Reply",
                  
                  
                  
                },
                
                {
                  id: 1193,
                  content: "",
                  author: {
                    id: "23153",
                    nickname: "azwan sakri",
                    avatar: "/upload/D/F/Y/e0UnadJw5u7Q.png",
                  },
                  created: "2019-05-19",
                  replyText: "Reply",
                  
                  
                  
                },
                
                {
                  id: 444,
                  content: "",
                  author: {
                    id: "6624",
                    nickname: "labex101087",
                    avatar: "/upload/A/Q/F/7wpie7Q9BgxB.png",
                  },
                  created: "2018-06-25",
                  replyText: "Reply",
                  
                  
                  
                },
                
              ]
            }

Teacher

CloudAcademy

CloudAcademyis the Labex teacher.

How to Achieve Database Synchronization

Most recent comments

Feedback

Start new lab