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

Accessing RDS from local

thanhgit
May 03, 2022
Technology
0
78

Accessing RDS from local

thanhgit

May 03, 2022
Tweet

More Decks by thanhgit

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

Other Decks in Technology

See All in Technology
Docker Desktop で Docker を始めよう
zembutsu
PRO
1
210
やっちゃえ誤自宅Nutanix
yukiafronia
0
240
第27回クラウド女子会 ～re:Invent 振り返りLT会～ 宣言型ポリシー、使ってみたらこうだった！
itkr2305
0
120
2025年のARグラスの潮流
kotauchisunsun
0
870
デジタルアイデンティティ人材育成推進ワーキンググループ 翻訳サブワーキンググループ 活動報告 / 20250114-OIDF-J-EduWG-TranslationSWG
oidfj
0
570
今から、 今だからこそ始める Terraform で Azure 管理 / Managing Azure with Terraform: The Perfect Time to Start
nnstt1
0
250
データ基盤におけるIaCの重要性とその運用
mtpooh
4
700
Git scrapingで始める継続的なデータ追跡 / Git Scraping
ohbarye
5
610
iPadOS18でフローティングタブバーを解除してみた
sansantech
PRO
1
170
【JAWS-UG大阪 reInvent reCap LT大会 サンバが始まったら強制終了】“1分”で初めてのソロ参戦reInventを数字で振り返りながら反省する
ttelltte
0
160
財務データを題材に、 ETLとは何であるかを考える
shoe116
3
1.5k
20250116_自部署内でAmazon Nova体験会をやってみた話
riz3f7
1
130

Featured

See All Featured
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
59k
jQuery: Nuts, Bolts and Bling
dougneiner
63
7.6k
Building Applications with DynamoDB
mza
93
6.2k
Designing for Performance
lara
604
68k
StorybookのUI Testing Handbookを読んだ
zakiyama
28
5.4k
The Invisible Side of Design
smashingmag
299
50k
Improving Core Web Vitals using Speculation Rules API
sergeychernyshev
4
190
GraphQLの誤解/rethinking-graphql
sonatard
68
10k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
eileencodes
20
2.4k
Build your cross-platform service in a week with App Engine
jlugia
229
18k
Git: the NoSQL Database
bkeepers
PRO
427
64k
Optimizing for Happiness
mojombo
376
70k

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