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
100

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
95
AWS ECS fargate
Avatar for thanhgit thanhgit
0
140
AWS Lambda function
Avatar for thanhgit thanhgit
0
190
CICD from on-premise to cloud
Avatar for thanhgit thanhgit
0
180
Infra as Code (terraform)
Avatar for thanhgit thanhgit
0
120
Pritunl VPN Server
Avatar for thanhgit thanhgit
0
160
AuthN & AuthZ with distributed systems
Avatar for thanhgit thanhgit
0
180
Permission design
Avatar for thanhgit thanhgit
0
82
Blockchain - góc nhìn về kĩ thuật và ứng dụng
Avatar for thanhgit thanhgit
0
270

Other Decks in Technology

See All in Technology
書籍執筆での生成AIの活用
Avatar for Satoru Takeuchi sat
PRO
1
210
DatabricksホストモデルでAIコーディング環境を構築する
Avatar for Databricks Japan databricksjapan
0
120
AI時代にあわせたQA組織戦略
Avatar for Masami Yajiri masamiyajiri
5
2.5k
VRTと真面目に向き合う
Avatar for Yuya Hirayama hiragram
1
490
エンジニアとマネジメントの距離/Engineering and Management
Avatar for 小田中育生 ikuodanaka
3
630
人はいかにして 確率的な挙動を 受け入れていくのか
Avatar for vaaaaanquish vaaaaanquish
4
2.6k
AI Agent Agentic Workflow の可観測性 / Observability of AI Agent Agentic Workflow
Avatar for yuzujoe yuzujoe
7
2.3k
プロダクトエンジニアこそ必要なPMスキル 〜デリバリー力を最大化し、価値を届け続けるために〜
Avatar for LayerX layerx
PRO
0
130
EventBridge API Destination × AgentCore Runtimeで実現するLambdaレスなイベント駆動エージェント
Avatar for Har1101 har1101
7
260
20260120 Amazon VPC のパブリックサブネットを無くしたい！
Avatar for Masaru Ogura masaruogura
2
160
クラウドセキュリティの進化 — AWSの20年を振り返る
Avatar for kei4eva4 kei4eva4
0
160
SREの仕事を自動化する際にやっておきたい5つのポイント
Avatar for Kazuto Kusama jacopen
6
1k

Featured

See All Featured
Agile Leadership in an Agile Organization
Avatar for Dr. Kim W Petersen kimpetersen
PRO
0
75
Improving Core Web Vitals using Speculation Rules API
Avatar for Sergey Chernyshev sergeychernyshev
21
1.3k
Exploring the relationship between traditional SERPs and Gen AI search
Avatar for Ray Grieselhuber raygrieselhuber
PRO
2
3.6k
From π to Pie charts
Avatar for Rasagy Sharma rasagy
0
120
Leveraging Curiosity to Care for An Aging Population
Avatar for Cassini Nazir cassininazir
1
150
The World Runs on Bad Software
Avatar for Brandon Keepers bkeepers
PRO
72
12k
Mobile First: as difficult as doing things right
Avatar for Swwweet swwweet
225
10k
Designing Dashboards & Data Visualisations in Web Apps
Avatar for Des Traynor destraynor
231
54k
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore lauravandoore
463
34k
End of SEO as We Know It (SMX Advanced Version)
Avatar for Michael King ipullrank
2
3.9k
Keith and Marios Guide to Fast Websites
Avatar for Keith Pitt keithpitt
413
23k
Unlocking the hidden potential of vector embeddings in international SEO
Avatar for Frank van Dijk frankvandijk
0
160

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