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

Accessing RDS from local

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for thanhgit thanhgit
May 03, 2022
Technology
110
0

Accessing RDS from local

Avatar for thanhgit

thanhgit

May 03, 2022

More Decks by thanhgit

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

Other Decks in Technology

See All in Technology
Oracle Base Database Service 技術詳細
Avatar for oracle4engineer oracle4engineer
PRO
15
100k
エンタープライズの厳格な制約を開発者に意識させない：クラウドネイティブ開発基盤設計/cloudnative-kaigi-golden-path
Avatar for みずほリサーチ&テクノロジーズ株式会社 先端技術研究部 mhrtech
0
360
Modernizing Your HCL Connections Experience: Visual Report to chain, Profile Enhancements, and AI Integration
Avatar for Wannes Rams wannesrams
0
290
「QA＝テスト」「シフトレフト＝スクラムイベントの参加者の一員」の呪縛を解く。アジャイルな開発を止めないために、10Xで挑んだ「右側のしわ寄せ」解消記 #scrumniigata
Avatar for nihonbuson nihonbuson
PRO
3
930
Agent Skillsで実現する記憶領域の運用とその後
Avatar for yamadashy / やまだし yamadashy
2
1.5k
要件定義の精度を高めるための型と生成AIの活用 / Using Types and Generative AI to Improve the Accuracy of Requirements Definition
Avatar for haru860 haru860
0
310
[Scram Fest Niigata2026]Quality as Code〜AIにQAの思考を再現させる試み〜
Avatar for Masami Yajiri masamiyajiri
1
290
毎日の作業を Claude Code 経由にしたら、 ノウハウがコードになった
Avatar for Hajime KOSHIRO kossykinto
1
1.1k
巨大プラットフォームを進化させる「第3のROI」
Avatar for Recruit recruitengineers
PRO
2
2.5k
OWASP APTSを眺めてみた
Avatar for su3158 su3158
0
130
フロントエンドの相手が変わった - AIが加わったWebの新しいインターフェース設計
Avatar for azukiazusa azukiazusa1
33
11k
AIが自律的に働く時代へ Amazon Quick で実現するAIエージェント紹介
Avatar for こーへい koheiyoshikawa
0
190

Featured

See All Featured
Docker and Python
Avatar for Tania Allard trallard
47
3.8k
A Tale of Four Properties
Avatar for Chris Coyier chriscoyier
163
24k
Information Architects: The Missing Link in Design Systems
Avatar for Michelle Chin soysaucechin
0
910
Hiding What from Whom? A Critical Review of the History of Programming languages for Music
Avatar for Tomoya Matsuura tomoyanonymous
2
800
How to Think Like a Performance Engineer
Avatar for Harry Roberts csswizardry
28
2.6k
Being A Developer After 40
Avatar for Adrian Kosmaczewski akosma
91
590k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
Avatar for Chris Coyier chriscoyier
508
140k
The World Runs on Bad Software
Avatar for Brandon Keepers bkeepers
PRO
72
12k
Everyday Curiosity
Avatar for Cassini Nazir cassininazir
0
200
HU Berlin: Industrial-Strength Natural Language Processing with spaCy and Prodigy
Avatar for Ines Montani inesmontani
PRO
0
370
<Decoding/> the Language of Devs - We Love SEO 2024
Avatar for Nikki Halliwell nikkihalliwell
1
210
DevOps and Value Stream Thinking: Enabling flow, efficiency and business value
Avatar for Helen Beal helenjbeal
1
180

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: ?