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.
We recently upgraded our AWS RDS MySQL database from version 5.7.42 to 8.0.36. We are using Django version 4.1.6. Since the upgrade, we've been encountering frequent deadlock issues, even during read...
1
answers
0
votes
133
views
asked 2 months agolg...
The index of an E-commerce website must display a list of product images, which will be updated regularly. The backend of this website is developed using Spring Boot. Each time the index page loads,...
2
answers
0
votes
270
views
asked 2 months agolg...
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
158
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
157
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
422
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
256
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
319
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
216
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
196
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
158
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
252
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
396
views
asked 2 months agolg...