Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
9 views

RDS MySQL read replica larger than master

We have a Multi AZ AWS MySQL 5.6.40 server with a matching single AZ read replica. Both have 200GB of storage available. However, the read replica is rapidly running out of free storage space, while ...
0
votes
0answers
13 views

SQL Server Best Practices on Amazon RDS [on hold]

We are migrating from an Always On Ag environment with Windows Security to an Amazon Multi AZ environment. We were told we had to move to a SQL Server user model when we go to RDS. I see ...
0
votes
1answer
13 views

Oracle AWS RDS supermaster user cant grant select on some tables

I'm dealing with some sort of issue beyond my Oracle knowledge. A customer wants to execute some queries to detect issues, locks, etc in a Oracle RDS database. I assume this queries needs database ...
0
votes
1answer
10 views

Aws RDS cpu Spike to 100% because of running set isolation command and set

My application running with the AWS RDS as a backend. currently i am doing a performance test. While doing that i am seeing RDS cpu usage goes 100% after 20min. While seeing the performance insights ...
0
votes
1answer
12 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://...
0
votes
0answers
9 views

Does it require to change date values of tables while changing the database timezone

Currently, I am using the rds with timezone UTC. While changing the timezone from UTC to EST, How could i convert the values of date field of all tables of database in EST?
0
votes
0answers
38 views

CPU usage constantly high after upgrading from Postgres 9.5 to 9.6 to 10.6

I upgraded my RDS instance (db.t2.medium) from Postgres 9.5 to 9.6 couple of days back. Since the upgrade, the CPU usage was almost 100% all the time. This brought down my application. Presuming that ...
2
votes
1answer
67 views

How to benchmark disk performance from within SQL Server?

I know of tools such as SQLIO and diskspd to benchmark IO/disk performance, but need something that can be run from the SQL Server instance itself via T-SQL, as I'm working on a Cloud-hosted ...
0
votes
1answer
24 views

How to alter system on AWS RDS?

I need to run ALTER SYSTEM SET track_activity_query_size = 16384; So I can see the contents of some long running queries (I can only see the beginning at the default size), but when I try to do ...
0
votes
1answer
22 views

Schema replication Postgresql AWS

Is there a way to replicate Postgres Schemas in AWS into one location for reporting purposes? I have 3 postgres databases (up to date with current version) running in AWS that I would like to ...
0
votes
0answers
18 views

Sharing read/write resources between connections in an unfair way

I have two applications that connect to a Postgresql database. A read-only application querying tuned MVs A write-only application updating the database and the MVs We only really require that (1) ...
0
votes
0answers
5 views

Why would PSQL on AWS RDS trigger an unexpected recovery?

Setup AWS RDS db.t2.small Postgres 9.6.3 Conditions - seen in monitoring Free mem 1GB Swap grew up to about 15 MB before the recovery Nothing unstable in any other monitoring Event logs lost not ...
0
votes
1answer
51 views

MySQL slave stuck on Applying batch of row changes (write)

I'm using Amazon RDS as a slave for my dedicated MySQL server (running outside of AWS). Replication has been working alright for the past few months, until yesterday when I updated the structure of ...
1
vote
0answers
17 views

Issue with Time Zone while migrating MySQL on-premises DB to AWS RDS

I am having MySQL 5.6 database with PST time format in on-premises server. Now we are willing to migrate the database to RDS. For this, we have taken backup from physical server and restored in RDS ...
1
vote
0answers
38 views

Amazon RDS SQL server and DBCC Checkdb

New Company and new to Amazon RDS. Several databases have been migrated to the cloud because "everything" is done for us a manager has stated. I have explained standard DBA tasks are still required ...
0
votes
0answers
16 views

Adding index only on read replica of MySQL RDS instance

I have created read replica of RDS production database for reporting purposes. Cross-team is using the replica for their use. Consumers of this replica are looking for additional indexes for faster ...
0
votes
0answers
14 views

estimating I/O for aurora from current mysql rds instance

If I have the following averages over the last 4 weeks for mysql rds instance db 1 77.7 writes/second, 8.54 reads/second db 2 108 writes second, 8.56 reads/second (2629746 = seconds in a month) ...
0
votes
0answers
45 views

Cannot revoke permissions or drop user in PgSQL AWS RDS

I want to drop the user asd from the DB. So, I've got two DBs: foo and bar and the user apparently has dependencies in both. The DBs have been created from the root user postgres, but all tables and ...
0
votes
0answers
12 views

MySQL DB Migration from on-premises to AWS through replication

I am having a production MySQL server with set of 20 databases in on-premises server. Now I require to migrate few databases from production server to AWS RDS without disturbing other databases in one-...
0
votes
0answers
46 views

AWS Aurora Database Corruption

I'm running Aurora Postgres and noticed that metric Maximum Used Transaction IDs is increasing a lot. Trying to manually vacuum the tables that's was not automatically vacuumed lead me to the ...
0
votes
1answer
28 views

Loss of 20+Gb of space and cannot find out why (amazon mysql rds)

I am trying to figure out why one of my MYSQL RDS DB instances lost 20+GB of storage space and I cannot figure out why. I have 2 RDS instances and am using some queries to compare data + free data ...
0
votes
1answer
39 views

Installing extension as non superuser on Amazon AWS RDS

I would like to allow non super users to install a specific postgres extension. Accordingly to the documentation at https://www.postgresql.org/docs/current/extend-extensions.html that is possible if I ...
0
votes
1answer
33 views

Postgres 10.5: Granting full schema access to a user that isn't the owner

So the underlying problem I'm having is trying to migrate my on premise Postgres 10.5 instance to RDS. RDS does NOT give end users the SuperUser role so I'm hitting tons of permissions issues when ...
0
votes
1answer
16 views

Increase in number of temp files being generated after increasing checkpoint_timeout

I have pgbadger set up to analyze the log files from my postgres db. I recently changed a couple of parameters in my postgres config. I changed the checkpoint_timeout from the default value of 300 ...
0
votes
1answer
33 views

Some queries not logging using RDS's SQL Server with C2 Auditing enabled

Similar to a past issue I had with audited queries not showing when using Extended Events, I'm having an issue with queries not logging when using C2 Auditing on an RDS SQL Server instance. (I would ...
1
vote
0answers
27 views

How to backup a local database to cloud database?

I am about to start developing a POS software as my new project with python and electron js. It is going to be a desktop application. However, my concern is it should work in both cases when desktop ...
0
votes
1answer
34 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 ...
1
vote
0answers
23 views

mysql RDS cpu utilization is 90 % above always for less than for 250 connections ( max conn 1236)

I'm using mysql RDS db.m3.xlarge( 4 vcpus, 15G Ram). max_connection limit is 1236 but cpu is used more than 90% for less than 250 connection. I don't know what I'm struggling to find reason. Please ...
1
vote
3answers
300 views

MySQL in AWS RDS 100% CPU on some queries

I have a managed MySQL (5.7.19) instance on AWS. In general, things work pretty well. I'm consistently around 4% CPU usage, and well below my IOPS limits for the burstable instance (t2.micro). ...
0
votes
1answer
84 views

mysqldump from AWS RDS slowing down

Im taking a db backup from AWS RDS (MySQL) slave from an EC2 (m5.large - 2c/8GB) in same AZ using - mysqldump -hxx -u xx -p --extended-insert --single-transaction --max_allowed_packet=1G db > ...
5
votes
1answer
325 views

What is the apgcc schema in Amazon RDS Postgresql?

Recently a mysterious new schema called apgcc appeared in every database in our testing Aurora Postgresql cluster (eu-west region). It is owned by the rdsadmin account. What is it, and where did it ...
0
votes
0answers
35 views

Can an Amazon RDS SQL Server link to an RDS MySQL server?

Amazon RDS for SQL Server supports linked servers, but the doc page only describes linking to other SQL Servers. I would like to link to an RDS MySQL instance, but this normally involves installing ...
0
votes
1answer
12 views

Do I need SQS queues to store remote data in the Amazon Web Services (AWS) cloud?

My first question is, do I need SQS queues to receive my remote data, or can it go directly into an Amazon cloud storage solution like S3 or EC2? Currently, my company uses a third-party vendor to ...
1
vote
0answers
32 views

AWS RDS convertible RIs do not exist, so how can I gauge whether my instance is enough before I commit for a year?

I just migrated my small PostgreSQL database to AWS RDS, and I used a db.m4.large instance class. For the first 12 hours I found the database to be performant, and here's some key metrics: CPU ...
1
vote
1answer
102 views

Question regarding PSQLException: User was holding shared buffer pin for too long

I recently encountered a strange error that I don't quite understand what could cause it: caused by org.postgresql.util.PSQLException: ERROR: canceling statement due to conflict with recovery ...
0
votes
1answer
36 views

Why are my InnoDB tables larger than calculated?

I have a DB where some of the tables are much larger than I think that they should be. For 23 of 39 tables the following query overestimates their size, as it is designed to. But for 16 tables my ...
0
votes
1answer
21 views

drop big table freeze server

I am using amazon rds mysql 5.6 master instance and 4 slaves. there is big table with 800 GIB size that i want to drop it for releasing space. But when i execute drop command, the server entering to "...
0
votes
2answers
135 views

Using MySQL 8.0 “Upgrade Checker” on RDS

The MySQL 8.0 Shell came with an "Upgrade Checker". Useful to run before upgrading, as you may detect incompatible issues with your table structure / etc. Running its python version from the shell ...
2
votes
1answer
43 views

Regularly updating table with huge amount of rows

I have a table containing (in addition to some metadata) a score and a boolean flag: CREATE TABLE scores ( score_id SERIAL NOT NULL CONSTRAINT score_pkey PRIMARY KEY, user_id ...
1
vote
1answer
379 views

Best way to pg_dump PostgreSQL on RDS to S3

I need to dump my PostgreSQL on RDS to a file on S3 periodically (to use it elsewhere than AWS). Is there a better way than running a script that runs pg_dump and uploads results to S3 using e.g. ...
1
vote
1answer
141 views

What is the optimal setting for innodb_buffer_pool_instances for a mid level AWS RDS server with 6gb buffer pool?

We have a MySQL 5.7 AWS RDS instance running on a db.m4.large instance. The basic resources for that instance type are: 7.5gb RAM 2 VCPU RDS defaults to a calculation that allocates 75% of RAM to ...
0
votes
1answer
27 views

“Could not find server error” when using INSERT SELECT statement in SQL Server

I'm trying to copy a record from a production database table into a staging database table. They are both SQL Server databases on Amazon RDS. My query looks something like this: INSERT INTO [...
1
vote
0answers
130 views

Linked server from SQL server on AWS RDS to On premises Oracle database

We are planning to migrate an on-premises Microsoft SQL server database to AWS RDS SQL server. Everything is good except one roadblock, i.e this SQL server database has a linked server to on premises ...
1
vote
0answers
13 views

User / Client IP restrictions in Postgres running on RDS

I'm looking to restrict connection access for specific accounts based on the client IP. All of our services are running on AWS so I want an account that has R/W permissions to only be able to connect ...
2
votes
1answer
224 views

Temporarily disable indexes before updating whole table

For testing purposes I periodically restore production backup into a new database (AWS RDS PostgreSQL instance) with pg_restore. In the new database I run SQL queries that anonymize sensitive data. ...
1
vote
1answer
15 views

How does an encrypted DynamoDB (the same question applies to RDS as well) query work?

I am trying to understand whether the primary key is encrypted when I choose to encrypt in rest for AWS DynamoDB If the primary key is encrypted, how does a primary-key look up get performed under ...
0
votes
0answers
61 views

Is there any way to write to CloudWatch from an AWS RDS SQL Server Instance?

For scheduled tasks running against an AWS RDS server, I use a mix of apps living on an EC2 server and SQL Agent jobs. The apps can easily write success or failure to CloudWatch using the handy AWS ...
0
votes
1answer
20 views

MySQL how to migrate to new server without data lost?

I'm using AWS RDS, with 1 master & 1 slave. Just now I alter 1 of the table and hangup halfway, so I force stop the process. Now the database got some problem. Let say I wanted to instantiate a ...
1
vote
1answer
35 views

Is there any AWS RDS Utility to Manage Master Slave mysql db with read write splitting?

I am looking for a solution for production which can manage the read and write splitting on master and slave connection as i can't affford to define multiple connection string for R/W in whole ...
0
votes
1answer
495 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....