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

Accessing RDS from local

thanhgit
May 03, 2022
Technology
0
83

Accessing RDS from local

thanhgit

May 03, 2022
Tweet

More Decks by thanhgit

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

Other Decks in Technology

See All in Technology
Proxmox VE超入門 〜 無料で作れるご自宅仮想化プラットフォームブックマークする
devops_vtj
0
120
職種に名前が付く、ということ/The fact that a job title has a name
bitkey
1
240
移行できそうでやりきれなかった 10年超えのシステムを葬るための戦略 / phper-kaigi-2025-ryu
carta_engineering
0
690
Symfony in 2025: Scaling to 0
fabpot
2
190
AIエージェントキャッチアップと論文リサーチ
os1ma
6
1.2k
数百台のオンプレミスのサーバーをEKSに移行した話
yukiteraoka
0
680
17年のQA経験が導いたスクラムマスターへの道 / 17 Years in QA to Scrum Master
toma_sm
0
400
大規模サービスにおける カスケード障害
takumiogawa
1
130
コンソールで学ぶ！AWS CodePipelineの機能とオプション
umekou
2
110
SaaSプロダクト開発におけるバグの早期検出のためのAcceptance testの取り組み
kworkdev
PRO
0
440
React Server Componentは 何を解決し何を解決しないのか / What do React Server Components solve, and what do they not solve?
kaminashi
6
1.2k
製造業の会計システムをDDDで開発した話
caddi_eng
3
960

Featured

See All Featured
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
30
2.3k
Building a Modern Day 
E-commerce SEO Strategy
aleyda
39
7.2k
[RailsConf 2023] Rails as a piece of cake
palkan
53
5.4k
Designing Dashboards & Data Visualisations in Web Apps
destraynor
231
53k
How to Think Like a Performance Engineer
csswizardry
22
1.5k
Music & Morning Musume
bryan
46
6.4k
How To Stay Up To Date on Web Technology
chriscoyier
790
250k
Mobile First: as difficult as doing things right
swwweet
223
9.5k
A designer walks into a library…
pauljervisheath
205
24k
Gamification - CAS2011
davidbonilla
81
5.2k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
129
19k
Building a Scalable Design System with Sketch
lauravandoore
462
33k

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