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
92

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
82
AWS ECS fargate
Avatar for thanhgit thanhgit
0
130
AWS Lambda function
Avatar for thanhgit thanhgit
0
180
CICD from on-premise to cloud
Avatar for thanhgit thanhgit
0
160
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
77
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
GC25 Recap+: Advancing Go Garbage Collection with Green Tea
Avatar for Takuto Nagami logica0419
1
240
非エンジニアのあなたもできる＆もうやってる！コンテキストエンジニアリング
Avatar for ファインディ株式会社（イベント資料アップ用） findy_eventslides
3
790
入門 FormObject / An Introduction to FormObject #kaigionrails
Avatar for Shu OGAWARA expajp
2
1.2k
DataOpsNight#8_Terragruntを用いたスケーラブルなSnowflakeインフラ管理
Avatar for Hiroki Yamagishi roki18d
1
270
「技術負債にならない・間違えない」 権限管理の設計と実装
Avatar for naro143 naro143
30
9k
5年間のFintech × Rails実践に学ぶ - 基本に忠実な運用で築く高信頼性システム / 5 Years Fintech Rails Retrospective
Avatar for Masato Ohba ohbarye
8
2.9k
サプライチェーン攻撃に学ぶModuleの仕組みと セキュリティ対策
Avatar for kuro kuro_kurorrr
3
650
Oracle Base Database Service 技術詳細
Avatar for oracle4engineer oracle4engineer
PRO
11
77k
研究開発部メンバーの働き⽅ / Sansan R&D Profile
Avatar for Sansan, Inc. sansan33
PRO
3
20k
Goに育てられ開発者向けセキュリティ事業を立ち上げた僕が今向き合う、AI × セキュリティの最前線 / Go Conference 2025
Avatar for GMO Flatt Security flatt_security
0
190
Sidekiq その前に：Webアプリケーションにおける非同期ジョブ設計原則
Avatar for morihirok morihirok
16
5.9k
全てGoで作るP2P対戦ゲーム入門
Avatar for ponyo877 ponyo877
3
1.1k

Featured

See All Featured
jQuery: Nuts, Bolts and Bling
Avatar for Doug Neiner dougneiner
64
7.9k
Stop Working from a Prison Cell
Avatar for Chris Michel hatefulcrawdad
271
21k
[RailsConf 2023 Opening Keynote] The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
30
9.7k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
Avatar for Marc Duiker marcduiker
31
2.2k
XXLCSS - How to scale CSS and keep your sanity
Avatar for Zaharenia Atzitzikaki sugarenia
248
1.3M
Designing for Performance
Avatar for Lara Hogan lara
610
69k
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
Avatar for Addy Osmani addyosmani
7
880
Gamification - CAS2011
Avatar for David Bonilla davidbonilla
81
5.4k
Keith and Marios Guide to Fast Websites
Avatar for Keith Pitt keithpitt
411
22k
Dealing with People You Can't Stand - Big Design 2015
Avatar for Cassini Nazir cassininazir
367
27k
Being A Developer After 40
Avatar for Adrian Kosmaczewski akosma
90
590k
Fashionably flexible responsive web design (full day workshop)
Avatar for Andy Clarke malarkey
407
66k

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