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
50
AWS ECS fargate
thanhgit
0
99
AWS Lambda function
thanhgit
0
110
CICD from on-premise to cloud
thanhgit
0
140
Infra as Code (terraform)
thanhgit
0
93
Pritunl VPN Server
thanhgit
0
110
AuthN & AuthZ with distributed systems
thanhgit
0
130
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
障害対応指揮の意思決定と情報共有における価値観 / Waroom Meetup #2
arthur1
5
470
SSMRunbook作成の勘所_20241120
koichiotomo
2
130
適材適所の技術選定 〜GraphQL・REST API・tRPC〜 / Optimal Technology Selection
kakehashi
1
170
マルチプロダクトな開発組織で 「開発生産性」に向き合うために試みたこと / Improving Multi-Product Dev Productivity
sugamasao
1
300
強いチームと開発生産性
onk
PRO
33
11k
TypeScript、上達の瞬間
sadnessojisan
46
13k
OCI 運用監視サービス 概要
oracle4engineer
PRO
0
4.8k
【Startup CTO of the Year 2024 / Audience Award】アセンド取締役CTO 丹羽健
niwatakeru
0
960
ハイパーパラメータチューニングって何をしているの
toridori_dev
0
140
DMARC 対応の話 - MIXI CTO オフィスアワー #04
bbqallstars
1
160
Lambdaと地方とコミュニティ
miu_crescent
2
370
スクラムチームを立ち上げる〜チーム開発で得られたもの・得られなかったもの〜
ohnoeight
2
350

Featured

See All Featured
Save Time (by Creating Custom Rails Generators)
garrettdimon
PRO
27
840
The World Runs on Bad Software
bkeepers
PRO
65
11k
Fashionably flexible responsive web design (full day workshop)
malarkey
405
65k
jQuery: Nuts, Bolts and Bling
dougneiner
61
7.5k
Side Projects
sachag
452
42k
Optimizing for Happiness
mojombo
376
70k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
329
21k
Principles of Awesome APIs and How to Build Them.
keavy
126
17k
Embracing the Ebb and Flow
colly
84
4.5k
A better future with KSS
kneath
238
17k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
93
16k
Git: the NoSQL Database
bkeepers
PRO
427
64k

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