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

Accessing RDS from local

thanhgit
May 03, 2022
Technology
0
70

Accessing RDS from local

thanhgit

May 03, 2022
Tweet

More Decks by thanhgit

See All by thanhgit
Developer portal
thanhgit
0
15
AWS ECS fargate
thanhgit
0
88
AWS Lambda function
thanhgit
0
88
CICD from on-premise to cloud
thanhgit
0
120
Infra as Code (terraform)
thanhgit
0
83
Pritunl VPN Server
thanhgit
0
90
AuthN & AuthZ with distributed systems
thanhgit
0
120
Permission design
thanhgit
0
68
Blockchain - góc nhìn về kĩ thuật và ứng dụng
thanhgit
0
210

Other Decks in Technology

See All in Technology
WebアプリケーションにおけるPDOの使い方入門 / phpcon odawara 2024
meihei3
2
420
コンテナセキュリティの基本と脅威への対策
kyohmizu
3
650
反実仮想機械学習とは何か
usaito
PRO
6
1k
TransitGatewayの基礎
toru_kubota
0
230
ユーザーストーリーのレビューを自動化したみたの
bun913
1
270
20240416_devopsdaystokyo
kzkmaeda
1
170
Data and AI Governance: Existing Challenges and Emerging Trends
scotthsieh825
0
140
CSSDAY 2024
kevinshallvari
0
180
スタートアップの技術顧問を3年間続けて発生した事と気付き
biwakonbu
0
150
2024-04-06　AMeDAS　to　Lagoon　SORACOM UG　2024-04-06
anysonica
0
120
シン・Kafka / shin-kafka
oracle4engineer
PRO
6
2.7k
長期間TiDBを使ってきた話 @ 私たちはなぜNewSQLを使うのかTiDB選定5社が語る選定理由と活用LT / Experiences with TiDB Over Time
chibiegg
2
160

Featured

See All Featured
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
185
16k
The Art of Programming - Codeland 2020
erikaheidi
41
12k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
243
20k
ピンチをチャンスに：未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
75
41k
GraphQLの誤解/rethinking-graphql
sonatard
49
9.2k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
658
120k
VelocityConf: Rendering Performance Case Studies
addyosmani
319
23k
Agile that works and the tools we love
rasmusluckow
323
20k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
219
21k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
1
1.3k
Why Our Code Smells
bkeepers
PRO
331
56k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
124
32k

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