Setup RDS MySQL server that is accessible over the internet

 Setup RDS MySQL server that is accessible over the internet

Steps:-

1. Search for RDS service in AWS console.


2. Create a database


3. Give appropriate name and password.


4. Make your Database publicly accessible.


5. Finally create database.


6. RDS successfully created.

    


7. Now let's connect to the RDS using AWS CLI. First generate the authentication token with following command

                       aws rds generate-db-auth-token \                                                                   
                    --hostname database-1.cn2qjigxwzyc.us-east-2.rds.amazonaws.com \
                    --port 3306 \
                    --region Ohio \
                    --username admin
8. Once token is generated, you may connect to Mysql using the following command





Comments

Post a Comment

Popular posts from this blog

AWS Services

 AWS Services -19BCS009 1. Amazon EC2 (Elastic Compute Cloud) EC2 is a cloud platform provided by Amazon that offers secure, and resizable compute capacity. Its purpose is to enable easy access and usability to developers for web-scale cloud computing, while allowing for total control of your compute resources. Deploy applications rapidly without the need for investing in hardware upfront; all the while able to launch virtual servers as-needed and at scale. 2. Amazon RDS (Relational Database Services) Amazon Relational Database Service (Amazon RDS) makes database configuration, management, and scaling easy in the cloud. Automate tedious tasks such as hardware provisioning, database arrangement, patching, and backups – cost-effectively and proportionate to your needs. RDS is available on various database instances which are optimized for performance and memory, providing six familiar database engines including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle. database, and SQL serv...
Read more

Installing and attaching MYSQL database to EC2 instance

Image
 Installing and attaching MYSQL database to EC2 instance Steps: 1. Make sure you have one EC2 instance running that you can access it from your terminal. 2. Switch to root mode and move to root directory      sudo su cd / 3. Update existing packages.     sudo apt-get update 4. Now install mysql server. sudo apt-get install mysql-server 5. Now run command for secure installation. sudo mysql_secure_installation  6. Give appropriate password 7. If password is not accepted you can access mysql as sudo then alter the user password 8. Now we can interact with databases.
Read more

Cloud Computing and Virtualisation

Cloud Computing -19BCS009 Cloud computing is the on-demand availability of computer system resources, especially data storage and computing power etc. This is achieved using the power of virtualisation in which we create computing resources that have no physical presence, that is, they are virtual. This way we are able to run multiple processes on the same hardware resource with isolation. This creates possibility of using one hardware as multiple hardwares. There are various types of virtualisation for various applications.  Types of Virtualisation pertaining:-  1. Application Virtualisation:  Application virtualisation helps a user to have remote access of an application from a server. The server stores all personal information and other characteristics of the application but can still run on a local workstation through the internet. Example of this would be a user who needs to run two different versions of the same software. Technologies that use application virtu...
Read more