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
94

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

Other Decks in Technology

See All in Technology
個人から巡るAI疲れと組織としてできること - AI疲れをふっとばせ。エンジニアのAI疲れ治療法 ショートセッション -
Avatar for kichion kikuchikakeru
4
1.8k
学術的根拠から読み解くNotebookLMの音声活用法
Avatar for Shu Kobuchi shukob
0
190
信頼性が求められる業務のAIAgentのアーキテクチャ設計の勘所と課題
Avatar for Koji Miyata miyatakoji
0
100
アジャイル社内普及ご近所さんマップを作ろう / Let's create an agile neighborhood map
Avatar for Satoshi Harada psj59129
1
140
ある編集者のこれまでとこれから —— 開発者コミュニティと歩んだ四半世紀
Avatar for 稲尾尚徳 inao
5
3.5k
Service Monitoring Platformについて
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
0
330
都市スケールAR制作で気をつけること
Avatar for segur segur
0
190
AWS re:Invent 2025 で頻出の 生成 AI サービスをおさらい
Avatar for komakichi komakichi
2
180
re:Inventにおける製造業のこれまでとこれから
Avatar for 濱田孝治 hamadakoji
0
150
Kubernetesと共にふりかえる! エンタープライズシステムのインフラ設計・テストの進め方大全
Avatar for 高棹大樹 daitak
0
420
LINEスキマニ/LINEバイトにおけるバックエンド開発
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
0
350
Quarkusで作るInteractive Stream Application
Avatar for Tomohiro Hashidate joker1007
0
160

Featured

See All Featured
The MySQL Ecosystem @ GitHub 2015
Avatar for Sam Lambert samlambert
251
13k
Scaling GitHub
Avatar for Zach Holman holman
464
140k
RailsConf 2023
Avatar for Aaron Patterson tenderlove
30
1.3k
The Illustrated Children's Guide to Kubernetes
Avatar for Chris Short chrisshort
51
51k
Raft: Consensus for Rubyists
Avatar for Patrick Van Stee vanstee
140
7.2k
Documentation Writing (for coders)
Avatar for Carmen Chung carmenintech
76
5.1k
How to train your dragon (web standard)
Avatar for Monica Dinculescu notwaldorf
97
6.4k
The Art of Delivering Value - GDevCon NA Keynote
Avatar for David Neal reverentgeek
16
1.8k
The Web Performance Landscape in 2024 [PerfNow 2024]
Avatar for Tammy Everts tammyeverts
11
940
Designing Experiences People Love
Avatar for Jonathan Moore moore
142
24k
Learning to Love Humans: Emotional Interface Design
Avatar for Aarron Walter aarron
274
41k
How To Stay Up To Date on Web Technology
Avatar for Chris Coyier chriscoyier
791
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: ?