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
0answers
5 views

Manual Binary logging in Amazon's Aurora

How would I enable binary logging in RDS? I get the following error: Binary logging is disabled for MySQL server [1020418] (mysql_endpoint_capture.c:352) What parameters do I need to change in ...
2
votes
1answer
1k views

Configuring slave from EC2 master to Amazon RDS slave

I am configuring replication from EC2 master to Amazon RDS instance. After starting the slave, I don't see any errors but I see slave_IO: _thread is connecting. Master version:5.6.23 Slave ...
1
vote
1answer
102 views

optimizing query for slow queries

I have this query in my slowqueries table which essentially is taking about 5-8 seconds to complete the query time: SELECT s0_.id AS id0, s0_.updated AS updated1, s0_.created AS created2, ...
0
votes
1answer
20 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 ...
1
vote
1answer
1k 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 ...
0
votes
1answer
69 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 ...
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 ...
5
votes
1answer
2k views

Why am I getting permission denied on an ownership change?

My current user is pronto mediapop_staging=> select current_user; current_user -------------- pronto (1 row) This user a standard super user created on AWS RDS. mediapop_staging=> \du ...
0
votes
0answers
13 views

RDS - Backup Strategy MySQL [closed]

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
14 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 ...
0
votes
2answers
391 views

AWS KMS Encryption enable for SQL Server Columns?

Is it possible MSSQL on EC2 with a key in AWS KMS to encrypt columns
1
vote
1answer
18 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 ...
7
votes
2answers
5k views

MySQL on RDS, data transfer from one instance to another as a production job

I have a MySQL RDS instance ("production") from which I need to copy incremental data to another MySQL RDS instance ("reporting"). “Incremental data” being the new rows in certain tables. Currently ...
2
votes
1answer
98 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 at rest for AWS DynamoDB If the primary key is encrypted, how does a primary-key lookup get performed under the ...
2
votes
2answers
191 views

website performing slow once mysql connection RDS reached 50

Below the rds parameter group config, please help me to resolve this issue. I am using 4 web server having 2 CPU and 8 GB ram and rds having 4 cpu and 16 GB ram. Once the connection reached 50 site ...
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
23 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 &...
0
votes
1answer
427 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 ...
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 ...
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 ...
1
vote
1answer
84 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
7 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 ...
0
votes
2answers
253 views

Give third-party access to AWS hosted MySQL

I have a production MySQL database hosted on AWS for an eCommerce store I work with. Employees in the firm are requesting access to our live SQL database to use with BI tools like Tableau/Qlikview. ...
0
votes
1answer
79 views

Simple Query intermittently returning 0 results

I'm having a strange problem and need help troubleshooting. if I run this query on my gallery table: SELECT * FROM `gallery` WHERE awarded = 1 ORDER BY awarded_date DESC LIMIT 29 OFFSET ...
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 ...
1
vote
1answer
116 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
167 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
2answers
4k views

pg_dump permission denied for sequence

I have a strange issue with dumping post-data section. Dump command is: pg_dump -Fc --verbose --section=post-data --no-owner --no-acl -h localhost -p 9999 -U root db_name -W > constraints.dump ...
3
votes
2answers
3k views

How to test encryption on Amazon RDS MySQL?

Our company is creating a MySQL RDS with encryption enabled. Now, as we are new to RDS, we have couple of questions related to RDS. Once we create a MySQL RDS with encryption enabled, how will we ...
0
votes
1answer
90 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
1answer
569 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 > ...
1
vote
1answer
79 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
802 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
17 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 +----------------------...
0
votes
2answers
83 views

Mysql replication with c

I have huge database on MySql and It's become more and more huge. So, Now I am facing performance issues with my database. Some of tables has millions of records in it. like my login detail table ...
0
votes
1answer
112 views

AWS RDS MySQL database created but cannot create indexes or change collation

AWS RDS MySQL 5.6.x issue: Created a MySQL database on the AWS RDS platform. Created a dozen tables, imported data to all tables and can SELECT from all tables. Granted all privileges to user on ...
2
votes
1answer
384 views

High Write Count/sec in my RDS server

Recently we have encountered seriously problem since we moved our mysql database from EC2 to RDS. We do have high cpu usage before moved to rds, but our website has a good speed for our customers. ...
0
votes
2answers
529 views

Running a task without waiting for the results in Postgres 11 on RDS

I've got a question about spawning stand-alone threads on Postgres. Here's what I'd ideally like: Have a postgres-side solution to automatically launch tasks on a schedule in their own threads. ...
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
1answer
117 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
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 ...
12
votes
1answer
825 views

UPDATE STATISTICS options fail in Amazon RDS SQL Server

In Amazon RDS SQL Server (any version/edition), create a temp table and update statistics on it. This works fine: IF OBJECT_ID('tempdb..#t') IS NOT NULL DROP TABLE #t; GO CREATE TABLE #t (id INT ...
6
votes
3answers
6k views

Is there any way to replace sql server file_guid with new GUID?

I have two databases with same file_guid. Getting following error when trying to restore second database in Amazon RDS. Aborted the task because of a task failure or a concurrent RESTORE_DB ...
3
votes
1answer
212 views

Postgresql- how to rotate table partitions, trunc oldest every day?

I need to create a partitioned table with 4 rotating partitions for 4 days, and every day truncate the oldest partition. I know how to create table partitions on postgres, but I can't understand how ...
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 ...

1
2 3 4 5
14