Questions tagged [amazon-web-services]
The amazon-web-services tag has no usage guidance.
27
questions
0
votes
0
answers
30
views
Automatically killed Mysql database restoration
I have 9 databases in AWS RDS aurora mysql. it's size around 500GB so I want to migrate all databases to azure MYSQL. The database aren't in use so no need to live replication or anything. I just dump ...
Aravind rajamani
0
votes
1
answer
26
views
Do I need to restart microservices pointing a database (through hostname) after changing IP address behind?
I am working with a team that developed many microservices/apps that point to an SQL server database through a host name, eg. sqlserver.aws.qc1 (yes, it is hosted in AWS).
The company has decided ...
- 103
0
votes
0
answers
15
views
Are AWS Lambda functions actually EC2 instances under the hood?
I’ve heard that AWS security groups are essentially firewalls that can be applied to EC2 instances. Since you can apply security groups to many things in AWS, including Lambdas, I’m wondering if many ...
- 171
0
votes
0
answers
111
views
Loading a csv file in to remote Mysql DB
I have a 70Mb csv with 1.5 million rows with 270 columns and I would like to put it into a MySQL database that is hosted on AWS RDS with the minimum layer. I try to do it with the MySQL Workbench ...
0
votes
2
answers
375
views
AWS RDS Sql Server READ_COMMITTED_SNAPSHOT
We're currently running Multi-AZ SQL SERVER (Mirroring) and would like to turn READ_COMMITTED_SNAPSHOT on. It doesn't look like this option is available in the parameter group or rdsadmin stored ...
- 13
1
vote
0
answers
425
views
Refresh materialized view on Postgresql 11 on RDS
We are currently on Postgres 11.13 on AWS RDS. I am trying to create a materialized view that takes about 6-7 minutes to run. What is the best way to keep this MV mostly up to date? I was thinking of ...
- 111
0
votes
1
answer
616
views
AWS RDS SQL Server Instance, Question in Maintenance Plan
New to cloud and have questions on AWS RDS SQL Server Instance, Question in Maintenance Plan.
As a DBA team we are expecting RDS access and admin access on SQL box. But was limited with setupadmin ...
- 89
0
votes
1
answer
474
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
1
answer
318
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?
6
votes
3
answers
10k
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 ...
- 163
-1
votes
1
answer
57
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 ...
CharlesDeeZee
0
votes
2
answers
624
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 ...
- 109
2
votes
4
answers
2k
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 ...
- 121
0
votes
1
answer
1k
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-...
- 103
0
votes
1
answer
552
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/...
- 147
2
votes
1
answer
3k
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
1
answer
153
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 ...
- 103
0
votes
1
answer
1k
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"
...
1
vote
0
answers
544
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 ...
- 111
-1
votes
1
answer
146
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 ...
1
vote
1
answer
416
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 ...
- 121
2
votes
0
answers
3k
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 ...
- 33
1
vote
1
answer
745
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 -...
- 113
1
vote
0
answers
462
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 ...
- 11
0
votes
1
answer
52
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 ...
- 123
2
votes
1
answer
7k
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 ...
- 123
1
vote
2
answers
1k
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 ...
user129291