Questions tagged [amazon-web-services]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
15 views

Cannot restore the snapshot due to option group issue

There's an rds instance which uses ms sql ee with a database that uses TDE The rds itself is configured with the option group which has the TDE option within it and the snapshot gets created with the ...
0
votes
1answer
15 views

How to export data from AWS RDS MySQL database and import to an other AWS RDS MySQL database instance

I am looking for the best way to export data from one MySQL DB instance of RDS an import into a different one automatically. Any ideas?
4
votes
3answers
149 views

Postgres select on a very large table

We've a very large table with more than 2.2 billion rows at present on Postgres 12.5. The total size of the table (including index) stands at 500 GB. There is one query that we need to do in order to ...
0
votes
0answers
71 views

S3 .sql files to RDS postgres

I have 500 Gb of .sql files stored in an S3 folder and want to execute thoses files on my RDS PostgreSQL instance (.sql files contains insert queries). I have found a command to imports .csv files ...
-1
votes
1answer
19 views

AWS RDS snapshot restore from west to east

have query related to snapshot restore . my rds snasphot are copied everday from west to east region everyday after automated daily rds backups task gets completed. However however last one month ...
0
votes
2answers
91 views

Is MySQL trigger for 100 Millions daily updates can impact data base cluster performance?

I have a MySQL (Aurora 5.7) table in data base which has 700 Million rows 9 Indexes 25 Columns 100 Million daily updates and 5 Million daily inserts Overall this table is very busy and now we need ...
2
votes
2answers
704 views

Migrating MySQL 8.0.20 database to AWS Aurora

I originally posted this question on stack overflow as I did not know this service existed and someone suggested I may get a better answer here. I was trying to use the AWS RDS Proxy service and ...
0
votes
1answer
202 views

Unable to connect to an AWS RDS read replica of MySQL

I'm not able to connect to an AWS RDS MySQL read replica. $ mysql -h my-db-read-replica.qprdbd0pavr5.us-east-1.rds.amazonaws.com -umyname ERROR 2003 (HY000): Can't connect to MySQL server on 'my-db-...
0
votes
1answer
52 views

Amazon Athena database -- is there a way to generate an Data Schema for Amazon ML in an automated way

Amazon Athena database -- is there a way to generate an Data Schema for Amazon ML in an automated way (e.g. a SQL command that would generate the Amazon-format) Please see: https://docs.aws.amazon.com/...
0
votes
0answers
15 views

Can I create another database on AWS read replica?

I am creating an MariaDB instance using AWS RDS I will also be creating a read replica of the DBinstance, what I also need is to host another DB on the replica, is it possible?
1
vote
0answers
20 views

identifying relevant incompatibilities when upgrading from version 5.6 to 5.7 for mysql on AWS RDS Instance

I currently have an AWS RDS instance based on mysql version 5.6 that I need to upgrade to version 5.7. I understand that a comprehensive list of potential incompatibilities is given at https://dev....
0
votes
0answers
16 views

AWS DynamoDB table design

related question: https://stackoverflow.com/questions/65165530/aws-dynamodb-table-design I am trying to design a schema that will support the use cases (with 1 query per use case): "get all ...
0
votes
1answer
494 views

How to setup continuous DB replication from on-prem MS SQL server to PostgreSQL on AWS RDS without reconfiguring source machine?

I am looking for a way to set up continuous data replication between an on-prem Microsoft SQL Server to AWS RDS PostgreSQL. The source table is updated once every 24 hours. The challenge here is that ...
0
votes
0answers
34 views

Advisable to run MariaDB's AriaDB engine's /var/lib/mysql/[databases] folder over Amazon EFS with transaction = 1 for the database creation process?

Advisable to run MariaDB's AriaDB engine's /var/lib/mysql/[databases] folder over Amazon EFS with transaction = 1 for the database creation process? Since AriaDB performs table level locking and only ....
0
votes
1answer
41 views

Does Postgres read blocks sequentially, even if a disk is high-latency?

I'm using Postgres on AWS EBS, when running a query that uses a bitmap heap scan and a bitmap index scan, the execution time seems proportional to the number of "heap blocks" read, as shown ...
0
votes
1answer
650 views

How to upgrade Mysql 5.5 to 5.6 without data loss on aws-ec2?

MySQL server (5.5) is running on aws-ec2 instance with following linux details NAME="Amazon Linux AMI" VERSION="2015.09" ID="amzn" ID_LIKE="rhel fedora" ...
0
votes
0answers
226 views

Unable to connect to postgresql EC2 instance from VPN

I have an EC2 instance of timescaledb running on AWS. For security purposes, my team members and I are using OpenVPN so that we have access to it and the same IP address has been defined in the ...
-1
votes
1answer
45 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
1answer
208 views

Limiting user access by subnet to Amazon Aurora PostgreSQL

How do I limit user access by IP? For example, assuming I have two non-superusers (user1 and user2), how can allow general access (only limited by security groups) to the instance/cluster by user1 but ...
2
votes
0answers
2k views

AWS MySQL RDS Replica out of disk space suddenly

We've got a MySQL RDS instance running on AWS, with a replica. From Cloudwatch I can see that there was a sudden drop in free storage space, of the total allocated storage space of 100GB. How can I ...
1
vote
1answer
274 views

MySQL 5.7 on AWS will not start, and then keeps trying to restart

A few days ago, I tried to backup my database. It is mySQL community edition 5.7 running on an AWS EC2 instance. This has always worked. The backup command was: mysqldump -h localhost -uroot -...
0
votes
0answers
188 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 ...
0
votes
1answer
32 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 ...
2
votes
1answer
4k views

Presto SQL: TO_UNIXTIME

I want to convert a readable timestamp to UNIX time in Amazon Athena (Presto). For example: I want to convert 2018-08-24 18:42:16 to 1535136136000. Here is my syntax: TO_UNIXTIME('2018-08-24 ...
1
vote
2answers
726 views

Can AWS Aurora High Availability allow different Schema on Replicas?

Our company is thinking of migrating from SQL Server to Amazon AuroraDB. In SQL Server, there are AlwaysOn and Transactional Replication - two different things. AlwaysOn is utilized more for ...