Open In App

Amazon RDS – Stopping a DB Instance Running on MySQL Engine

Last Updated : 27 Mar, 2023
Like Article

In Amazon RDS, we are given the liberty to modify the activation state of the resource owned by us. These states include multiple options for us to choose from. Here in this article, we will look at the “STOP” option. This state temporarily stops all the processes running simultaneously on the resource attached to it, i.e. no updates or notifications for updating the current engine will be seen, no addition of data is possible, etc. Altogether, we cannot make any alterations on any DB instance which is in the stopped state.

Now, let us look at the step-by-step procedure of stopping a DB instance running on MySQL Engine.

Step 1: First, login into your AWS account. Once you reach the AWS management console, look at the extreme left, there is a tab “Services”. Click on that, a list of options will appear on your screen. From this list, under the “Database” section select “RDS”. Here is the image to avoid any kind of confusion.

Step 2: Once you are directed to the RDS console, from the navigation pane. Choose “Databases”. Here is the image for reference.

Step 3: On the right, select the DB instance from the listed instances. Make sure the instance is in the “Available” state, which shows that it is currently in the running state. And it should be running on “MySQL Engine”. Refer to the image attached ahead for better understanding.

Step 4: Now, click on the “Actions” tab. From the listed options, select “Stop”. Refer to the image attached.

In a while, the status will turn “Stopped” from “Available”. This is a simple method for stopping a DB instance running on MySQL Engine. And whenever you wish to start the instance back. Follow the same process. If you also have a free tier account, make sure you delete all the services and resources you have used before logging out.

Previous Article
Next Article

Similar Reads

Amazon RDS - Starting a Previously Stopped Amazon RDS DB Instance
This article aims to enlighten you about "Starting a Previously Stopped Amazon RDS DB Instance". AWS provides us the facility to start, stop or delete any DB Instance at any time. All this is entirely dependent on the user, i.e. he or she is the only person who can perform these operations on the running DB Instance. Let us understand the differenc
2 min read
Amazon RDS - Creating an Amazon RDS DB Instance
Amazon Relational Database Service (Amazon RDS) is a relational database that is easier to set up, operate, and scale in the Cloud. It is cost-efficient, have resizable capacity for relational database and manages common database administration tasks. DB instance is the basic building block of Amazon RDS where we create our own databases. A DB inst
2 min read
Amazon RDS - Monitoring an Amazon RDS Database Instance
This article intends to educate you about "Monitoring an Amazon RDS Database Instance". Monitoring is essential for your database instance because it is directly proportional to the maintenance of your RDS database instance. If we keep monitoring all the resources then it will be easy for us to debug failures or even possibilities of failures. Cons
6 min read
Amazon RDS - Modifying An Amazon RDS DB Instance
Amazon RDS (Relational Database Service) is a powerful cloud-based database solution provided by AWS. On using this RDS database users may focus more on their applications because of its less complexity with its database setup. AWS manages the administration setup complexities and provides simple handiness to the users. In this article, we will go
6 min read
AWS RDS - Launching RDS Database Instance for Free
In this article we will look into how you can launch an Amazon RDS database instance that's covered by the AWS free tier. To do so follow the below steps: Amazon RDS free tier is available to you only in the first 12 months of your AWS account creation. Each calendar month, the free tier allows you to use the Amazon RDS resources listed below for f
3 min read
Amazon RDS - Storage for Amazon RDS DB Instances
This article aims to provide you all the information regarding "Storage for Amazon RDS DB Instances". As we all know RDS is the most preferred database management system as it includes all the services together in a single place, right from servers to queries. All the database engines are available in AWS work on Amazon Elastic Block Store (EBS) vo
2 min read
Amazon RDS - Upgrading a DB Instance Engine Version
This article aims to make you aware "Upgrading a DB Instance Engine Version". Upgrading a DB instance Engine comes under the maintenance section of the database instance. AWS has an in-built feature, that sends notifications regarding all kinds of updates in a DB instance. Under all this, there are certain notifications about the Engine Version too
2 min read
RDS Read Replicas - How It is Different from RDS Multi-AZ Deployment
Amazon RDS (Relational Database Service) is a fully managed service by AWS to deploy and scale relation database systems in the cloud. Amazon RDS supports a lot of relation database engines such as MYSQL, PostgreSQL, Oracle, SQL Server, etc. Amazon RDS comes with a lot of handy features such as encryption, scaling, snapshotting, disaster recovery,
4 min read
Amazon Web Services - Limit Privileges of IAM user in RDS instance
Amazon RDS or Amazon Relational Database System is a highly scalable, secure, compact, and cost-efficient relational database in the cloud offered by AWS. In this article, we are going to look into how to limit access of AWS IAM users to an Amazon RDS(Relational Database Service) instance. Then we will explore how to give the least privileges requi
2 min read
Amazon RDS - Rebooting a DB Instance
This article is a step by step guide for Rebooting a DB Instance. But before learning the process of rebooting an instance, we need to know about DB Instances and how to create one on AWS. DB Instance or Database Instance DB Instance is an obscure database dominion running on a cloud platform, here that platform is AWS. It is a cellular block of Am
4 min read