All Questions
Tagged with amazon-web-services mysql
252
questions
0
votes
2
answers
76
views
Wordpress and MySQL on same EC2 instance, different subnets. One public one Private
My goal is to have a single EC2 instance containing both WordPress and its MySQL database on same VPC and have the WordPress available on the public subnet and MySQL on the private subnet. The purpose ...
- 101
0
votes
3
answers
298
views
Upgrade mysql 5.6 to 8 not working on AWS Linux based EC2
I am working with EC2 for MySQL DB. The OS of EC2 is AWS Linux-based Ubuntu. The current version of MySQL is 5.6.50. I am going to upgrade it to 8.0. I tried to upgrade it with this command: sudo yum ...
- 51
1
vote
0
answers
42
views
Python Flask application + MySQL DB -> needing advice for the infra in AWS when latency is at stake
I have a Python Flask application and a MySQL DB with which the app connects to. The app provides RESTful APIs.
There are around 10 pairs of (Flask and MySQL DB)s. Each pair has a unique url and ...
- 111
0
votes
0
answers
84
views
Can AWS NLB be used to load balance requests to Read Replicas?
This article from Nginx describes how Nginx TCP load balancing can be used against MySQL cluster. In the first diagram, I would like to replace the Nginx LB with AWS NLB where, the MySQL cluster runs ...
- 111
1
vote
0
answers
188
views
Replicating foreign keys with AWS DMS Full load Ongoing replication - MySQL
I am using AWS DMS Full Load Ongoing Replication (CDC) to replicate data from a MySQL RDS to an on-prem MySQL server (both of them running MySQL 8). Before starting the replication process I'm dumping ...
- 11
0
votes
1
answer
539
views
Why is mysql-server not installing correctly?
I just launched a brand-new t4g.nano instance on AWS EC2. The first thing I typed in is apt update; apt upgrade; apt install mysql-server-8.0. Here's the full log:
$ ssh -i ~/downloads/*.pem ubuntu@[...
0
votes
0
answers
936
views
I am not able to install MySQL on Amazon Linux
Step #1: – Remove previous installed packages and clear cache
I did Step #1.
Step #2: – Setup Yum Repository
I did Step #2.
Step #3: – disable all repositories in mysql repo file.
I did Step #3.
Step #...
- 21
0
votes
1
answer
415
views
Lost Local Connection to MySQL DB that resides in AWS RDS
The MySQL DB residing in AWS RDS was made to connect with resources in the same VPC. I always had to make it publicly accessible in order to connect to it through MySQL Workbench 8.0 CE in Windows 11. ...
1
vote
1
answer
2k
views
Using AWS Blue/Green deployment, how do I modify the staging database?
AWS has rolled out a Blue/Green Deployment feature for RDS, allow you to create a staging (green) database that's in parallel with your production (blue) database. Their documentation specifically ...
1
vote
0
answers
138
views
GitLab CI Runners faild InvalidParameterCombination: Cannot find upgrade path from 5.7.38 to 5.6 , Terraform
GitLab CI Runners faild the jbo with the following error message
│ Error: Error modifying DB Instance legacy-dms: InvalidParameterCombination: Cannot find upgrade path from 5.7.38 to 5.6.
│ status ...
- 59
1
vote
1
answer
2k
views
Need to keep each binlog files to 24 hrs
We have a requirement werein we need to keep each binlog files(like mysql-bin-changelog.025249, mysql-bin-changelog.025250, mysql-bin-changelog.025251....) of MYSQL RDS to minimum 24 hrs.
However, i ...
- 13
0
votes
1
answer
340
views
Is it possible to manage read/write requests on AWS RDS?
We are planning to create a read replica on our MySql Database on RDS but we want to manage this on AWS. Does AWS has a solution that manages requests and redirect them if write to the master ...
- 51
0
votes
1
answer
312
views
MYSQL server on EC2 is sometimes refusing to connect
I have hosted a MySQL DB on AWS EC2 instance(t2.micro, ubuntu, free tier). I am able to connect to it and store data. But most of the time, I am unable to connect to it via workbench or my app. But my ...
- 1
0
votes
0
answers
299
views
Failed to connect to remote MySQL server via proxy
I am trying to use an R tool in which RMySQL is one of the package being used. I am working this on ubuntu behind a corporate proxy but having the following issue for three days persistently.
Error ...
- 1
0
votes
1
answer
287
views
Enable mysqlx plugin on AWS RDS
Is there any way to enable the mysqlx plugin on an AWS RDS running MySQL 8?
When I do a SHOW plugins, it shows that the mysqlx plugin is installed, but DISABLED.
I have some C++ code that's using the ...
- 111
0
votes
1
answer
227
views
Converting a Medium Sized Database from one charset to another with minimal downtime
Our company (small business) had recently taken on new business in an APAC region which requires us to support 4 bit characters across our MySQL 5.7 DB.
This requirement means that we need to convert ...
- 101
0
votes
1
answer
80
views
MySQL Server Scaleing with AWS issues
MySql server doesn't seem to be scale up correctly when scaling up my AWS instance. Its almost like MySql is cacheing the instance sizes.
This happens after a scale down the AWS instance and then when ...
- 101
5
votes
1
answer
8k
views
How to create a Super User Account on AWS's RDS Mysql?
The Master user has limited permissions on RDS.
I need SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privileges, and I don't know how to add them to my user.
Tried this solution from ...
- 151
0
votes
0
answers
42
views
Page Loads Error
In my production Environment I'm observing a sporadic issue where pages are taking a long time to load. In the error logs we are seeing:
PHP Fatal error: Maximum execution time of 30 seconds ...
1
vote
2
answers
5k
views
Is there a simple way to synch up two AWS RDS Mysql Instances?
I have two databases. One for development and one for production. The production database has been used for while now and we need to start development of new features, so we obviously want to try out ...
- 141
2
votes
2
answers
2k
views
Can't create free-tier AWS RDS DB
I can't seem to create a 12-month free-tier AWS RDS DB running MySQL.
According to AWS, the following requirements need to be met for a 12-month free-tier RDS DB:
750 Hours per month of db.t2.micro ...
- 23
2
votes
1
answer
2k
views
Cannot start mysql-server on Amazon Linux 2 due to dependency issues
I'm trying to install MySQL on a Amazon Linux 2 server and I can't seem to get past this dependency issue (prevents server pkgs etc being installed thus preventing me from starting a mysql-server.
...
- 21
1
vote
1
answer
117
views
MySQL user is taking more than 100% of CPU utilization
My CPU% is more than 130% but i haven;t created any user with name "MYSQL"
Here is what i am getting
Image here
0
votes
1
answer
338
views
>150Million records insert select query canceled after 12 hours AWS RDS
I have a AWS RDS t2.micro storing over 150 million records in a table from which i need to make a select insert query to another table, the purpose of this select query is to make a percentage ...
0
votes
2
answers
185
views
Given an existing unencrypted AWS EFS volume, can somebody give me a path for encrypting it without data loss?
We have discovered that we really ought to have encrypted the MySql database and EFS volume on our application, at the time of creation. We are now attempting to correct the oversight.
I've read the ...
- 259
0
votes
1
answer
802
views
How to choose right AWS EC2 instance for serving MySQL
Recently we have noticed that our application has some errors related to the MySQL load.
There are some basic queries on large database (approximately 32 GB) which takes longer time than expected.
For ...
- 101
3
votes
1
answer
867
views
Delete AWS RDS S3 Exported Snapshots
So I have created S3 Exports from existing snapshots in RDS. I would like to delete duplicated ones. But I don't see any button to delete them.
I have already deleted the files from the bucket. But ...
- 131
1
vote
0
answers
121
views
How to best MySQL configuration in AWS RDS? [duplicate]
We have an e-commerce system which is currently deployed in EC2 instance. currently MySQL is in the same server and now that we are getting high traffic now and then, we're planning to use Autoscaling ...
- 87
2
votes
2
answers
591
views
LOW IOPS after MySQL RDS Upgrade
We were hitting the upper limits of our IOPs the last several days. We provisioned more IOPS a few times. 1250 -> 2500 -> 4500. Each Step we quickly saw we were using all the available IOPS as ...
- 121
0
votes
1
answer
824
views
Managing RDS Aurora MySQL connections per user or database
I have an RDS Aurora MySQL 5.7 and a number of independent applications connected to it.
Some of them are real-time websites while others are batch services (connected mostly to the reader). A recent ...
- 445
7
votes
3
answers
3k
views
AWS RDS MySQL Slowing down over time
I've read many posts about this topic but none of them talk about AWS RDS MySQL Database. Since three days ago, I'm running a python script in an AWS EC2 instance that write rows in my AWS RDS MySQL ...
- 75
2
votes
0
answers
937
views
High CPU since upgrading to MySQL 5.7 from 5.6
We are using an AWS RDS managed MySQL db.m4.2xlarge instance with db engine 5.7.30, we upgraded from 5.6 two days ago and have high CPU since - generally 10-15% higher reaching 100% at peek. Please ...
1
vote
1
answer
602
views
AWS RDS mysql.rds_set_external_master remains disabled after setting autocommit to 1
The goal is to create a master-master replication consisting of two RDS MySQL 5.6 instances, db0 and db1. I orientate myself by this article.
So far, I have created db1 as a read-replica of db0 and ...
- 162
0
votes
0
answers
477
views
Cannot migrate database on AWS Elastic Beanstalk
I have hosted a site in AWS. I have created a RDS DB instance for the elastic beanstalk.
In my laravel app's config/database.php file, I have configured my database connection as :
'mysql' => [
...
- 101
0
votes
1
answer
98
views
MySQL: normal CPU Utilization but I'm running out of memory. Should I get worried?
I'm running a heavy python script in a EC2 instance. This script is inserting tables (financial reports) to a MySQL server. There are lots of tables, the total amount is 240.000 tables. I started the ...
- 75
1
vote
1
answer
216
views
Automate EC2 and RDS mysql service to reset mysql db
I have a CRM application (java + Gradle) in Running in AWS Ec2, backend with RDS Mysql database. This is a test app/Environment.
Scenario :
CRM app should be stopped.
Reset RDS MYSQL database weekly ...
1
vote
1
answer
132
views
Why choose AWS RDS (or any cloud RDS) instead of standalone MySQL? [closed]
I want some assistance to help me understand which solution to choose. I have a Web App with around 1000 active monthly clients, and a database of 40GB size (unzipped). At the moment I am hosting ...
- 13
6
votes
2
answers
6k
views
Remote Connect to MySql AWS Lightsail
I'm setting up a new server on AWS Lightsail and all is good, but in my LEMP stack, I installed MySql and created my DB. For some reason though I cannot remote into that DB via my DB client (using ...
- 233
0
votes
1
answer
1k
views
How do I access my non-public AWS RDS MySQL database with MySQL WorkBench?
Trying to access my database in AWS with MySQL Work Bench, but the only way I'm able to access it is by making the database public and open to all inbound traffic. This is a huge security risk and I ...
6
votes
1
answer
71k
views
How to connect to AWS RDS through DBeaver
I have a MySQL database on AWS. Here are some of the settings:
DB instance id - database-2
Endpoint - database-2.***.eu-central-1.rds.amazonaws.com
Port - 3306
Public accessibility - true
DB name - ...
- 181
1
vote
1
answer
2k
views
I can't connect to AWS RDS from Terminal with MAC OS X Catalina [closed]
I've been taking a course from Udemy on AWS and I am trying to connect to RDS using an instance. I've installed MySQL and am running MySQL Workbench. I'm trying to access my instance using terminal ...
- 21
2
votes
2
answers
1k
views
AWS RDS MySQL performance issues
We are in the process of migrating our databases from an MSSQL Server AWS RDS instance onto an AWS MySQL 8.0.17 RDS instance
Our web application uses ORM/hibernate for database interactions, with 1 ...
- 21
2
votes
2
answers
2k
views
Can't connect to Amazon RDS MySQL
I'm trying to connect to RDS MySQL from linux machine. When I test the connection with telnet, the telnet session succeeds but when I'm trying to connect to the db with the next command
mysql -h ...
- 21
1
vote
2
answers
207
views
How to create read replica from MSSQL to MySQL through RDS
I have a RDS instance with SQL Server Standard edition. This DB is used for transactions, I want to create read replica but I want the new replica to be MySQL/MariaDB or PostgreSQL. This is because we ...
- 243
0
votes
1
answer
3k
views
AWS Lightsail Bitnami Wordpress Instance with MySql
I am used to shared hosting with a cpanel. I have just started learning VPC and can't seem to wrap my head around how lightsail Bitnami Wordpress (the one-click installation) instance work.
MySql ...
- 157
2
votes
2
answers
364
views
AWS WordPress install > MySQL "Connection timed out"
Running Amazon Linux 2, installed Apache, PHP, PHP-MySQL, and WordPress. This AMI is using an AWS security group called WebDMZ, say.
Created a MySQL DB in Amazon RDS which also uses AWS security ...
- 365
1
vote
0
answers
55
views
AWS Performance Insight Huge Load from "Other" SQL
Engine: MySQL 5.7.26
Looking at my AWS Performance Insight metrics, I noticed that most of my Database load consumes the query marked "Other" Can I check what is hidden under this label?
Screenshot:
- 11
1
vote
1
answer
275
views
Load balancing for Host network is not working when access within the instance
I have designed this infrastructure.
ECS SG:
Ingress: 0.0.0.0/0
Egress: 0.0.0.0/0
ECS Cluster ASG SG:
Ingress: 0.0.0.0/0
Egress: 0.0.0.0/0
Now when I SSH to instance EC2 No 1. Sometimes I have ...
- 161
6
votes
1
answer
8k
views
Can't upgrade RDS instance from MySQL 5.7.x to 8.0.x
I need to recover data from an old 5.6.x snapshot. With a little bit of tinkering, I managed to get the 5.6.x snapshot restored on an m3.xlarge instance (any instance type other than m3.* won't work)....
- 601
0
votes
1
answer
944
views
How to decide right time to start using read replica in MySQL
I have an ecommerce website with around 30,000 daily users with over 50,000 sessions. We are using RDS m5.xlarge instance. We are not facing any issues as such in read or write operations on day to ...
- 793