We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [amazon-rds]

Amazon Relational Database Service is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.

Filter by
Sorted by
Tagged with
3
votes
1answer
41 views

Migrate large (200GB) mysql databases to new hosts with as little downtime as possible

My question is about migrating large amounts of MySQL data with as little downtime as possible. I have 3 MySQL databases that need to be moved from one RDS instance inside a VPC into a brand new AWS ...
0
votes
1answer
13 views

Sudden High CPU Usage On RDS Postgres

I manage an application that has what I would call a medium sized workload (20,000-30,000 records inserted per day with around 2GB of data total). We're on RDS Postgres 9.6 with a db.m4.xlarge (4 vCPU ...
2
votes
0answers
37 views

Error in ALTER DEFAULT PRIVILEGES

I'm trying to create a new user in AWS Aurora Postgres DB. Create user worked fine and I can login to the DB using that account. granting permissions to it isn't. First: GRANT ALL on ALL tables in ...
0
votes
0answers
21 views

AWS RDS: How do I diagnose this failure?

I have a simple RDS setup: one database, no replication. It has been running for around 2 years without any problems. CPU usage is generally less than 5%, sometimes boosting to around 10%. Today, ...
0
votes
0answers
39 views

Performance issue when loading data in postgres RDS

Can someone please help me on the Below Issue on Postgres RDS. We have two Postgres instances in AWS RDS. When we run the Full or Incremental Data load on one instance by fetching the data from other ...
0
votes
1answer
49 views

Maintaining a production big table

I have a very large table: Table1 in a production environment which I need to alter a column in. What's the best preferred way to do so without down time? Option 1: CREATE TABLE Table1_new LIKE ...
1
vote
1answer
69 views

Optimizing a query with many permutations (using Postgresql 11)

I'm trying to figure out the optimal solution for filtering a result set by every permutation of a given input criteria. We're using Postgresql 11 on AWS RDS I've created a sql fiddle here that ...
0
votes
1answer
36 views

Number of Worker threads available in PostgreSQL

In SQL Server we can have many worker threads per CPU core. Does anyone know if the same is true in PostgreSQL and can point me at a reference? (assume version 11). The background is that we have ...
0
votes
0answers
34 views

Which MySQL settings are the closest equivalent to RDS' “Queue depth”?

I'm trying to find out which MySQL status variables can be used to get as close as possible to the RDS value of "Queue depth". On a test system, I reckon that %pending% variables may be at least a ...
0
votes
0answers
9 views

Occasional “access denied” on a persistent SSL connection, to MariaDB, from PHP

When using SSL to connect to a MariaDB instance on Amazon RDS, I'm able to setup a persistent connection, and login almost every time. But I will occasionally get: [Warning] Access denied for user '...
0
votes
0answers
19 views

Creating a custom thesaurus dictionary on RDS

We're deployed on RDS using Postgres 11.4, and I'm hoping that there is some way to define a custom thesaurus dictionary. I think the answer is a hard no, based on this StackOverflow thread and this ...
0
votes
0answers
27 views

Cannot connect to RDS Aurora Mysql Database Even Though It Exists

We have an RDS aurora mysql instance that has been up and running for a while without issue, however, today our application's connection to the db failed, with error ERROR 1049 (42000): Unknown ...
0
votes
1answer
38 views

Import a large MySQL dump 68GB on RDS instance

I tried to import a large MySQL dump.sql (68GB) on RDS AWS instance MySQL 8.0 (db.t3.2xlarge: 32GB RAM). The import takes more than six hours: More than 500 tables I have 2 large tables: the first ...
0
votes
2answers
39 views

Postgres: Vacuum taking too long

I have a database currently sitting on ~6B live tuples, ~4B dead tuples. I've ran the VACUUM command for 3 days now, and then suddenly my internet died. Meaning i lost all progress. How can i speed ...
0
votes
0answers
16 views

Postgres: Copy (clone) a table

Is there an efficient way in Postgres (with any limitation introduced by the fact its running on AWS RDS taken into account) to clone a table?
0
votes
1answer
23 views

Postgres: Reclaiming Space

I have a server with 150GB of diskspace. Today I uploaded a dataset of 30GB. I cancelled the import due to internet dying, then noticed there was 29GB of space missing in the database (meaning the CSV ...
0
votes
1answer
25 views

How do i disable or limit Postgres Replication creating causing too many WAL files generated?

On AWS RDS PostgreSQL 10.7, I turned on logical replication for a one specific table . on publisher: CREATE PUBLICATION mypublication FOR TABLE <mytable>; on subscriber: CREATE SUBSCRIPTION ...
0
votes
0answers
13 views

High constant CPU on Aurora/RDS

I've noticed recently that our resting CPU on our Aurora RDS cluster appears to be about 80%. I'm unsure when this started, as we don't have alarms/metrics in place (something I plan to rectify now). ...
0
votes
1answer
23 views

MySQL Database on RDS with memory issues

I am facing high memory utilization issue on RDS MySQL server. We are having other issues too, can someone give me a help? My database has 120GB, including indexes. Can anyone help me out to ...
0
votes
0answers
19 views

AWS RDS Multi A-Z vs DigitalOcean Managed Databases

I am currently hosting my database inside a t2.large instance on AWS EC2 which provides 8GB RAM and 2 CPUs. I am now looking for better options which are more scalable and provides features like ...
0
votes
0answers
111 views

The MySQL server is running with the --read-only option so it cannot execute this statement

I am using amazon aurora RDS in my application. I have created cluster endpoint by selecting both read and write instance. Then I used that instance in my application. Whenever I am executing update ...
0
votes
0answers
40 views

How do I stop Amazon Web Service's RDS from locking out connections during backups?

I've been using RDS for years, and this only became an issue a few months ago. I was pulling my hair out trying to find the source of the issue... only to figure out it's suddenly RDS. I've made no ...
0
votes
1answer
37 views

mysql/aurora not immediately seeing results of committed transactions

In a system running against an AWS aurora-mysql database, the following (obviously extremely simplified) code runs. It's a highly concurrent system, multiple threads, multiple connections to db. The ...
2
votes
1answer
22 views

Is there a limit to how many backup files I can restore from for a single database on RDS SQL Server?

The AWS documentation for using native restore specifies that restoring from multiple files is allowed: To avoid errors while restoring multiple files, make sure that all the backup files have ...
2
votes
2answers
35 views

Will our application server have issues connecting to a Postgres 11.4 server with a 9.6 client?

Our application server is on EC2 running on Amazon Linux 1. Postgres dropped support for Amazon Linux and so we depend on Amazon providing the postgres client. The client is 9.6 and our Amazon ...
0
votes
1answer
23 views

Upload file to RDS Postgres Instance

I want to create custom Full Text Search dictionary with special stop words from some_words.stop. How to upload this file to my RDS instance by FTP?
0
votes
0answers
51 views

How to start, stop, pause and resume a logical replication setup in PostgreSQL using PgLogical?

I have a publisher node on on-prem 9.4 and subscriber node on RDS version 10.6 and few tables are configured for replication. The current status is replicating. Now for my learning, I want to stop the ...
0
votes
0answers
18 views

Connecting to postgres via ODBC from AWS Oracle RDS

I would like to connect a 12.1 Oracle RDS AWS instance to a Postgres database (also running at AWS but hosted on an EC2 instance). There are a number of examples of how you could do this (eg https://...
1
vote
1answer
29 views

Loading Custom Rules into unaccent postgresql hosted into an amazon aws instance

The default unaccent module has no or little support for Greek Letters using the unaccent module as seen in following links: https://stackoverflow.com/q/49845063 https://www.postgresql-archive.org/...
1
vote
1answer
81 views

Create a read-write user and a read-only user

I'm trying to do what I think is a common setup for a PostgreSQL database on a RDS instance. I want to have: Either on public schema, or on a custom schema I don't especially care A read-write user A ...
0
votes
2answers
89 views

Amazon RDS Ola Hallengren

Very new to SQL on AWS RDS so. Need to create maintenance jobs on an AWS RDS SQL2016 instance. I know parts of Ola Hallengren's life saver maintenance script works, Index, stats and integrity. ...
0
votes
1answer
23 views

Detecting Logical Replication Error on Postgres v10 on AWS RDS CloudWatch metrics

https://www.postgresql.org/docs/10/logical-replication-restrictions.html States: "When the schema is changed on the publisher and replicated data starts arriving at the subscriber but does not fit ...
2
votes
1answer
54 views

Can you import a Postgresql 9.5.10 db into a Postgresql 10.9 server?

I would like to know if it is safe to import a dump made from a database running on a PostgreSQL server 9.5.10 to a PostgreSQL server 10.9. Basically I am able to do the import. It does not fail. But ...
3
votes
1answer
76 views

Will query continue to run even after network times-out

I have a few long-running queries that I'm executing against a remote instance of Postgres (AWS RDS). When I execute any of these queries, I get a network timeout on my client after a couple of ...
0
votes
1answer
42 views

Mysql row-based binary logging behaving different in some versions of mysql (rows grouping)

Mysql row-based binary logging seems to have a different behaviour when grouping rows changes in some versions of mysql. Let's assume the following statement update three rows: UPDATE table_name ...
1
vote
2answers
18 views

GRANT permission ON database TO user not working on AWS

I'm having trouble granting a user permission on AWS. mysql> GRANT CREATE ON *.* TO 'hmrex_db'@'%'; Query OK, 0 rows affected (0.01 sec) mysql> SHOW GRANTS FOR 'hmrex_db'@'%'; +----------------...
0
votes
0answers
10 views

RDS endpoints sometimes don't work

I'm just wondering if anyone else has had this issue where RDS instance is created and sometimes the endpoint doesn't work? I've tried to pin down the issue but it seems to occur even in default VPCs ...
0
votes
0answers
24 views

Is it a good idea to have a read connection point to both write database and read replica?

In my laravel app I have a write connection to a write database, and a read connection to a dns server that is connected to a single read replica (as instructed here) In the past the dns server was ...
0
votes
1answer
46 views

How to troubleshoot hung queries in PostgreSQL RDS?

I have strange behavior from an Amazon RDS instance running PostgreSQL 9.6.11. This is new behavior from a system that has otherwise been behaving properly without any changes to code in the last few ...
0
votes
1answer
29 views

Should Amazon RDS SQL Server 2017 Web Edition Max Memory settings be different from that of a locally installed instance?

We have an Amazon RDS SQL Server Web Edition on Windows Server 2012 with 2 processors and 8GB RAM. Should I configure the Max Memory similar to that of an instance on a local server i.e keeping back 3-...
0
votes
0answers
31 views

AWS aurora mysql is restarted unexpectedly

In our system one of aurora mysql instances was't available for short period. because this instance suddenly restarted at 08/14/2019 3:56JST. we already checked error log for aurora. but i found ...
0
votes
1answer
28 views

Amazon RDS instance recovery during mysqldump

I have a db.t2.small read replica, which crashes every time I run mysqldump. The issues started after I made some table changes - my main suspicion is the use of InnoDB. This replica is used as a ...
0
votes
0answers
46 views

PostgreSQL managed by AWS RDS - rdsadmin maxusedtransaction ID not shrinking

We are using AWS RDS Postgres. We reached the 200 million limit on one of the DB and triggered VACUUM FREEZE which took down the instance for roughly 40mins however the XID didn't shrink at all. We ...
0
votes
0answers
37 views

Postgres uses sequential scan with OR condition, but index scan with AND condition

We are doing a full text search on an object. Unfortunately, the object is normalized across different tables, and the full text search results in a condition with several OR, because the term can ...
1
vote
0answers
67 views

Grant Privileges on Production Database Throws “Error: tuple concurrently updated”

I would like to grant read access to all tables in my schema GRANT SELECT ON ALL TABLES IN SCHEMA public TO XXX; While it works on our alpha environment, it fails with our production database: [...
0
votes
0answers
6 views

How to restore data in aws rds without snapshot

Suppose I have snapshot at 9 AM and the data crashes at 3 PM and I want the data till 2:55 pm. How to restore data till 2:55 PM. Is there any method .if so how to do that.
0
votes
0answers
25 views

mysql.rds_history query locked for 70 seconds

SELECT count(*) from mysql.rds_history WHERE action = 'disable set master' GROUP BY action_timestamp,called_by_user,action,mysql_version, master_host,master_port,master_user,...
0
votes
0answers
52 views

Set slave_exec_mode value for RDS

I am trying to figure out a way to set slave_exec_mode to idempotent on Amazon RDS. I've checked the parameters associated with created DB instance on Amazon Console, but this parameter is not exit ...
0
votes
0answers
107 views

AWS RDS mysql deadlock

Everything in our production environment was working well. Yesterday, suddenly out of no where we were getting "lock wait" on any transaction related to a specific row. Same transaction on another row ...
0
votes
0answers
9 views

How to find the master instance of a read replica in AWS RDS PostgreSQL?

I have an RDS Postgres instance whose role is Replica. I do not see the master in the same region and probably is in another region of the AWS account. How do I find the master for this replica? ...