Questions tagged [amazon-rds]

Amazon RDS (Relational Database Service)

Filter by
Sorted by
Tagged with
-1
votes
0answers
17 views

Aws rds postgres randomly dies from OOM

I have pretty standard aws rds postgres with unmodified config. It works fine except that once or maybe twice a month it is restarting. At some moment freeable memory goes down, swap goes up and in ...
0
votes
1answer
29 views

Are managed databases (e.g. Amazon RDS) slower to access than database in the same machine (EC2) as web server

Imagine two cases: I have web server running in an EC2 instance and it is connected to the database in the RDS, the managed database service. I have web server and database running in the same EC2 ...
-1
votes
1answer
51 views

How to diagnose cross account EC2/RDS connection with vpc flow logs in AWS?

In AWS, made 2 accounts. account 1: A | Deployed EC2 account 2: B | Deployed RDS Want to connect from account 1's EC2 to account 2's RDS, but doesn't work. So enabled VPC flow logs to diagnose where ...
-1
votes
0answers
13 views

How to diagnose cross account RDS connection with vpc flow logs on AWS? [duplicate]

In AWS, made 2 accounts. account 1: A | Deployed EC2 account 2: B | Deployed RDS Want to connect from account 1's EC2 to account 2's RDS, but doesn't work. So enabled VPC flow logs to diagnose where ...
-1
votes
0answers
15 views

How to ignore destroy and recreate operation on AWS with Terraform?

Since did an aws provider version upgrade before, the current AWS RDS's option group has been added from 1 to 2. Maybe Terraform did it(create a new one and will delete the old one). But the old ...
1
vote
1answer
35 views

Schedule RDS upgrades/downgrades

I have a project that sends notifications to various services. Users manage their subscriptions 24 hours a day, but we need a stronger MySQL RDS instance during the week (t3.xlarge), specifically Tue-...
1
vote
1answer
46 views

How to connect RDS from a different account with allowed IP in AWS?

I have an EC2 instance in AWS account A. Its Private IPv4 addresses is 10.111.12.23. I allowed it in a RDS security group rules in account B, to make Type CIDR/IP - Inbound's Rule 10.111.12.23/32. ...
0
votes
0answers
20 views

How can I make network communicable between different accounts on AWS?

For these 2 AWS accounts, have made vpc and security groups for them. account 1 Account id: 1111111 EC2 web server vpc: name:a-web-vpc id:vpc-123 sg: id:a-web-sg account 2 Account id: 2222222 EC2 ...
-1
votes
0answers
14 views

Changing source of MySQL read-replica

We are running a MySQL read-replica on our local server (on-premise). That read-replica currently gets data from an AWS RDS instance. Now we want to move our database from AWS RDS to AWS AURORA. So,...
0
votes
1answer
42 views

>150Million records insert select query canceled after 12 hours AWS RDS

I have a AWS RDS t2.micro storing over 150 million records in a table from which i need to make a select insert query to another table, the purpose of this select query is to make a percentage ...
-1
votes
2answers
38 views

Aurora reader storage cost

that should be simple, but I cannot figure that out Amazon bills the real used storage amount for Aurora databases, not the allocated storage like for non-Aurora. there is a metric VolumeBytesUsed - ...
0
votes
0answers
9 views

AWS EFS vs Aurora

We are considering how much would it cost to use SQLite with EFS vs Aurora MySQL because we think using EFS is less complex and covers all involved database security/reliability issues We understand ...
0
votes
2answers
56 views

Given an existing unencrypted AWS EFS volume, can somebody give me a path for encrypting it without data loss?

We have discovered that we really ought to have encrypted the MySql database and EFS volume on our application, at the time of creation. We are now attempting to correct the oversight. I've read the ...
0
votes
0answers
6 views

How do I connect RDS PostgresSQL replicas sharing a VPC/subnet via fdw without public IPs?

How should I connect RDS PostgresSQL replicas sharing a VPC/subnet via foreign data wrappers (FDW) without going on the public internet? When the source replica DB resolves the other replica's ...
0
votes
1answer
65 views

How can I find the IP addresses of an AWS RDS instance

I have an RDS instance on AWS running MySQL. "Public availability" is set to "yes", and I can connect using the endpoint dns name. Using the AWS console, how can I find both the ...
1
vote
0answers
44 views

What AWS S3 class is used by RDS backup?

According to AWS RDS FAQ, "Amazon RDS DB snapshots and automated backups are stored in S3." I wonder what S3 class is used by AWS ? I want to know if RDS backups are stored only on the same ...
0
votes
1answer
64 views

Do I need 1 RDS Cluster for each DB or a single RDS Cluster for all my DBs?

Let's suppose I have 5 databases I'm going to use in my application. The application will be used by +100k users. I'm planning to use RDS Cluster with Aurora PostgreSQL. What would be best? Create 1 ...
1
vote
0answers
106 views

How to create AWS RDS user using Terraform?

I'm trying to create an application users for my Aurora RDS using Terraform. I can only find links for creating a MySQL user or a Postgresql user but not a generic one for Aurora.
0
votes
1answer
32 views

How to reduce size of my RDS mySql database of 5000 GB to 2000 GB, with all the triggers and functions intact?

I have a RDS MySql database of provisioned storage 5000 GiB. Out of 5000 GiB I am using only 1400 GiB and want to reduce size of provisioned storgae to 2000 GiB. All the tables are innoDb. I want to ...
0
votes
0answers
44 views

Debezium blocks replication between two Aurora's

I'm running Debezium 1.4 using docker and Kafka-Connect image. Debezium connector has this configuration: { "name": "connector-name", "config": { ...
0
votes
0answers
44 views

Amazon RDS PostgreSQL: Sudden increase in Read IOPS

We are using Amazon RDS to host our PostgreSQL databases. Our production instance (db.t3.xlarge, Single-AZ) was running smoothly until suddenly Read IOPS, Read Latency, Read Throughput and Disk Queue ...
1
vote
1answer
412 views

“timeout expired” when trying to connect to RDS PostgreSQL server with pgAdmin

I am trying to connect to a Postgres RDS instance with pgAdmin, and I get the vague error 'timeout expired' every single time. This situation is especially strange, because my colleagues who are all ...
1
vote
0answers
30 views

How to best MySQL configuration in AWS RDS? [duplicate]

We have an e-commerce system which is currently deployed in EC2 instance. currently MySQL is in the same server and now that we are getting high traffic now and then, we're planning to use Autoscaling ...
0
votes
0answers
19 views

Is it possible to log query response content for a MySQL database?

I have a MySQL database hosted on an Amazon RDS. The application (which is hosted on an EC2 instance) that uses the database sometimes gets a peak on its NetworkIn graph. I want to know what data was ...
1
vote
2answers
41 views

LOW IOPS after MySQL RDS Upgrade

We were hitting the upper limits of our IOPs the last several days. We provisioned more IOPS a few times. 1250 -> 2500 -> 4500. Each Step we quickly saw we were using all the available IOPS as ...
0
votes
0answers
11 views

AWS RDS: API to obtain max storage size

Amazon RDS maximum storage capacity is different per DB instance class and DB Engine for example for MySql gp2 db.m3.medium - max is 32 TiB db.m3.2xlarge - max is 6 TiB that is kinda odd is there any ...
0
votes
0answers
59 views

Aurora MySQL connections time out while idle

MySQL connections are failing when the connection is idle (MySQL server has gone away) - or when a long running query is performed. The connections seem to fail after roughly 5 minutes of activity. I ...
0
votes
0answers
32 views

AWS Aurora/MySQL server crashes with spatial query

We are using AWS Aurora/MySQL, engine version 5.7.mysql_aurora.2.09.0 and we have a spatial index on a table with ~10,000,000 rows: CREATE TABLE `foo` ( ... `lat` decimal(10,6) DEFAULT NULL, `...
-1
votes
1answer
26 views

Why a MultiAZ db.t2.small reserved instance costs two normailzed units?

I have a MultiAZ Aurora MySQL cluster with 2 db.t2.small instances, the Master and the Read Replica Now I want to buy MultiAZ Reserved Instances for both db.t2.small instances but when doing the ...
0
votes
1answer
114 views

Managing RDS Aurora MySQL connections per user or database

I have an RDS Aurora MySQL 5.7 and a number of independent applications connected to it. Some of them are real-time websites while others are batch services (connected mostly to the reader). A recent ...
1
vote
1answer
217 views

Codeignitor - under login / session load MySQL CPU spike and Fatal MySQL Deadlock

Originally posted on stackoverflow, and was recommended serverfault may be better place. I have a site using: AWS RDS (MySQL Aurora) - single t3.medium instance 4 x EC2s on a Load Balancer (fixed ...
0
votes
0answers
13 views

How to stop replication completely from master

I have a readReplica from RDS, from where iam having another replication to my local mysql. Now that I need to remove only the replication from read replica to my local mysql, I have removed all ...
0
votes
2answers
62 views

How do we install custom fonts on SSRS in AWS MS SQL hosted on RDS

We are using the new SSRS option on the AWS RDS, we have to install a custom font for a report that we are working on. I have checked the documentation and we notice that there is only option to ...
3
votes
1answer
123 views

Create Postgres index on RDS is far slower than a weaker linux host

Background: Postgres 10.9 DB runs as a docker container on the dev hosts. (t3.large, gp2 500GB storage) DB runs in RDS for staging and production. (m5.2xlarge, gp2 1TB storage) Everything works ...
0
votes
1answer
35 views

Recreate encryption Keys in MS-SQL RDS instance on AWS

We are running Microsoft SQL server Standard edition running on AWS RDS, We had recently upgraded from sqlserver-se version 14.00.3223.3.v1 to version 14.00.3281.6.v1 as per the recommendation. We had ...
1
vote
1answer
114 views

How to implement this AWS RDS Purchase recommendation?

I have 2 RDS databases size db.t2.medium. I went to AWS recommendations and got this: So far I've done only EC2 reservations. I am not sure how to proceed from here. First I guess I have to make the ...
2
votes
0answers
236 views

High CPU since upgrading to MySQL 5.7 from 5.6

We are using an AWS RDS managed MySQL db.m4.2xlarge instance with db engine 5.7.30, we upgraded from 5.6 two days ago and have high CPU since - generally 10-15% higher reaching 100% at peek. Please ...
2
votes
1answer
207 views

Why does RDS have warm-up [closed]

I have a t3.micro postgresql (storage autoscaling) instance on AWS RDS. If I wait for something like 30 minutes after making an initial query and make the same query again, it takes up to 10 seconds ...
0
votes
1answer
279 views

RDS MySQL Insights: Top Query “commit”

We are trying to reduce the load on our AWS RDS instance by going through the performance insights. The top SQL statement listed in the insight is "commit": In particular, the commit ...
1
vote
1answer
1k views

OperationalError: could not connect to server: Operation timed out - when trying to change database from sqlite to postresql

I have upgraded my RDS amazon db instance (postgresql database ) from micro to small. Although it says that it is available on the amazon console, I keep getting the error (psycopg2.OperationalError) ...
1
vote
0answers
107 views

AWS RDS mysql.rds_set_external_master remains disabled after setting autocommit to 1

The goal is to create a master-master replication consisting of two RDS MySQL 5.6 instances, db0 and db1. I orientate myself by this article. So far, I have created db1 as a read-replica of db0 and ...
1
vote
0answers
91 views

Number of MySQL connections spikes, but no spike in number of queries

I am running LAMP stack with CakePHP and MySQL compatible AWS Aurora instance. The Aurora instance is set up with a writer and read replica. Using CakePHP request routing, the read replica is only set ...
0
votes
1answer
54 views

Migrating Magento 1 db to Magento 2, Database is on Amazon RDS and the other is local to the new server

The company handling the migration is using a tool called UB Data Migration tool to migrate the magento website from 1.x which has its database hosted on Amazon RDS to a new amazon instance that ...
0
votes
0answers
69 views

AWS RDS - Bottleneck

Working with AWS RDS for a couple of days right now, and i am a little underwhelmed by the time it takes to connect to the AWS RDS i did setup. My AWS RDS Server is a db.r5.large, in the same region ...
0
votes
0answers
92 views

Cannot migrate database on AWS Elastic Beanstalk

I have hosted a site in AWS. I have created a RDS DB instance for the elastic beanstalk. In my laravel app's config/database.php file, I have configured my database connection as : 'mysql' => [ ...
0
votes
1answer
1k views

How to change hot_standby_feedback parameter for an existing database replica in RDS

I have a primary database instance and its read replica, both running on Amazon RDS for PostgreSQL. Recently the replica started to get a lot of canceling statement due to conflict with recovery ...
0
votes
1answer
45 views

MySQL: normal CPU Utilization but I'm running out of memory. Should I get worried?

I'm running a heavy python script in a EC2 instance. This script is inserting tables (financial reports) to a MySQL server. There are lots of tables, the total amount is 240.000 tables. I started the ...
3
votes
1answer
82 views

does / should RDS have egress access outside of VPC?

I've done a little digging but struggled to come up with a definitive answer, for RDS should/do the require any form of external access i.e outside of VPC for server updates, ntp etc? Assuming it's ...
0
votes
0answers
52 views

mysql storage filling up 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
28 views

AWS data storage: how much to store with Cognito

I am new here. This is rather a choice-based question rather than purely technical one. Many mobile apps authenticate with Cognito, and I am going to use the same for ease of use + free tier ...

1
2 3 4 5
10