Cov txheej txheem:

Kuv yuav migrate Postgres database rau AWS li cas?
Kuv yuav migrate Postgres database rau AWS li cas?

Video: Kuv yuav migrate Postgres database rau AWS li cas?

Video: Kuv yuav migrate Postgres database rau AWS li cas?
Video: koj yuav tau kuv txhaum by zoo xyooj nkauj tshiab ~ MV 2024, Lub peb hlis ntuj
Anonim

Importing PostgreSQL Database los ntawm Amazon EC2 Piv txwv

  1. Tsim cov ntaub ntawv siv pg_dump uas muaj cov ntaub ntawv yuav tsum tau thauj khoom.
  2. Tsim lub hom phiaj DB piv txwv.
  3. Siv psql los tsim cov ntaub ntawv ntawm DB piv txwv thiab thauj cov ntaub ntawv.
  4. Tsim DB snapshot ntawm DB piv txwv.

Ua li no, kuv yuav import cov ntaub ntawv rau hauv Amazon RDS li cas?

Thaum twg import cov ntaub ntawv rau hauv piv txwv MariaDB DB, koj tuaj yeem siv MariaDB cov cuab yeej xws li mysqldump, mysql, thiab cov qauv luam tawm rau import cov ntaub ntawv rau Amazon RDS . Importing cov ntaub ntawv rau hauv PostgreSQL rau Amazon RDS - Koj tuaj yeem siv PostgreSQL cov cuab yeej xws li pg_dump, psql, thiab cov ntawv luam rau import cov ntaub ntawv rau Amazon RDS.

Kuv yuav hloov cov ntaub ntawv ntawm s3 rau RDS li cas? 4 Teb

  1. Nruab awscli ntawm koj lub thawv EC2 (nws yuav raug ntsia los ntawm lub neej ntawd)
  2. Configure koj awscli nrog daim ntawv pov thawj.
  3. Siv aws s3 sync los yog aws s3 cp commands mus download tau los ntawm s3 mus rau koj lub zos directory.
  4. Siv cov lus txib psql los theej cov ntaub ntawv rau hauv koj lub RDS (yuav tsum luam tawm ntawm cov neeg siv khoom)

Kuj nug, kuv yuav txuas mus rau AWS RDS Postgres li cas?

  1. Kauj ruam 1: Nkag mus rau RDS Console. Thaum koj nyem qhov no, AWS tswj console yuav qhib rau hauv lub qhov rais browser tshiab, yog li koj tuaj yeem khaws cov lus qhia ib kauj ruam dhau los qhib.
  2. Kauj ruam 2: Tsim PostgreSQL DB Instance.
  3. Kauj ruam 3: Download tau SQL Client.
  4. Kauj ruam 4: Txuas rau PostgreSQL Database.
  5. Kauj ruam 5: Rho tawm DB Instance.

Yuav ua li cas kuv migrate SQL database rau AWS?

Rau tsiv teb tsaws koj SQL database rau Amazon RDS siv SQL ntawv Azure Kev tsiv teb tsaws chaw Wizard, ua raws cov kauj ruam yooj yim no. Download tau SQL ntawv Azure Kev tsiv teb tsaws chaw Wizard ntawm CodePlex. Tom ntej no, koj yuav tsum rho tawm cov ntaub ntawv SQLAzureMW.exe. Koj tuaj yeem siv tau SQL ntawv Server Management Studio rau txuas koj lub zos SQL ntawv server thiab Amazon Web Service RDS piv txwv.

Pom zoo: