Questions tagged [amazon-web-services]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
29 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
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 ...
0
votes
0answers
11 views

Auto restart MySQL /etc/init.d/mysqld In linux AMI?

Currently I added a swap file in my linux ami 2 instance. AWS It has 4GB Added swap ram file But I want to make sure that mysql will start if it fails to allocate ram? I can start mysql like this ...
0
votes
0answers
22 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
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
1answer
55 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 ...
1
vote
0answers
329 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
41 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
69 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
21 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 ...
1
vote
1answer
1k 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
1answer
264 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 ...