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
87

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
73
AWS ECS fargate
Avatar for thanhgit thanhgit
0
120
AWS Lambda function
Avatar for thanhgit thanhgit
0
160
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
130
AuthN & AuthZ with distributed systems
Avatar for thanhgit thanhgit
0
150
Permission design
Avatar for thanhgit thanhgit
0
74
Blockchain - góc nhìn về kĩ thuật và ứng dụng
Avatar for thanhgit thanhgit
0
250

Other Decks in Technology

See All in Technology
AIに実況させる / AI Streamer
Avatar for motemen motemen
3
1.4k
それでもぼくらは貢献をつづけるのだ(たぶん) @FOSS4GLT会#002
Avatar for YFurukawa furukawayasuto
1
260
S3 Tables を図解でやさしくおさらい～基本から QuickSight 連携まで/s3-tables-illustrated-basics-quicksight
Avatar for emi emiki
1
310
mnt_data_とは？ChatGPTコード実行環境を深堀りしてみた
Avatar for Issei.Komori icck
0
180
RDRA3.0を知ろう
Avatar for 神崎 kanzaki
2
410
Oracle Database オプティマイザ・ヒントの活用
Avatar for oracle4engineer oracle4engineer
PRO
1
130
テストを実施する前に考えるべきテストの話 / Thinking About Testing Before You Test
Avatar for nihonbuson nihonbuson
PRO
12
2k
新卒から4年間、20年もののWebサービスと向き合って学んだソフトウェア考古学 - PHPカンファレンス新潟2025 / new graduate 4year software archeology
Avatar for guri oguri
2
340
Eight Engineering Unit 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
0
3.2k
データ戦略部門 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
1
3.1k
SmartHRの複数のチームにおけるMCPサーバーの活用事例と課題
Avatar for Yuki Horikoshi yukisnow1823
2
1.1k
Azure Developer CLI と Azure Deployment Environment / Azure Developer CLI and Azure Deployment Environment
Avatar for ののし nnstt1
1
110

Featured

See All Featured
Fantastic passwords and where to find them - at NoRuKo
Avatar for Phil Nash philnash
51
3.2k
Optimising Largest Contentful Paint
Avatar for Harry Roberts csswizardry
37
3.3k
I Don’t Have Time: Getting Over the Fear to Launch Your Podcast
Avatar for Joe Casabona jcasabona
32
2.3k
Building an army of robots
Avatar for Kyle Neath kneath
306
45k
Typedesign – Prime Four
Avatar for Hannes Fritz hannesfritz
41
2.6k
Navigating Team Friction
Avatar for Lara Hogan lara
185
15k
Fashionably flexible responsive web design (full day workshop)
Avatar for Andy Clarke malarkey
407
66k
Done Done
Avatar for chrislema chrislema
184
16k
Understanding Cognitive Biases in Performance Measurement
Avatar for Philip Tellis bluesmoon
29
1.7k
The Cost Of JavaScript in 2023
Avatar for Addy Osmani addyosmani
49
8k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
34
2.3k
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore 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: ?