Cov txheej txheem:

Kuv yuav ua li cas kom kuv RDS tuaj yeem siv tau rau pej xeem?
Kuv yuav ua li cas kom kuv RDS tuaj yeem siv tau rau pej xeem?

Video: Kuv yuav ua li cas kom kuv RDS tuaj yeem siv tau rau pej xeem?

Video: Kuv yuav ua li cas kom kuv RDS tuaj yeem siv tau rau pej xeem?
Video: Cas koj tsis yuav lwm xeem by Vong Media 2020-2021 2024, Kaum ib hlis
Anonim

Yog koj xav tau ua koj RDS piv as pej xeem siv tau , koj muaj txhawm rau pab kom VPC tus cwj pwm hauv DNS host thiab daws teeb meem. Koj tuaj yeem teeb tsa qhov no los ntawm kev siv tus parameter PubliclyAccessible uas yuav daws tau pej xeem IP chaw nyob. Nov yog los ntawm AWS documentation: Amazon RDS txhawb nqa ob lub VPC platforms: EC2-VPC thiab EC2-Classic.

Ib yam li ntawd ib tug yuav nug, Kuv yuav nkag mus rau RDS li cas hauv cov subnet ntiag tug?

Access an AWS RDS DB in a Private Subnet From MySQL Workbench

  1. Hauv MySQLWorkbench, nyem Txuas rau Database hauv Database ntawv qhia zaub mov.
  2. Raws li Txoj Kev Sib Txuas, xaiv Standard TCP/IP dhau SSH.
  3. Raws li SSH Hostname, ntaus IPv4 Public IP ntawm koj qhov piv txwv EC2.
  4. Raws li SSH Username, sau ec2-neeg siv.
  5. Raws li SSH Key File, ntaus txoj hauv kev rau koj EC2 cov ntaub ntawv tseem ceeb ntiag tug.

Tsis tas li ntawd, kuv yuav txuas rau RDS li cas? Txuas rau Amazon Relational Database Service (RDS)

  1. Tau txais lub hostname rau koj qhov piv txwv RDS los ntawm "Endpoint" teb hauv RDS dashboard, raws li qhia hauv qab no:
  2. Nkag mus rau lub runtime server console ntawm SSH.
  3. Siv cov cuab yeej mysql command-line txuas mus rau Amazon RDS database, raws li qhia hauv qab no.

Ib sab ntawm no, kuv yuav nkag mus rau RDS los ntawm lwm VPC li cas?

Yog koj xav ua tus RDS pawg nyob deb muaj, peb yuav tsum tau txuas ib qho IGW (Internet Gateway) rau hauv VPC . Yog tias koj tsis ua, nws tsis tuaj yeem sib txuas lus nrog lub ntiaj teb sab nraud. Ua li ntawd, mus rau VPC -> Internet gateways thiab ntaus "Tsim Internet Gateway": Thaum nws tau tsim, xaiv "Txuas rau VPC ”thiab xaiv koj VPC.

Tsis tuaj yeem txuas rau RDS MySQL?

Ua cov kauj ruam no:

  1. Mus rau EC2 Dashboard.
  2. Mus rau Security Groups tab.
  3. Xaiv thiab xaiv RDS database kev ruaj ntseg pab pawg nkaus xwb. Koj yuav pom cov lus qhia txog kev ruaj ntseg hauv qab.
  4. Nyem Inbound tab.
  5. Nyem Kho kom raug khawm.
  6. Ntxiv Hom: MYSQL/Aurora; Txheej Txheem: TCP; Ntau Yam: 3306; Source: 0.0. 0.0/0.

Pom zoo: