Questions tagged with Amazon Relational Database Service
Content language: English
Sort by most recent
I have created AWS Aurora Read Replica from RDS PostgreSQL Primary database.
After creating Aurora Read Replica I have enabled Performance Insights for it, once it is enabled I started using Aurora Read Replica connection string in several places of my application.
I was able to see that my application got connected to Aurora Read Replica and all the queries are also getting executed successfully, but while navigating to Performance Insights Tab for Aurora Read Replica I am unable to see anything like Top Users, Top SQL Queries etc.
P.S. I have disabled and re-enabled Performance Insights several times to check weather it resolves the issue or not, but no luck.
On most instances of Postgres I've tried, this query works just fine if `my_table` does not exist:
```
alter table if exists public.my_table add column foo boolean;
NOTICE: relation "my_table" does not exist, skipping
ALTER TABLE
```
I've tried on multiple Postgres versions, including `15.2`.
However, on AWS RDS specifically, their `15.2` version will raise an error if the table does not exist:
```
=> alter table if exists public.my_table add column foo boolean;
ERROR: relation "public.my_table" does not exist
```
This does not appear to be an issue with other versions of RDS Postgres.
Any idea why this might be happening? Is there a parameter that's flipped on in 15.2 by default that causes this to happen?
Hi Team,
We created Postgres Aurora read replica for Postgres RDS and enabled performance insights for Aurora read replica.
In performance insights for this read replica, it is not tracking DB CPU, SQLs, etc.
Can you please help how we can track the metrics correctly through performance insights?
Thanks,
Tushar
A Lightsail instance trying to connect to an RDS Postgres database using "psql --hostname=[RDS endpoint URL]"
Receiving the error message:
"""
Is the server running on host "XXXX.rds.amazonaws.com" (XXX) and accepting
TCP/IP connections on port 5432?
"""
The database is accessible from local desktop, but not from the lightsail instance.
Public IP of the lightsail instance is open on the RDS relevant security group similar to the local desktop security group.
VPC peering is also enabled on Lightsail, and a security group with the instance's private IP also added
Are there special configuration the LightSail instance/ console needs to open?
Any other configurations on RDS ?
Thanks
Hi there
I have added the master account while creating the RDS Microsoft SQL Server with Dev/Test option. However I need an account with Sysadmin role. Could you please guide me how can I add/create a new user with Sysadmin role? Do I need to create a different type type of RDS SQL Server? Thanks in advanve.
Best Musharrif
I have an on-premises MySQL database that needs to be migrated to an AWS RDS MySQL database. The on-premises database will be updated regularly, and I want to update the RDS database with the latest records from the on-premises database on a daily basis at a scheduled time. The two databases have schema differences, and I need to modify the data from the on-premises database to match the schema of the RDS database. I will not be performing any analytics on the data, and the RDS database will be used as the database for a web application.
Can you suggest an ideal approach for this scenario?
Thanks in Advance!
Im trying to find a way, to make the multi-az cluster read replica, to become writable.
Is it even possible? or the only way of "promoting" the read replica, to be writable, is to "failover" the primary instance?
We have been providing AR web services since March 17th. Normally, the RDS CPU usage was only up to 4-5%, but there was a history of it using up to 60% today, so we are investigating the cause. Currently, RDS is created in a private area, and we understand that it can only be accessed by EC2 created in the same VPC. We checked the access logs of the Ubuntu EC2, but it seems that only two workers accessed the EC2 with their IP addresses. We are wondering if there is any other way to access the private RDS, and if CPU resources can be used like this when automatic RDS backups are performed. The RDS specification is db.m5.large, and MariaDB and the EC2 specification is c5n.2xlarge Ubuntu. Approximately 1 minute later, CloudWatch logs showed [Warning] Aborted connection numbers to db: 'unconnected' user: 'rdsadmin' host: 'localhost' (Got an error reading communication packets).
A question for the AWS professionals.
I recently worked with a dev team to create a web app for my business. The infrastructure is aws rds (db.m6i.large, 100% utilization, ondemand, multi-az) s3, and lightsail. Cost are estimated to be $300 p month in the calculator but we are being charged $1000 p month. Anyone know why we are charged so much?
Request: Delete 2 parameter groups?
Are you sure you want to delete these DB parameter groups
default.mysql8.0
default.mysql8.0
Unable to delete, getting the following error:
Failed to delete default.mysql8.0: Default DBParameterGroup cannot be deleted: default.mysql8.0 (Service: AmazonRDS; Status Code: 400; Error Code: InvalidDBParameterGroupState; Request ID: 4463730b-4e33-4ccf-ba4a-3ba533a9d6b2; Proxy: null).Failed to delete default.mysql8.0: Default DBClusterParameterGroup cannot be deleted: default.mysql8.0 (Service: AmazonRDS; Status Code: 400; Error Code: InvalidDBParameterGroupState; Request ID: 57478ad0-cd52-456b-9f16-9cdc678fba58; Proxy: null).
I am new to AWS and have been getting billed for this but I am unable to figure this out. Any help would be greatly appriciated.
RDS Custom for SQL Server is a managed database service where the customer has full administrative access to the operating system and database configuration, including via RDP. New OS images are provided regularly with the latest patches. Assuming there are no critical patches to apply, about how much time would elapse between new versions?
asked 10 days ago
I've recently upgraded my database from mysql5.7 to mysql8.0.26 which also incorporated an upgrade from Aurora 2 to Aurora 3 which is where I think the issue lies as there are no references to the following issue in the mySQL documentation.
During the upgrade the myql.user table is copied to the new database (using a Blue/Green deployment). GRANT permissions are also copied across and all the details remain unchanged as I have verified with `SHOW GRANTS` on both the blue and green environments. However, my users in the mysql8 DB do not have access to the resources identified in the GRANTS where those resources contain an underscore.
To reproduce the issue:
1. Create an Aurora 3 DB instance running MySQL 8.0.26
2. CREATE SCHEMA new_schema ;
3. CREATE TABLE new_schema.test_table (id int);
4. GRANT ALL PRIVILEGES ON `new\_schema`.* TO `my-user`@`%`
Run `SHOW GRANTS for my-user;` and you will see the following response:
```
GRANT ALL PRIVILEGES ON `new\_schema`.* TO `my-user`@`%`
```
That is the expected response, and mySQL documentation advises keeping the escape character in place to avoid any issues related to partial_revokes (which I can confirm is OFF by default).
Now the problem is, in Aurora 3, if I log in with `my-user` and run `SELECT * FROM new_schema.test_table` I get a permission denied error.
I have investigated a similar sounding issue in re:post [here](https://repost.aws/questions/QUeD79WVUQT4WJ9bpMNJ7hfg/aurora-3-my-sql-the-value-of-the-partial-revokes-parameter-in-the-parameter-group-is-different-from-the-value-of-the-same-variable-in-my-sql) however, I have already confirmed that `partial_revokes` as set to 0 (disabled) both in my database parameter groups and if I query it directly in mysql.