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

Accessing RDS from local

thanhgit
May 03, 2022
Technology
0
75

Accessing RDS from local

thanhgit

May 03, 2022
Tweet

More Decks by thanhgit

See All by thanhgit
Developer portal
thanhgit
0
48
AWS ECS fargate
thanhgit
0
97
AWS Lambda function
thanhgit
0
100
CICD from on-premise to cloud
thanhgit
0
140
Infra as Code (terraform)
thanhgit
0
92
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
Databricks Appのご紹介
databricksjapan
0
120
【shownet.conf_】AI技術とUX監視の応用でShowNetの基盤を支えるモニタリングシステム
shownet
PRO
0
370
【インフラエンジニアbooks】30分でわかる「AWS継続的セキュリティ実践ガイド」
hssh2_bin
4
1.6k
【shownet.conf_】トポロジ図の歩き方
shownet
PRO
0
510
AWS Lambdaで実現するスケーラブルで低コストなWebサービス構築/YAPC::Hakodate2024
fujiwara3
7
3.1k
Tracking down sources of kernel errors with retsnoop
ennael
PRO
0
160
LeSSはスクラムではない！？LeSSにおけるスクラムマスターの振る舞い方とは / Scrum Master Behavior in LeSS
toma_sm
0
170
【shownet.conf_】コンピューティング資源を統合した分散コンテナ基盤の進化
shownet
PRO
0
400
【shownet.conf_】ローカル5Gを活用したウォーキングツアーの体感向上
shownet
PRO
0
350
【shownet.conf_】クロージングセッション
shownet
PRO
0
300
Hazard pointers with reference counter
ennael
PRO
0
120
Pythonを活用したLLMによる構造的データ生成の手法と実践
brainpadpr
3
330

Featured

See All Featured
Building Better People: How to give real-time feedback that sticks.
wjessup
362
19k
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
3
230
Making the Leap to Tech Lead
cromwellryan
130
8.8k
ParisWeb 2013: Learning to Love: Crash Course in Emotional UX Design
dotmariusz
110
6.9k
Why Our Code Smells
bkeepers
PRO
334
57k
Gamification - CAS2011
davidbonilla
80
5k
jQuery: Nuts, Bolts and Bling
dougneiner
61
7.5k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
231
17k
Pencils Down: Stop Designing & Start Developing
hursman
119
11k
What’s in a name? Adding method to the madness
productmarketing
PRO
22
3.1k
Thoughts on Productivity
jonyablonski
67
4.2k
Put a Button on it: Removing Barriers to Going Fast.
kastner
58
3.5k

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