How do I perform common DBA tasks for Amazon RDS DB instances?
Last updated: 2019-12-26
How do I perform common DBA tasks for Amazon Relational Database Service (Amazon RDS)?
Because Amazon RDS delivers a managed service experience, there is no shell access provided to DB instances. For this reason, access to certain system procedures and tables that require advanced privileges are restricted. See the following examples of some common tasks that can't be executed in RDS by using standard commands:
- Bringing a database online when using Amazon RDS for SQL Server.
- Dropping a DB in a mirrored instance when using Amazon RDS for SQL Server.
- Killing an active session or query when using Amazon RDS for MySQL, Amazon Aurora MySQL, or MariaDB.
- Switching online log files when using Amazon RDS for Oracle.
If you receive a permission or privilege error message when executing a command or when modifying a DB instance, see the following engine-specific resources: