Skip to main content

Amazon RDS Instance create for Mysql : Step by Step


Introduction : 

Using the Amazon RDS (Relational Database Service), you can easily set up, operate, and expand a relational database in the cloud. Hardware provisioning, database setup, while effectively automating time-consuming administrative tasks, such as patching and backup costs and provides available capacity scaling. Therefore, we can focus on the application can provide the necessary performance, high availability, security, and compatibility.

Create an Amazon RDS For MySQL .

1. Log in to your AWS account.
2. Verify the region in which the infrastructure will be created.
In the upper-right corner, click the button with the city name and select the region. In this case, Virginia.

3. Select the RDS service.
4. Select “Get Started Now.”
5. Choose the database manager, in this case, “MySQL”. Press “Select”.

6. Choose whether the instance will be used for production or
Dev/Test environment.
In this case, it’s for production, so we select the option and we continue.

7. Select the database version, the type of instance (in this case, db.t2.micro), we disable Multi-AZ (for demonstration purposes of our tutorial), the capacity of the database in Gb, the name of the instance, the master user (master) and your password.
Multi-AZ is the replication of the instance in another zone if the database has any problem.



8. Select the VPC of the infrastructure, determine if the instance will be publicly accessible or not. Assign an availability zone. Add a name to the database and enable or disable monitoring (in this case it will be disabled); immediately proceed to create the instance.




9. Finally, verify that the status of the instance is available. This will take few minutes, so do not despair.

Note: This instance does not have an IP, but ENDPOINT does the same for the connection.
ready! We have completed the creation of the RDS instance. Leave a comment and I can help resolve any questions.

Thanks for read this blog.

Comments

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. This comment has been removed by a blog administrator.

    ReplyDelete
  4. This comment has been removed by a blog administrator.

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Speedup your WordPress site with Amazon CloudFront.

Introduction A WordPress performance is quite excellent . The number of WordPress plugins to handle performance is such evidence. But the easiest way to improve your user experience is to accelerate the entire WordPress website using CloudFront. This will help you not only improve site response time reduces the necessary infrastructure, reducing the load on the Web server, so you can reduce the total cost of the infrastructure works WordPress. CloudFront is actually a site can greatly help your site to respond to unexpected load when gained popularity. Today this post is to clarify the method of providing a reasonable standard configuration on the WordPress website or blog. How does CloudFront help? Amazon CloudFront is to improve the user's experience accessing the Web site in several ways: 1.  Anycast DNS is to ensure that customers are routed to the nearest edge location. 2.  The cached content is available to users at the edge position (i

Linux System : Free Employee Monitoring with Automatic Screenshots

Introduction :   A utomatic screen-shots  of Linux system directly import  on your web server with Linux samba server service and scrot command. 1)  Setup web panel UI on your web server :   Get web panel PHP/HTML code from Github URL: https://github.com/raj412/Employee-Monitoring-for-Linux-System It’s work in Linux server LAMP environment(no need database for this configuration ) Defult login username password is admin/1234. You can change username/passwrod from login.php file in line number #6 Login Page : Dashboard : Screenshot Page : 2)  Samba server configuration on web server : I.  Install Samba on your server where you setup Linux screenshot log system web panel. sudo apt-get update sudo apt-get install samba II.  Set a password for your user in Samba sudo smbpasswd -a <user_name> III.  Share gallery-images folder from you web panel. This is my web panel gallery-images p

How to control high traffic load on Apache servers : optimization performance of APACHE2 & PHP-FPM

Everyone handle high traffic loads  on Apache server. During down-time they forget to check server memory . Apache not used lot of memory  still server not responding. All time we restart Apache service and all things will start working good. I also faced same issue numerous time and all-time  used same solution : Restart Apache. After lots of research and reading found one solution. In this blog you see step-by-step guide to apache2 performance settings. System environment: Intel(R) Xeon(R) CPU 3.10GHz, 4 cores | 8GB RAM Ubuntu 16.04 Apache2 version using mpm_event PHP FPM (5.6,7.1) First,  Calculate process size : Download : python script file “ps_mem.py” from Github Open this and ps_mem.py file upload on you server :  https://github.com/raj412/ps_mem chmod a+x ps_mem.py sudo python ps_mem.py Output like this:  See here : 12 Apache processes, consuming a total of  35.7MiB, so each Apache process is using roughly 3MiB of RAM. The 42 php-fpm process u