A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

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
0
votes
1answer
9 views

Upgrade all MySQL columns, tables, and databases from utf8mb3 to utf8mb4

I have thousands of columns across hundreds of tables in about a hundred databases inside a MySQL instance that need to be upgraded from utf8mb3 to utf8mb4. Is there a way to generate ALTER ...
0
votes
0answers
7 views

Combining MySQL instances on AWS RDS and EC2

What kind of restrictions on RDS can be a problem when I am trying to combine RDS databases and multiple MySQL running on EC2?
0
votes
1answer
15 views

Optimization: Increase Innodb_pool_size useful?

We run an AWS RDS instance with 8vCPUs and 64GB memory. All tables are using InnoDB engine. I have kept the default setup of innodb_pool_size to be half the memory. What I see is that almost 30Gb of ...
0
votes
0answers
12 views

Get Maximum query execution time on amazon RDS replica

On amazon rds I have a single master database with 2 read-only replicas. Because of ERROR: canceling statement due to conflict with recovery error I thought instead of setting hot_standby_feedback=on ...
0
votes
1answer
19 views

How I can monitor Amazon RDS Postgresql table size once the `hot_standby_feedback` is on

I have a postgresql Master-Slave replication scheme and because of query cancelation due to conflict with wal I need to set the following setting to each replica: hot_standby_feedback = on But ...
1
vote
1answer
23 views

Could once `max_standby_archive_delay` and `max_standby_streaming_delay` with value -1 can cause replication stop on heavy loads?

In my replication servers on a postgresql master-slave replication scheme on aws RDS I get the following error: SQLSTATE[40001]: Serialization failure: 7 ERROR: canceling statement due to conflict ...
0
votes
0answers
11 views

MySQL replica is lagging without resource saturation

I am running MySQL 5.6.41 on AWS RDS. I have one multi-AZ master and one multi-AZ read replica. It is a vanilla configuration MySQL configuration, so the binlog is in MIXED format and the replication ...
0
votes
0answers
10 views

Does replica config parameter affect primary/master RDS Postgres?

I want to add hot_standby_feedback = on to a RDS readonly replica. The problem is that the replica currently has a parameter group already attached, which is inherited from the master. My question is:...
0
votes
0answers
7 views

AWS Aurora RDS 2nd reader gets no queries

Running a Postgres Aurora RDS with one writer and two readers. One reader is used heavily, but the other is barely used at all according to CloudWatch. The Laravel application this is connected to ...
0
votes
1answer
17 views

How the transaction logs are maintained in MSSQL RDS?

Just curious, I was asked that if RDS takes transactional log / incremental log backup for point in time recovery, does RDS shrink the logs too? In MSSQL instance, we shrink logs if transactional ...
0
votes
0answers
6 views

Recover lost space from failed create table from another table

AWS RDS Postgres 9.6 - I was performing this on a table of 1.7 billion rows: CREATE TABLE raw_data_smaller AS SELECT id, updated_dt::date, status, price FROM raw_data; I realized it was running ...
0
votes
0answers
12 views

AWS RDS Mariadb Federated/Connect

I believe this is a firewall rule problem. Therefore, I believe that the issue is finding out what the public IP address of the RDS is. I don't see that anywhere on the RDS interface. I have two AWS ...
0
votes
1answer
85 views

Verify if the client is connecting to the Oracle database using native network encryption

My environment is as below - Server: Oracle 12C 12.1.0.2.v17 ( AWS RDS Service) Client: Windows 2012 machine with Oracle 19C 64 bit full client Tools : SQL Developer and Toad on the client machine ...
1
vote
1answer
33 views

What does RRQMS and WRQMS mean?

I found a possiblity to display Rrqms and Wrqms graphs in AWS RDS Enhanced monitoring page (I use Postgres 9.5.19) but I can't find any detailed explenation about these parameters. By googling I only ...
2
votes
0answers
65 views

Linked Server: An error occurred during decryption

We're running a SQL Server instance on AWS RDS. I believe this is a 2017 instance. We also have a couple of Linux EC2 instances running SQL Server (not sure the version, but I assume 2017) Our RDS ...
0
votes
0answers
21 views

Is there a way to create tablespace in MySQL RDS

I'm using AWS RDS MySQL instance and using it. Now I want to create table space and assign table space to tables. Is it possible in MySQL RDS
1
vote
0answers
27 views

ALTER TABLE … ADD COLUMN … NOT NULL is not instant in PostgreSQL 11?

I have read the documentation and it states that adding a column with a non-null and non-volatile default value should not require a table rewrite. However, this does require a rewrite and blocks all ...
1
vote
2answers
41 views

Find rows in a single table where values in a certain column are near-duplicates

I have a Postgres 11 table on RDS containing a column email; some of the values in this column [and only that column] are clearly de facto duplicates but differ in case, i.e., different capitalization,...
1
vote
1answer
52 views

RDS MySQL 8.0.16 has empty “INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS” table

On aws RDS I have an mysql 8.0.16 instance running. My problem is now, that the INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS table is empty. This is a problem for me because I would like to create ...
0
votes
0answers
26 views

AWS RDS Server Over Spec'd?

I wanted to check if my AWS RDS server is over spec'd, it currently costs loads of money and we are trying to reduce our costs. We are using a db.m5.2xlarge (32 GiB memory / 8 vCPUs / 5000 IOPS). ...
0
votes
1answer
35 views

Semantic version type on PG 11.5 deployed on RDS. ltree?

I've got some semantic version details to store, and figured a dedicated type would be a bit help with searches and sorts. At least one implementation exists: https://github.com/theory/pg-semver ...
3
votes
1answer
56 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
32 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
40 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
1answer
35 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
1answer
50 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
72 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
108 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
78 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
10 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 '...
1
vote
0answers
49 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
33 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
45 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
87 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
17 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
28 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
43 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
15 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
44 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 ...
1
vote
0answers
45 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
443 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
43 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
85 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
23 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
37 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
28 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
80 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
65 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
42 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
246 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 ...