Questions tagged with MySQL
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Is there any way to force the Green instance in a RDS MySQL Blue/Green deployment to be warm? The lazy-load is making our upgrade plans very hard because any query is impossibly slow for any real-life...
2
answers
0
votes
155
views
asked 2 months agolg...
I'm trying to upgrade my MySQL instance from v5.7, up to v8.0. At first it threw an exception, as I was using a custom parameter group. I switched the parameter group back to default, performed an...
1
answers
0
votes
151
views
asked 2 months agolg...
This is my second attempt at this. I have restored a snapshot of a working DB backup to a brand new instance. I used identical settings to the original, and allowed it to create a new VPC, new...
3
answers
0
votes
412
views
asked 2 months agolg...
If an RDS has a writer and a reader instance. If I then want to complete Analytics work by connecting to the Reader instance. Given that both instances connect to the same DB. Is there a potential to...
2
answers
0
votes
248
views
asked 2 months agolg...
**The main issue is the replication lag that isn't decreasing**
Good to know: the replication on mysql5.7 with the same setup, multi-az, same instances and storage was almost perfect with only some...
2
answers
0
votes
305
views
asked 2 months agolg...
I am trying to establish a connection from my lambda function to RDS instance (Aurora MySQL) using [TypeORM ](https://typeorm.io/)
Scenario 1:
When trying to connect to RDS instance using...
1
answers
0
votes
214
views
asked 2 months agolg...
My databases in total size are 20 GB. But the RDS instance had a storage full error and enabling auto scaling it went to 1.6 TB.
20 GB vs 1.6 TB is crazy. I have looked at logs, double checked DB...
1
answers
0
votes
192
views
asked 2 months agolg...
I am trying to use WHL file which contains all the packages and glue connection for etl job, The job is not getting initiliaze and is not populating or creating the logs and job run remains in running...
1
answers
0
votes
156
views
asked 2 months agolg...
1. I'm encountering an issue with RDS connections where they're not being properly deleted after disconnection. This results in a rapid increase in the number of connections, even though they're not...
2
answers
0
votes
249
views
asked 2 months agolg...
Hello, I have a public EC2 running on Windows (using as a bastion host to connect to the private ec2 only) is unable to reach to the port 3306 running on Linux EC2 in private subnet. I have opened the...
7
answers
0
votes
391
views
asked 2 months agolg...
The default parameter group for MySQL8.0 sets `replica_exec_mode` to `IDEMPOTENT`. I couldn't find any documentation why RDS decided to do it.
The default is `STRICT`. IDEMPOTENT would skip errors...
1
answers
0
votes
231
views
asked 2 months agolg...
Test Endpoint failed: Application-Status: 1020912, Application-Message: Cannot connect to ODBC provider ODBC general error., Application-Detailed-Message: RetCode: SQL_ERROR SqlState: HY000...
1
answers
0
votes
325
views
asked 2 months agolg...