The Stack Overflow podcast is back! Listen to an interview with our new CEO.

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
27 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
5 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
13 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
15 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
32 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 ...
1
vote
3answers
441 views

Significantly Slower DB Dumps on AWS RDS After Turning on Encryption?

Turning on encryption on an AWS RDS MySQL instance results in significantly slower database dumps (using mysqldump). mysqldump -u test -p -h xxx.aws.com > dump.sql Is there a reason for ...
0
votes
2answers
30 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
1answer
18 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
1answer
26 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/...
0
votes
0answers
15 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
21 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 ...
-1
votes
0answers
11 views

SQL Server superuser on RDS

The user created when instantiating a SQL Server RDS instance has the following server roles: processadmin public setupadmin I can't assign some roles to other users such as bulkadmin and dbcreator, ...
0
votes
1answer
26 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 ...
0
votes
1answer
19 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
12 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). ...
1
vote
1answer
238 views

RDS import from SQL backup

I'm migrating a SQL 2008 database from a corporate data center to an RDS intance on AWS. So far I have performed a native backup which gave me a .bak file Is it possible to simply upload this to S3 ...
0
votes
0answers
16 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 ...
2
votes
1answer
525 views

Spike in AWS RDS Oldest Replication Slot lag

Does anyone know about this "Oldest Replication Slot Lag" in AWS RDS? What does it represent? I have a PostgreSQL instance on RDS (with Logical Replication switched on) for transferring data from ...
0
votes
0answers
38 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 ...
1
vote
1answer
390 views

MySQL 5.6 Bug Amazon RDS with replica. AFTER INSERT TRIGGER is not working. Solutions?

I have MasterDB and ReplicaDB in Amazon RDS environment. I need to move 1 table (MYTable) from replica to other external DB (ExternalDB). My solution (do not work) was to add a AFTER TRIGGER ...
0
votes
1answer
404 views

Best way to create a daily snapshotted read-only db in RDS?

We have a PostgreSQL db instance in RDS. In our application we need to run a daily export in the early hours of every day, the export and transformation may take some time and one issue we've found is ...
1
vote
2answers
3k views

enabling BINARY LOG on AWS RDS MySQL

Context I am trying to enable BINARY LOGs on a MySQL RDS instance. Issue I used CALL mysql.rds_set_configuration('binlog retention hours', 24) without encountering an error. And using CALL mysql....
0
votes
1answer
122 views

Does requiring SSL matter if using AWS RDS and AWS EC2 in a VPC

I have a MySQL RDS DB and am connecting it through an EC2 instance. My RDS isn't publicly accessible, so I think it can only be connected to through my EC2 instances. I see at this link https://...
4
votes
3answers
2k views

Postgres to Postgres DBLink with AWS/RDS

I am trying to use dblink functionality for Postgres 9.5.2 DB to Postgres 9.52 on AWS/RDS. On the server: CREATE SERVER myremotedb FOREIGN DATA WRAPPER dblink_fdw OPTIONS (host 'myremotedb....
1
vote
1answer
66 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
0answers
38 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 ...
2
votes
2answers
33 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 ...
2
votes
1answer
18 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 ...
0
votes
1answer
20 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?
1
vote
2answers
370 views

RDS Replication Error (Apply Error 1406 / Truncation)

I have a MySQL RDS instance as a master, created a Read Replica from it, and ran some schema change operations on it. To be specific, I changed the charset and collation of all the tables and columns ...
0
votes
1answer
97 views

MySQL create index in 1B rows table

We're trying to add an index to one of our tables in production database. CREATE TABLE `abcd_s3_metadata` ( `rowId` bigint(20) NOT NULL AUTO_INCREMENT, `sId` varchar(50) NOT NULL, `ruid` ...
0
votes
1answer
945 views

Unable to migrate local database to RDS instance

I recently created an MySQL instance on Amazon RDS. Unfortunately, I'm not able to connect to the instance from the MySQL command line. I will brief you the details. 1) I want to move/migrate my ...
0
votes
1answer
386 views

MySQL - Turkey/Istanbul Daylight Saving Time Change

Until this year Turkey was using daylight saving time, staying UTC+2 on winter period, UTC+3 on summer. This year it is decided to stay only in UTC+3. Our DateTime's are persisted on MySQL (5.26.34) ...
0
votes
2answers
55 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. ...
1
vote
1answer
406 views

RDS Postgres - pg_stat_statements is missing queryid column

I upgraded my RDS postgres instances from 9.3 -> 9.4 -> 9.5 several months ago. When installing the pganalyzer-collector tool, I got a funny error that the "queryid" column does not exist in the ...
4
votes
1answer
12k views

Multiple databases in same AWS RDS PostgreSQL instance

I have an existing database in a RDS AWS PostgreSQL instance. I need to create one more database in this instance as spinning up a separate cluster will be expensive. There doesn't seem to be any ...
0
votes
0answers
35 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
1answer
385 views

RDS Oracle SE - Performance troubleshooting options

I have an RDS Oracle SE2 instance with Amazon RDS. Our team is looking forward to move couple of applications to RDS. But we’re looking for options that are available in RDS Oracle SE to perform ...
0
votes
0answers
13 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://...
0
votes
1answer
657 views

Are the MariaDB and MySql drivers interchangeable when connecting to a MySQL backend Aurora cluster?

I saw a similar question asked before but I didn't get enough supporting information Does anyone know any new information on this? Can MariaDB connector (driver) be used instead of the MySQL ...
3
votes
1answer
74 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 ...
2
votes
1answer
1k views

The CPU utilization spikes to 80+ even with just one user on Amazon RDS (MYSQL INNODB)

These are my RDS instance configs Instance Class: db.m3.xlarge Storage 40 GB Engine MySQL 5.6.34 Multi AZ : No I have a the node.js based backend hosted in EC2 instance and also have a cloud front ...
2
votes
1answer
44 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 ...
0
votes
1answer
20 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 ...
1
vote
2answers
16 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
1answer
31 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
1answer
3k views

How change security group in AWS RDS to allow public access?

I am new to MySQL and AWS. I have set up a new (free trial) AWS account for the purpose of setting up a MySQL database server that I can access from multiple PCs. Per the AWS RDS tutorial, I set up ...
5
votes
1answer
747 views

RDS MYSQL instance rebooted and won't load INNODB table

So my production db in RDS apparently either crashed or was rebooted during a version update, and upon being restarted mysql couldn't load one of the innodb tables: as evidenced by the following error ...
2
votes
1answer
1k views

Table partition in aws MYSQL RDS master slave setup

we are looking to do a table partition in MYSQL RDS running 5.6, table size is large and takes around 6 hours to partition. Can we partition on rds slave and then later promote it to master. is this ...
3
votes
1answer
381 views

Create event trigger as non-superuser in Postgres

Is it possible to give a role or a set of attributes to a non-superuser in postgres that would allow the user to create an EVENT TRIGGER? Simple example of what (obviously) doesn't work in psql: =&...