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
14 views

Restore specific MSSQL backup from media set using AWS rds_restore_database

I have backed up several Microsoft SQL Server databases to a single media set (.bak file). I have uploaded the database to S3 and am now trying to restore the database using the following script where ...
0
votes
0answers
10 views

How restore a Postgres database on AMAZON RDS when the file is in another server?

I'm around 2 days to simply restore my database to an AMAZON RDS server. The tutorial page from AMAZON is so bad that I can't do a simple task like this. I have db_example.bak file on my local machine ...
0
votes
0answers
13 views

RDS - Backup Strategy MySQL

I'm looking for an approach to start my Backup strategy using RDS MySQL database. I need to implement a recovery point time strategy if something goes wrong with my database I would restore this ...
0
votes
1answer
20 views

Cannot upgrade to v12 due to sql_identifier data type

I am attempted to upgrade Postgres 11.8 to 12.3 on an AWS RDS instance. The upgrade fails with the following error: Your installation contains the "sql_identifier" data type in user tables ...
0
votes
0answers
13 views

Unable to grant privileges with admin account

I'm running MariaDB version 10.4.8 on Amazon RDS. Once the server is up and running, I need to create some databases, users and grant privileges to those users. Creating the databases and users works ...
1
vote
1answer
17 views

Why are my queries in idle state?

I'm new to postgres , I've aws rds instance running postgresql with engine version 11.5. All my queries are clientRead has the wait_event. Why do I have all my queries in idle status.Does this mean ...
0
votes
0answers
11 views

How much time would it take for synchronizing between master and slave in Mysql on AWS RDS?

I implemented Master Slave for RDS Mysql database. The sync time for 1 GB was very less. Can I predict time for 20GB to synchronize? Master DB Slave DB Can I also predict the time and load on the ...
1
vote
0answers
22 views

What does KEY SHARE OF in a PostgreSQL statement mean?

Given the following SQL, what does "ONLY", "OPERATOR(pg_catalog.=)" and "FOR KEY SHARE" do? SELECT 1 FROM ONLY "public"."acmeinstanceinfo" x WHERE &...
1
vote
0answers
9 views

Process with Command 'Killed' and State 'Executing'. Not getting killed

Last day, when I ran a count(*) query on a table. It didn't provide any results. It ran forever even. So I tried killing those queries (I have tried it multiple times). As I'm using AWS RDS, I killed ...
1
vote
0answers
24 views

Is it bad practice to leave the master database at a lower compatibility level after an in-place upgrade? [duplicate]

Based on this documentation, Microsoft intentionally leaves the master database at the previous compatibility level after an in-place upgrade. I recently performed an in-place upgrade from 2012 to ...
0
votes
0answers
6 views

RDS Mysql: Parameter to kill idle transactions

From time to time I see some long-running idle transactions in my MySQL database. I need to set timeout for such transactions. Therefore, I want to know if there is something like PostgreSQL's ...
3
votes
0answers
52 views

RDS MSSQL in-place upgrade how to update master db compatibility level when rdsa account is db owner

Background My workplace infrastructure team ran a typical in-place upgrade of an RDS MSSQL instance to update the version from 2012 to 2017. After the upgrade, while logged in as the "master ...
0
votes
0answers
11 views

Password validation in AWS RDS Postgres database

Is there way we can check/set password validation for PostgreSQL RDS database? like in MySQL we have password validation plugin. How long password should be/password expiration date etc. I have ...
0
votes
0answers
16 views

Connect to RDS from EC2 that uses Elastic IP. Access denied for user

SHORT: I want to access my RDS MySQL from my EC2 instance. The EC2 has an associated Elastic IP address. I associated an Elastic IP address so the EC2 has a static IP. I can create a MYSQL user ...
0
votes
1answer
38 views

Why a query takes too long in statistics thread state in AWS Aurora MySQL?

The following query execution too long in statistics state and I couldn't figure out why. DB engine - 5.7.mysql_aurora.2.07.2 DB Size - db.r5.4xlarge Sample Query Profile output +----------------------...
1
vote
1answer
82 views

High CPU usage with MySQL RDS

I'm running t3.large MySQL instance and having high CPU usage issue. There are tons of data stored and tables in one database. After rebooting the instance everything is pretty good and all of queries ...
0
votes
0answers
25 views

AWS RDS upgrade from 8.0.11 to 8.0.19 fails

I am trying to upgrade an RDS database from 8.0.11 to 8.0.17. or 8.0.19. I started by creating a snapshot, restoring that snapshot, and then trying to upgrade to 8.0.17. The upgrade says it was ...
0
votes
0answers
14 views

Migrating data to new mysql rds instance

I have 1TB size mysql database for production . Now i want to migrate this database on new mysql RDS instance . Please suggest me which backup policy should i apply here like Mysqldump,XtraBackup . ?
0
votes
0answers
7 views

Scalling Down AWS RDS

I have a instance in my AWS RDS running SQL Server, setting up with 16 TB (this is the maximum accepted by AWS), I'd like to change this size to 2TB. Have anyone some idea how can I do it? AWS console ...
0
votes
0answers
28 views

Replication external Master to RDS Slave: Connection issue

I am trying to set up replication between my external database (master) to an AWS RDS database (slave). Both are MySQL 5.6. Please don't mark this as a duplicate. I know others have asked a similar ...
2
votes
1answer
29 views

How does Database Snapshots Work (MySQL)?

I have a MySQL database hosted on an AWS RDS instance. The database has many tables and I observed the following: I picked a table with about 1-2 million records that is indexed on a created_at ...
0
votes
0answers
7 views

MySQL8 leaves railing connections open

We're looking to upgrade our stack from MySQL5.7 to MySQL8. We are using a standard LAMP system on ubuntu16, php7.0 and symfony 2.3 . On our tests, I have noticed that there is a lot of trailing ...
0
votes
0answers
5 views

AWS Oracle Enterprise Edition RDS to Standard Edition RDS Migration

I have RDS snapshot of Oracle EE edition and want to move it to be converted into Oracle SE edition. Please help with the best strategy possible.
0
votes
0answers
17 views

Access Oracle DB from AWS RSD Mysql DB

I have two databases. One is in Oracle and the other one is in AWS RDS MySQL. How can I access my Oracle Database from AWS RDS MySQL Database?
0
votes
2answers
39 views

Change the binlog format MIXED to ROW

I have a database that is running on AWS RDS (MySQl 5.7.22). Currently, I have one master and 2 replicas running. My binlog format is MIXED. I have plans to change it to ROW based. I want to ...
0
votes
1answer
26 views

Migrate Oracle 12c to 18c in AWS RDS

Currently we have an Amazon RDS Oracle 12c instance and we need to upgrade it to Oracle 18c in a new RDS instance. What is the correct approach to do this? Can we set up an 18c instance staright ...
0
votes
0answers
29 views

MYSQL storage increasing unexpectedly (RDS)

I am total newbie to database game. & I am using mysql 8.0 RDS 20GB free tier. I don't have much data on it.(just 300 Mb) But I always get a mail that you have exceeded 85% of storage limit.(...
1
vote
0answers
17 views

Storing Analytic Data for Multi-Tenet SaaS with AWS Aurora [closed]

I have an app that a user can upload an excel sheet of analytics data to S3. I am wanting to trigger a Lambda function on upload to do some data processing and then write the analytics to a client's ...
0
votes
1answer
29 views

AWS RDS MySQL some time get slow performance when update table1 set field='any word' where primarykey=1234

Normally when update table1 set field='any word' where primarykey=1234 take 1sec. or less but sometimes random take much more time possible 500sec. or more. I was set very well and never see high CPU,...
1
vote
2answers
70 views

MySQL 8.0 table with JSON column that uses JSON “merge” operations has 500k rows but analyze table shows 7MM

I have a database table that according to TABLE STATUS has 7MM rows, but when I SELECT COUNT(*) it only has 500k rows. This is a problem because table growth is increasing and we're running low on ...
3
votes
2answers
59 views

Why is creating and dropping a random index fixing this performance problem?

I have a big heap table with 17,093,139 rows. This table is the most heavily used table in the database. Since this is a heap table, there are only non-clustered indexes in this table. I rebuild/...
0
votes
1answer
23 views

( RDS ) MySQL to MySQL migration within aws [closed]

RDS MySQL to MySQL migration I've 2 MySQL(5.7) RDS instance in my AWS account namely prod & dev. My task here to migrate all objects from Prod instance to Dev in order to make sure all prod ...
0
votes
0answers
4 views

scaling aws RDS with instant read

Question : How do I scale a DB, in which I'm doing instant reads a lot! (i.e just after writing/update I'm trying to read the same) I'm using AWS RDS and in production. currently having just one ...
0
votes
1answer
24 views

Storage problem with MYSQL read replica

I have one master RDS instance of 50 GB storage and created a read replica of the master DB with the same configuration. I use this read replica only for SELECT operations nothing else. But suddenly ...
0
votes
1answer
33 views

How to get a breakdown of CPU usage at each point in time?

I have a SQL Server RDS instance, running on a db.m5.xlarge (4 vCPU, 16GB RAM) with Multi AZ enabled. I am trying to determine the cause of a constant 25%-30% CPU load on the instance at a time when ...
2
votes
3answers
63 views

RDS MySQL 5.7 help with maximum memory usage is dangerously high [closed]

Anyone can help me out with this MySQL 5.7 server configuration please? I'm running a db.m5.2xlarge rds instance to host 5 e-commerce separate databases and running MySQLTuner against it gives me the ...
0
votes
1answer
40 views

How should we give privileges/permissions to group to access different db's

I'm new to working on RDS postgresql instance, I've a group and added a couple of users to the group. I need to give permission to users in the group to allow them to access other dbs like x ,y and z ...
0
votes
1answer
15 views

High write IOPS on MySQL instance

I posted this first in the aws forums before i learned that there's a stackoverflow for DBs but i would ask this here as well. We recently took over management of a wordpress site using a MySQL DB ...
1
vote
0answers
36 views

Performance issues after PostgreSQL v12 upgrade

Just upgraded our RDS instance to v12.2 from v11.6, and we are seeing some of the queries are performing much slower than v11.6 instance. After the upgrade, we rebuilt the indexes using - REINDEX ...
0
votes
0answers
41 views

In 8.0.17 EPSG Spatial reference systems are not available at installation? [duplicate]

In 8.0.17 INFORMATION_SCHEMA.ST_SPATIAL_REFERENCE_SYSTEMS is not prepopulated with ORGANIZATION="EPSG" records, leaving the table with only a single record, that for the default SRID=0. A count in ...
0
votes
1answer
67 views

What is the difference between Aurora Mysql 5.7.x and Aurora 2.x.x

I have an RDS instance with Aurora Mysql 5.7.12 and I noticed that there are other versions of Aurora Mysql 5.7, but I don't understand what is the difference between them. Some of the version ...
1
vote
1answer
56 views

MySQL version 5.6.35 RDS DB Instance crashed with error code 6

DB instance is running on MySQL version 5.6.35 Please see below for more details... Is it a bug in this version which needs an upgrade to a later version or there is something to look at the memory ...
-1
votes
1answer
22 views

Connecting to RDS MySQL from command line sometimes fails — why?

I have used RDS for many years, and MySQL for even longer, so I am very familiar with both -- yet, I am running into an odd thing that I cannot figure out. Wondering if someone can help. I have 2 ...
0
votes
0answers
15 views

AWS RDS Fine Grained Access Control using IAM Authentication

Is it possible to limit a users access to specific 'databases' within an RDS DB cluster using IAM authentication? Looking at this documentation I can't see any obvious Conditions that would allow ...
1
vote
0answers
51 views

How to check RDS MySQL database synchronization status

We were creating a read replica for an RDS MySQL (5.7.28) instance, and before the read replica became available one of our developer accidentally connected to the read replica and was able to write ...
0
votes
1answer
42 views

Grant privileges to tables in all (dynamic) schemas

We've setup an AWS Database Migration Service which migrates schema and tables from multiple sources. The rule for migrating from source can be a wildcard on schema, meaning a schema could 'pop up' ...
0
votes
0answers
16 views

Monitoring alert logs of Aurora and RDS postgres instance

I need to have a automation to grep the errors and receive a notification email around those errors in RDS and Aurora instances. What is the best way to approach this?
1
vote
2answers
41 views

Wordpress UPDATE queries on MySQL database stuck

I have an Amazon 24XL server 96 Cores 378 GB RAM Database size 5.7G Debian GNU/Linux 9 (stretch) PHP 7.3.16 mysql Ver 15.1 Distrib 10.3.22-MariaDB I have only one WordPress site where users read ...
1
vote
1answer
26 views

Speed up AWS PostgreSQL insertion via Python script

I have 120,000 csv inside my AWS EC2 instance, each containing 120,000 rows. I can't insert each of them as is into my AWS RDS postgresql DB, that will be 120,000^2 = 14,400,000,000 records. Each csv ...
0
votes
0answers
17 views

MYSQL query working fine in AWS RDS instances with 1 vCPU but hangs if running in instances with 2 vCPU or more

I have this following SQL query below executed in a Lambda function. The Lambda function connected to AWS RDS running MySQL 5.7.22. When this query is executed against an instance type db.t2.small ...

1
2 3 4 5
14