All Questions
Tagged with mysql amazon-ec2
190
questions
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
1
answer
516
views
MariaDB randomly crashes
I've encountered a peculiar issue related to my MariaDB database instance (version 10.2) that causes my MariaDB service to stop unexpectedly. I've attempted to investigate the problem by regularly ...
- 19
0
votes
2
answers
257
views
EC2 instance randomly crash
My EC2 instance kept crashing, here is the syslog, can server admin expert share some insight?
https://pastebin.com/jfP8qhZX
- 217
2
votes
0
answers
698
views
Mysql consume lots of space in ubuntu 20.4
I need help regarding my application deployed in ec2 instance using T3 medium and Ubuntu 20. My problem is, I encountered a server error twice, it happens 3 months after each error. Prior to server ...
- 121
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
0
votes
0
answers
34
views
500 Gateway with EC2 m5.2xlarge
I have an EC2 m5.2xlarge
with wordpress and the following server configuration:
https://pasteboard.co/JwP5Ecg.png
How is possible to receive a 500 Gateway Error for importing a csv with 50 users (45 ...
- 103
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
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 ...
0
votes
1
answer
1k
views
Can not connect to mysql database using php script on AWS instance (LEMP)
I am learning AWS EC2 to host my website made on WordPress, Laravel and custom PHP scripts.
I created a t2.small instance with ubuntu 18.04 as my OS.
Then I read tutorials and Installed the latest ...
- 101
0
votes
1
answer
5k
views
Yet another PDO could not find driver issue
I've been working for the last two nights to set up my own LEMP server on Amazon ec2. I'm not a server expert so it's been slow going, and the latest error "could not find driver" is given when ...
- 213
1
vote
1
answer
3k
views
phpmyadmin database getting deleted automatically [closed]
I am using aws ec2 t2 instance. Where I created few database as per my requirement.
For last few day I noticed new databases which I create getting deleted automatically. Is there any possibility of ...
- 169
2
votes
2
answers
1k
views
Installing MySQL on Amazon EC2 Instance, backup?
To install MySQL on Amazon EC2 Instance (for example: t3.medium), is there anything I need to be aware of when doing snapshot backup of EC2 Instance?
What is the right procedure to install MySQL on ...
- 153
1
vote
1
answer
203
views
ec2 out of memory from apache random spike
Over the past year, we had consistently random spikes which caused apache to use all the memory and swap out.
Server Uptime
I have an example of the latest crash (5:30AM - 12:00PM UTC).
OOM Kernel ...
- 11
1
vote
1
answer
2k
views
How could I connect MySQL Server (on a EC2 ) from another EC2?
I create two instances on EC2 (CentOS 7). I am trying to deploy MySQL InnoDB Cluster. When I add instance (slave) I found master cannot be connected.
I can use GUI tool on my local to connect the ...
- 123
-1
votes
1
answer
168
views
can't connect mysql server on windows server from home computer
I install MySQL Server on a Windows Server from Amazon EC2 with all default config (port 3306 is open).
I edited Security Group on AWS to open port 3306 like this
But every time i try to connect ...
0
votes
1
answer
2k
views
How to flush mysql remote hosts cache?
The mysql instance is a third party Heroku addon: JawsDB.
Host:
s554ongw9quh1xjs.cbetxkdyhwsb.us-east-1.rds.amazonaws.com
Command:
mysqladmin -h s554ongw9quh1xjs.cbetxkdyhwsb.us-east-1.rds....
- 103
0
votes
1
answer
572
views
Amazon EC2 3306 timeout
I'm trying to connect to MySQL on a EC2 instance. Not RDS.
Security Group
Inbount
TCP (6) 9090 aaa.bbb.ccc.ddd/32 Openfire / Admin Con...
TCP (6) 5222 0.0.0.0/0 Openfire / Client to...
TCP ...
- 135
30
votes
5
answers
81k
views
amazon linux 2 ami - aws - How to install mysql in Amazon Linux 2?
I am trying to install mysql in amazon linux 2 ami and am not able to do it.
sudo yum install mysql56-server -> doesn't work
amazon-linux-extras list -> doesn't list mysql
I do not want ...
- 793
0
votes
2
answers
3k
views
cannot connect to aws rds mysql from aws ec2 instance via web browser
I have set up an AWS RDS instance and AWS EC2 instance, and I believe I set up the security group to allow both EC2 instance's internal ip and public ip to access the RDS instance. if I ssh to EC2 ...
3
votes
2
answers
4k
views
OOM killer shut down MySQL although ram usage seems low
Setup
EC2 t2.large instance with Ubuntu 16.04 (2 Cores, 8GB RAM)
Apache/2.4.18 (Ubuntu)
5.7.20-0ubuntu0.16.04.1 (Ubuntu)
Currently this instance hosts multiple Drupal 6 & 7 sites, around 150 ...
- 31
1
vote
1
answer
1k
views
mysql on ec2 linux AMI crashed occasionally
I have wordpress with mysql installed on a Amazon EC2 linux AMI with 1 CPU and 1 GB memory.
Recently, mysql has been crashing at least once or twice a week and I can't find out what is wrong.
when I ...
- 11
1
vote
1
answer
493
views
Cannot access RDS (public mysql) from EC2 on another Aws Account
I have a public RDS mysql that I can access locally from my pc. When I try to login to an EC2 on a different account than the RDS, I cannot access it using mysql client or utilities. The EC2 has an ...
- 121
0
votes
2
answers
6k
views
Why can't I start mysql service on ec2 linux instance
I get this error when starting mysql via ssh on my ec2 ami linux instance:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/libysql/mysql.sock' (2)
Before running "mysql"...
- 103
2
votes
1
answer
1k
views
How to add new slave server to existing Mysql master slave replication
I have a Mysql Master server and Slave replication on Amazon Ec2 instance.
Currently need to add new slave server to this loop. I can take AMI of existing slave server and spin new slave server.
How ...
- 397
3
votes
2
answers
11k
views
Connecting to an RDS from an EC2 on the same VPC
I have an RDS instance running on one subnet without NAT, and an EC2 instance running on another subnet with an Internet Gateway configured, both located in the same VPC. I have configured the RDS ...
- 133
2
votes
1
answer
940
views
Setting up phpmyadmin to only connect to remote server
I've been stuck on this for a while, and was hoping you could provide some insight into what I'm doing wrong.
I have a fresh amazon EC2 (Ubuntu 16.04) instance connected to an RDS (mysql) database, ...
18
votes
5
answers
17k
views
Install of MySQL hangs on Ubuntu 16.04
I’m trying to install MySQL server on Ubuntu 16.04 using:
sudo apt-get install mysql-server
I get asked to set and confirm root password and then the install hangs at:
Renaming removed key_buffer ...
- 385
1
vote
2
answers
22k
views
How to set root password for aws ec2 with mysql preinstalled?
I have an EC2 instance with mysql preinstalled.
I need to now use mysql - therefore I need a root password, however when I try and run:
mysqladmin -u root password [aBc123DeF]
I get the following ...
- 145
0
votes
1
answer
550
views
Browser is not showing my site using public DNS on Amazon EC2 instance [This site can’t be reached]
Couple of weeks back i launched an instance on AWS free tier and i was running a wordpress site, I dont have much knowledge about so i followed all the AWS guide and did this step by step everything ...
- 11
1
vote
1
answer
169
views
Is this MySQL HA solution valid?
We are in the process of moving our MySQL DB from AWS RDS to EC2.
RDS provides us with with a solid HA solution, which we want to replicate in EC2. We've looked at MySQL Utilities and MHA, both of ...
- 3,539
2
votes
1
answer
7k
views
install mysql 5.7 to linux 6 - yum tries to install 5.7 el7?
I'm following the instructions here to install MySQL-Community-Server onto a linux 6 aws instance.
Basic commands:
wget http://dev.mysql.com/get/mysql57-community-release-el6-8.noarch.rpm
sudo yum ...
- 231
2
votes
1
answer
1k
views
mdadm, raid1: write to multiple devs but read (mostly) from one?
Is it possible to prioritize which devices are for writes/reads in mdadm RAID1 setup? I'd like to write to both devices for fault tolerance (AWS EBS and local storage SSD), but read mostly from local ...
- 217
0
votes
2
answers
141
views
Recovering an EC2 instance
I was running an ubuntu EC2 instance for about an year and I lost SSH connectivity to it after installing the latest updates. I was running a Rails application with automated capistrano deployment ...
- 103
1
vote
0
answers
352
views
Cannot connect to remote MySQL server (RDS)
When I am trying to connect to RDS from my vps, it says connection refused. When I tried connecting it from local or other vps, it worked fine.
I figured out that it must be a firewall issue on my ...
- 109
0
votes
0
answers
586
views
InnoDB causing mysqld to crash on Amazon Linux AMI
This Amazon Linux server is running a single WordPress site that is constantly crashing. The way to resolve it seems to be to run service mysqld restart and it resumes operation until it crashes again....
- 101
0
votes
0
answers
746
views
Diagnosing high Network Out (Bytes) by MySQL instance
I have an EC2 instance (r3.xlarge) with only MySQL running on it. At some points in time, this machine sends a sustained amount of information (at almost a rate of 400Mbps) for about an hour or more (...
- 1,837
2
votes
2
answers
5k
views
PHP and MYSQL on Amazon EC2 server
I am trying to set up an amazon server to display my php files for a final for one of my classes. I followed this tutorial for setting it up and when I try to run my code I get "Fatal error: Class '...
- 21
-3
votes
1
answer
106
views
Amazon EC2 vs Google App Engine [closed]
For a Vaadin App, that uses a MySQL database and must have lots of files uploaded, which cloud platform is better? Amazon EC2 or Google App Engine? Can I use phpmyadmin in both?
Better in terms of:
...
google-app-engine
0
votes
0
answers
420
views
RDS connection blocked despite security group "Allow all traffic, all ports, all IPs"
I can only connect by ssh-ing into my ec2, and then using mysql from the cli.
I can not connect:
ssh-ing into my ec2, and connecting from PHP
mysql command line on my local machine.
I cannot ...
1
vote
1
answer
1k
views
RDS to EC2 mysql replication
I would like to create a RDS mysql and to replicate it to an EC2 server so the DB will be local and thus the query time will be faster (the EC2 is a web server).
According to the second paragraph here ...
- 133
2
votes
2
answers
5k
views
Cannot connect to MySQL on EC2 over tunnel
For security reasons we want to connect to MySQL running on EC2 over ssh. We have other servers where we do this with no issues, but for some reason on EC2 it's not working. The instance is running ...
- 173
0
votes
2
answers
2k
views
Using MySQL with Ejabberd
I'm trying to integrate MySQL into Ejabberd but I'm constantly facing problem with it. I'm working in AWS EC2 environment and I have 1 EC2 instance that has MySQL, Ejabberd and latest Erlang (Version ...
- 101
3
votes
2
answers
6k
views
Amazon RDS instance and hostname resolution
I have a question about EC2 and RDS instances.
I'd like to restrict connection to the database only from one particular EC2 instance using MySQL users.
Security groups allow MySQL communication from ...
- 43
1
vote
1
answer
373
views
connect mysql server installed on t1.micro instance from vpc t2.micro instance
I have mysql database server installed on ubuntu in t1.micro ec2 :
Instance state: running
Public IP: 50.xxx.xxx.xxx
Instance type: m1.medium
Elastic IP: 50.xxx.xxx.xxx
Private DNS: ip-xxx-xxx-xxx-...
-1
votes
1
answer
374
views
Why the latency increases on highload? [closed]
We have a system built on AWS. We use Beanstalk, we have autoscaling, our database (mysql) is hosted on RDS. We use apache and php. We wanted to test our system on highload. So, we chose large ...
- 139
0
votes
1
answer
1k
views
t2.micro EC2 Ubuntu, t2.micro RDS MySQL. Server crashes after DB reaches ~60 connections [closed]
So I have the following setup:
Server - t2.micro ECU Ubuntu instance
Database - t2.micro RDS MySQL instance.
The stack is a basic LAMP stack with default Apache settings.
I am basically running ...
- 109
0
votes
1
answer
199
views
Current setup maxing CPU. Need help designing AWS architecture and MySQL Clustering via AWS RDS instances
My company runs a mid-sized eCommerce (30,000-50,000 unique views monthly) shopping cart using X-Cart as a back-end. We are in the processing of redesigning and upgrading our back-end software. We are ...
0
votes
0
answers
102
views
Connect to a Server from my AWS EC2 instance
I have a app running on AWS EC2 which connects to a database in another server. The database connection Uri is as following,
jdbc:XXX:172.18.2.107:3306/database
This is what I got form my ...
- 169
-1
votes
2
answers
175
views
Who is responsible for performing the query EC2 or RDS?
Normally I run my own MySQL server (within EC2), but I was looking for the possibility's of RDS ( https://aws.amazon.com/rds/ ).
As I understand RDS is (directly after setup) optimized for ...
user277526
-1
votes
2
answers
4k
views
“Cannot open SSH Tunnel” on MySQL (corrected)
(help, patience and mercy... begginer lost haha)
-Ok heres the deal, im trying to connect a EC2 Instance to MySQL throught SSH in MySQL Worckbrench
-I set up the configurations this way
SSH ...