Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

Accessing RDS from local

Avatar for thanhgit thanhgit
May 03, 2022
Technology
130
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
120
AWS ECS fargate
Avatar for thanhgit thanhgit
0
190
AWS Lambda function
Avatar for thanhgit thanhgit
0
230
CICD from on-premise to cloud
Avatar for thanhgit thanhgit
0
200
Infra as Code (terraform)
Avatar for thanhgit thanhgit
0
140
Pritunl VPN Server
Avatar for thanhgit thanhgit
0
200
AuthN & AuthZ with distributed systems
Avatar for thanhgit thanhgit
0
220
Permission design
Avatar for thanhgit thanhgit
0
100
Blockchain - góc nhìn về kĩ thuật và ứng dụng
Avatar for thanhgit thanhgit
0
360

Other Decks in Technology

See All in Technology
AI時代の開発はウォーターフォールに回帰する？ / development-with-ai-back-to-wf
Avatar for 岡本卓也 okamototakuyasr2
0
160
なぜAI時代に技術記事を書くのか？どう書くのか？ 〜bunの場合〜
Avatar for KNOWLEDGE WORK / 株式会社ナレッジワーク kworkdev
PRO
0
1.1k
キヨさん67歳 AIコーディングエージェント物語
Avatar for コロッケそば happysamurai294
0
140
AI AgentによるEmbedded SREの取り組み
Avatar for norimichi.osanai tgidgd
1
280
Patterns in AI Driven Software Development
Avatar for Adrian Kosmaczewski akosma
PRO
0
380
AIコーディングエージェント開発_全体像
Avatar for コロッケそば happysamurai294
0
140
Agent × Maestro で始める モバイル E2E　端末準備からテスト実行・結果確認まで
Avatar for SansanTech sansantech
PRO
0
240
AI Search (Foundry IQ) におけるRAGデータの準備と配置
Avatar for Ryoma Nagata ryomaru0825
1
100
「作れる」と「リリースできる」の間にあったもの── PdMを外して見えた、PdMがやるべき仕事/Buildable ≠ Shippable: What Removing the PM Taught Me About the PM’s Job
Avatar for Yappli Developers yappli_developers
0
390
[FECONF-2026] 신대륙을 향한 카카오페이증권 프론트엔드 항해기 (이주승)
Avatar for l1ghthouse l1ghthouse
0
330
生き様としてのSRE
Avatar for Yutaro Sugai hokkai7go
0
140
Deep Data Security 機能解説
Avatar for oracle4engineer oracle4engineer
PRO
3
970

Featured

See All Featured
Applied NLP in the Age of Generative AI
Avatar for Ines Montani inesmontani
PRO
4
2.5k
Ruling the World: When Life Gets Gamed
Avatar for Sebastian Deterding codingconduct
0
430
The Art of Programming - Codeland 2020
Avatar for Erika Heidi erikaheidi
57
14k
SEO for Brand Visibility & Recognition
Avatar for Aleyda Solis aleyda
0
4.8k
Designing Powerful Visuals for Engaging Learning
Avatar for Mike Taylor tmiket
1
620
Taking LLMs out of the black box: A practical guide to human-in-the-loop distillation
Avatar for Ines Montani inesmontani
PRO
3
2.5k
Bridging the Design Gap: How Collaborative Modelling removes blockers to flow between stakeholders and teams @FastFlow conf
Avatar for Kenny Baas-Schwegler baasie
0
750
Primal Persuasion: How to Engage the Brain for Learning That Lasts
Avatar for Mike Taylor tmiket
0
510
Agile Actions for Facilitating Distributed Teams - ADO2019
Avatar for Mark Kilby mkilby
0
330
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
Avatar for Irina Nazarova irinanazarova
9
1.6k
Lightning talk: Run Django tests with GitHub Actions
Avatar for Sarah Abderemane sabderemane
0
310
Balancing Empowerment & Direction
Avatar for Lara Hogan lara
6
1.3k

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