Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Accessing RDS from local

Avatar for thanhgit thanhgit
May 03, 2022
Technology
0
85

Accessing RDS from local

Avatar for thanhgit

thanhgit

May 03, 2022
Tweet

More Decks by thanhgit

See All by thanhgit
Developer portal
Avatar for thanhgit thanhgit
0
72
AWS ECS fargate
Avatar for thanhgit thanhgit
0
110
AWS Lambda function
Avatar for thanhgit thanhgit
0
150
CICD from on-premise to cloud
Avatar for thanhgit thanhgit
0
150
Infra as Code (terraform)
Avatar for thanhgit thanhgit
0
110
Pritunl VPN Server
Avatar for thanhgit thanhgit
0
130
AuthN & AuthZ with distributed systems
Avatar for thanhgit thanhgit
0
150
Permission design
Avatar for thanhgit thanhgit
0
73
Blockchain - góc nhìn về kĩ thuật và ứng dụng
Avatar for thanhgit thanhgit
0
250

Other Decks in Technology

See All in Technology
非root化Androidスマホでも動く仮想マシンアプリを試してみた
Avatar for Sora Arakawa arkw
0
120
MCPを理解する
Avatar for Yudai Hayashi yudai00
14
9.9k
今日からはじめるプラットフォームエンジニアリング
Avatar for Kazuto Kusama jacopen
8
2k
AIによるコードレビューで開発体験を向上させよう！
Avatar for Atsushi Nakatsugawa moongift
PRO
0
410
続・やっぱり余白が大切だった話
Avatar for KAKEHASHI kakehashi
PRO
2
290
Асинхронная коммуникация в Go: от понятного к душному. Дима Некрасов, Otello, 2ГИС
Avatar for Lamoda Tech lamodatech
0
2k
Compose におけるパスワード自動入力とパスワード保存
Avatar for tonionagauzzi tonionagauzzi
0
210
クラウドネイティブ環境の脅威モデリング
Avatar for Kyohei Mizumoto kyohmizu
1
390
MCPが変えるAIとの協働
Avatar for 西岡 賢一郎 (Kenichiro Nishioka) knishioka
1
140
製造業向けIoTソリューション提案資料.pdf
Avatar for h.uriu haruki_uiru
0
220
Why Platform Engineering? - マルチプロダクト・少人数 SRE の壁を越える挑戦 -
Avatar for 株式会社ヌーラボ nulabinc
PRO
2
290
30代からでも遅くない！ 内製開発の世界に飛び込み、最前線で戦うLLMアプリ開発エンジニアになろう
Avatar for みのるん minorun365
PRO
16
5.1k

Featured

See All Featured
Fashionably flexible responsive web design (full day workshop)
Avatar for Andy Clarke malarkey
407
66k
Music & Morning Musume
Avatar for Bryan Veloso bryan
47
6.5k
Gamification - CAS2011
Avatar for David Bonilla davidbonilla
81
5.3k
How to Think Like a Performance Engineer
Avatar for Harry Roberts csswizardry
23
1.6k
Fight the Zombie Pattern Library - RWD Summit 2016
Avatar for Marcelo Somers marcelosomers
233
17k
Bash Introduction
Avatar for André Augusto Costa Santos 62gerente
612
210k
Become a Pro
Avatar for Speaker Deck speakerdeck
PRO
28
5.3k
GraphQLの誤解/rethinking-graphql
Avatar for sonatard sonatard
71
10k
Fireside Chat
Avatar for paigeccino paigeccino
37
3.4k
Art, The Web, and Tiny UX
Avatar for Lynn Fisher lynnandtonic
298
20k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
Avatar for Marc Duiker marcduiker
30
2k
How To Stay Up To Date on Web Technology
Avatar for Chris Coyier chriscoyier
790
250k

Transcript

  1. Cách truy cập RDS từ local By Thanh Nguyen

  2. Điều kiện - Có thể truy cập VPN công ty

    - Cài đặt một trình quản lý cơ sở dữ liệu. Ví dụ: + Mac và Windows: Sequel Pro, ... + Linux: Dbeaver, … - Workflow: Port forwarding từ local <-> bastion host <-> RDS in AWS + Để hiểu thì xem tutorial này: link

  3. Port forwarding ssh -i ~/.ssh/bastion_key.pem -NfC -L 7011:rds-name.cluster-xxx.region.rds.amazonaws.com:3306 ec2-user@IP-bastion-server

  4. Truy cập database với terminal mysql -h 127.0.0.1 -u db-user

    -D db-name -P 7011 -p

  5. Tạo một kết nối trong trình quản lý DB Chú

    ý: - server host: ? - port: ? - User/password: ?