Today the company machine room because of power failure several development machine disk damage. Operation and maintenance students told me that disk recovery is slow, if you are in a hurry, you can first apply for a new virtual machine to use. There is no way to all kinds of costumes, this is the second time, the heart is really galloping

I don’t know if the tuhao’s big factory uses one ECS per person.

Due to the first failure, the code was lost for several days. Now, no matter whether the function is finished or not, the code will be pushed to the warehouse first. If the warehouse is suspended, will the IT department of the company go to the top floor jump, jump?

Database is left, although there is a backup, but always reinstalled is also quite a waste of time, soon 618, see can go to the Internet search a cheaper ECS install mysql, although not reimbursed, but save their own time to touch fish not sweet yao.

Hesitate to place an order. XD next door rushed over and said that there was a free cloud database for the event, and he had the invitation code, so he could try it first, and ECS would not panic to buy. It’s free to try, but it looks like it’s from Postgres. I was using mysql before, so I had to sync up the data first. Using a kettle for data synchronization is a bit of an overkill. Need science students can see b stand this video, www.bilibili.com/video/BV1kE… If you don’t want to see it, I took some pictures below

Kettle is introduced

The directory, throw a network location address links here: pan.baidu.com/s/1hPxrJUFA… Extract code: D3LF

Once the download is complete, unzip it and click on Spoon.bat to start

Create a job, then click on the left “Main Object Tree” and configure “DB Connection”.

Configure the source database, my source database is Mysql, here fill in the corresponding parameters

Configure the target database. Log in to the console of the cloud database to obtain the database connection IP address and name, and set parameters to kettle

Click Tools > Wizard > Copy Multiple Tables Wizard and select the source and target databases

Select the table to replicate

Changing a Task name

Click “Finish” to complete the configuration

Click “Run” to start data replication. After the replication is complete, you can log in to the cloud Database console to view the data

Kettle has a variety of functions and is used by many big data companies for data integration. This migration is just a case in point.