-1
votes
0answers
23 views

Amazon EC2: ssh_exchange_identification: Connection closed by remote host, How can it be fixed? [on hold]

I have setup a Wordpress site on an Amazon t2.micro free tier instance, but every 15 I get this error: ssh_exchange_identification: Connection closed by remote host wordpress Can anyone please help ...
3
votes
1answer
135 views

Latency & speed considerations between 2 servers on Amazon EC2

I'm setting up a system that consists of: 2-4 database servers 2-4 webservers (running Node.js) The webservers use the database servers heavily. Aside from connecting to the private IPs of the ...
0
votes
1answer
58 views

installing phpmyadmin for remote db host

I am having trouble trying to install phpmyadmin. We are using AWS services for our servers. Our mysql db is located in an RDS instance. Now I am trying to install phpmyadmin on an EC2 instance. I ...
1
vote
0answers
18 views

Issue while setting up a DSN while creating a linked server

I am trying to set up a linked server to my sql from sql server. However I am encountering problems while setting up the dsn. Reffering this link for help. My MySQL database resides on Amazon ec2 ...
0
votes
1answer
83 views

update and insert MySQL DB on AWS RDS with local MySQL DB

I have created an RDS database and have used mysqldump to send all my local data to that remote database using the following commands: $ mysqldump -u root fishDB > localDB.sql $ mysql -h ...
0
votes
0answers
51 views

MySQL stops working on AWS ec2 instance periodically for no reason

I run a development server on AWS which has worked perfectly fine without a hitch. Recently, periodically the mysql server starts to not work. I then type in service mysqld restart which yields ...
0
votes
1answer
76 views

Single ec2 instance with multiple mySQL databases on separate EBS volumes

I have a single ec2 instance on which I am running multiple separate wordpress sites. I want to store the database for each separate site on it's own mounted ebs volume, so that I can handle the db ...
0
votes
1answer
99 views

Amazon RDS suddenly not working and unable to connect

I'm using an Amazon RDS with MySQL, and I connect to it via another EC2 machine. I correctly set the Security Groups; and it has been working good for two days. Today, for a test I scaled the RDS ...
0
votes
1answer
4k views

RSA certificate configured for SERVER does NOT include an ID which matches the server name

I recently started a LAMP server (all the latest versions) w/ WordPress on it, and I'm trying to install a SSL certificate that I recently purchased. When I restart apachectl, error_log gives me this: ...
0
votes
1answer
390 views

Amazon AWS EC2 and RDS: How To Increase MySQL Query Cache?

I tried to find information about this, but can't find anywhere. The only one that I could find was http://survivalguides.wordpress.com/2012/07/11/change-the-query-cache-size-amazon-aws-rds/ but it ...
0
votes
1answer
111 views

Percona on EC2 ephemeral storage (part of XtraDB cluster)

We have a MySQL DB of roughly 100GB and want to move it into EC2. EBS volumes seem fairly slow for running MySQL databases (even with provisioned IOPS) and although we could use RAID10 to improve this ...
0
votes
2answers
288 views

MySQL - Slow query - wp_options table. Website unable to handle traffic

After spending several days researching, I have placed a website on a c1.medium instance, Amazon Linux, and the MySQL database on a db.m1.instance. The RDS is running MySQL version 5.6.13. I have ...
0
votes
3answers
76 views

Amazon Linux EC2 Webserver / MYSQL Upgrade – Traffic causing error establishing a database connection

To give you a little background, I currently have a website that allows users to upload photos. The website was initially on a GoDaddy shared server, but recent surges in traffic have forced me to ...
-1
votes
2answers
109 views

Find Public IP Address through a Private IP Address [closed]

I have a application server (LAMP Stack) access. But php application connect to mysql from another db server. I have only private IP for this DB Server. Is their are any way to know public IP Address ...
0
votes
1answer
189 views

Failed to start production mysql server. No log messages either

This is a production instance (EC2) we are managing for a client. Downtime already 5 hours. I am screwed. The Story This morning I found one of our clients mysqld process in killed state. I did ...
0
votes
1answer
106 views

How to increase mysql back_log

I have programs using mysql heavily, and a large amount of slow queries and an even larger number of fast ones, all happening simultaneously. I want to increase the back_log variable using : SET ...
0
votes
2answers
178 views

Connect to MySQL EC2 Instance outside of VPC

I have a VPC setup with a few EC2 instances inside. I'm attempting to connect to a MySQL database on an EC2 instance outside the VPC, with no luck. I have the security groups on the VPC EC2 ...
0
votes
2answers
45 views

Keeping mysql.user host up to date when restarting instances on Amazon EC2

Whenever I restart an Amazon EC2 instance, it generates a new IP address and a new Private DNS. This is problematic since I then have to go into the database and update mysql.users to add the new ...
0
votes
1answer
193 views

problems with EC2 instance, disconnects unexpectedly

I have a problem with an EC2 instance. In the past the instance suddenly lost the connections via SSH and Web (Apache dead and the other servers), and I could not even make ping. However, when I went ...
0
votes
1answer
122 views

Why is my MySQL going offline?

I have 2 applications hosted in a windows server 2008 r2 (AWS EC2 Large instance)machine, using IIS7.5 and mysql 5.5.12. The one database is hosted on the server with a local DB instance the other DB ...
0
votes
1answer
323 views

Having problems connecting to a MySQL database running on an EC2 instance via AWS

I'm currently attempting to create a system for users to login/register an account for an iPhone app that I'm developing. I have it working on a local server, but my attempts to move it to a real ...
1
vote
1answer
977 views

/usr/bin/mysqladmin: connect to server at 'localhost' failed

I am unable to access mysqladmin on an Ubuntu server. I have tried these 3 commands and they all fail. ec2-consistent-snapshot mysqladmin -u root password 'password' /usr/bin/mysqladmin ...
-2
votes
1answer
722 views

Amazon EC2 Linux AMI MySQL Problems

I'm running a web server off of an Amazon EC2 instance, and I'm using the Amazon Linux AMI as my instance operating system (I think it's CentOS or something). Anyways for the past month or so ...
2
votes
1answer
65 views

Ubuntu EC2 instance Mysql Database Issue

I have a ubuntu ec2 micro instance where I have setted up LAMP environment with mysql/phpmyadmin as well. However, my application in every few days getting 'database connectivity issue' and when I ...
1
vote
1answer
301 views

Django - cant connect to local MySQL Server through socket

I’m using Django Bitnami Stack on Amazon EC2. I’m attempting to sync the database for the initial setup but I am having problems. When running the following command I receive an error message: ...
2
votes
1answer
54 views

Need to run windows service and MySQL, what remote/cloud service options do I have? [closed]

As the title suggests, I need to set up MySQL database which can be accessed by two (or more) different sites. The only snag with this is that we need to run a windows service alongside it (this is a ...
0
votes
0answers
42 views

Elastic IP changed temporarily, now internal messages don't work

I recently setup virtual hosting on my ec2 instance and tried assigned to IPs to it(didn't work, switched back). However my mysql database couldn't be accessed(I fixed it) and my php mailing scripts ...
0
votes
3answers
87 views

MySQL Remote Access

We have a MySQL database server which is running on a Amazon Linux Instance which we would like to connect to remotely. We have set the access for the port 3306 for our LAN gate way IP in the AWS ...
0
votes
1answer
280 views

Can't connect from EC2 to RDS via PHP. I can directly thought

I've set up an EC2 instance it has mysql and php-mysql installed (not mysql-server). I've set up an RDS instance and set the security group to the EC2 instance. I can connect via the command line ...
0
votes
1answer
212 views

AMI Micro Linux Instance, Configure tomcat7 to work with Mysql

I've installed tomcat7 and mysql55 on my ami linux micro instance. I'm trying to figure out how to configure tomcat7 to communicate with mysql, but have had no luck. I've always been a glassfish user, ...
0
votes
1answer
366 views

Unable to remote into mysql server on Amazon ec2 windows instance

I'm trying to connect to MySQL server from my dev machine(win 7) using 'Toad for MySQL'. MySQL server is located on AMI windows instance(amazon ec2). I have had success earlier with dedicated servers ...
1
vote
1answer
1k views

When connecting to mysql on ec2, what should I be using?

I'm having issues connecting to my local mysql server currently, but I need help in being able to connect to mysql from other instances also. Background: I have a java service that is installed on a ...
0
votes
1answer
104 views

mysql 5.6+ lamp AMI

I used couple of ec2 instance, ebs etc. Now I need to configure new system, and I think AMI search sucks! What I need is Ubuntu,64-bit, ebs mount, lamp+phpmyadmin, MySql Version > 5.6 . Is there ...
0
votes
1answer
33 views

Installing the mysql-php module o

im trying to install mysql-php on ec2 amazon free tier but for some reason cant do it, I have installed everything else besides and that is the last thing stoping me from getting the server up and ...
1
vote
1answer
219 views

Yum installing wrong MySQL version on CentOS 5 (Amazon)

I'm having trouble with a CentOS server running on AWS. This is CentOS 5.6 i386 from RightImage, but the problem was the same on all RightScale AMIs. When issuing the following command: yum install ...
2
votes
2answers
399 views

How do I handle mysql replication in EC2 using private IPs?

I am trying to set up a mysql master/slave configuration in two EC2 instances. However, every time I reboot an instance, the IP address (and hostname) changes. I could assign an Elastic IP address, ...
0
votes
1answer
493 views

Ways to go about optimizing website performance WordPress, Amazon EC2 Apache and RDS MySQL

I have 6 WordPress websites running on 1 single EC2 instance. All the the websites are connecting to databases in 1 same RDS instance. Earlier today, traffic to the largest website peaked and the ...
-1
votes
2answers
203 views

MySQL stopped running on ec2 had to restart. How to avoid this?

I just noticed mysqld stopped running an an ec2 instance (ubuntu). I simply started it again. How can I avoid this from happening again. Will mysqld restart if Amazon restarts the instance for any ...
0
votes
1answer
53 views

Database modularity with EBS volumes

I would like to add modularity to my websites on EC2 instances by encapsulating the site files and the mysql files in their own EBS volumes. The end result that I'm going for is the ability to quickly ...
0
votes
1answer
53 views

Security Policy changes on EC2 instance

I'm trying to open up the MySQL (3306) port on my EC2 instance and even though I've added the rule, it appears the port is still closed. Do I need to reboot my instance for the policy changes to take ...
3
votes
1answer
720 views

How do I debug lock timeouts with MySQL / Amazon RDS?

We've got a web app hosted on Amazon Web services. Our database is a multi-az RDS MySQL server running 5.1.57 and 3-4 app servers talk to it. Today, we started seeing a lot of errors along the lines ...
0
votes
3answers
270 views

MySQL Not Turning On

I have an amazon ec2 instance running on the Amazon Linux AMI and its a micro instance. I wanted to install Django onto my server so I entered these commands wget ...
1
vote
1answer
133 views

High mysql server load, sar output

I have a MySQL Server that should be performing better than it seems to be. We're running ubuntu on a Amazon Cluster Compute (cc1.4xlarge) Linux ip-10-0-1-60 3.2.0-25-virtual #40-Ubuntu SMP Wed May ...
1
vote
2answers
91 views

Amazon EC2: Instances, IPs and a wordpress blog (LAMP)

How do instances spawned from AMIs work when you have a MySQL database? I think I understand that if you have more than one instance and assign the same Elastic IP to both of them, the incoming ...
1
vote
1answer
547 views

PHP occasionally fails to connect to mysql server

I have a php script on my server which is called by my client app to log some information into a remote mysql server. The scripts works fine, but occasionally (only occasionally) the script fails to ...
2
votes
1answer
275 views

MySQL: 5000 core users, 2GB Table Heavy Write / Read: How to Prevent Crashing

This is a controversial issue for sure, since many might want to recommend the simple things right away, like: Split up the tables! Split up the read/write into master/slave configurations! Amp up the ...
2
votes
1answer
700 views

Django syncdb can't connect to MySQL on seperate EC2 Instance

I am trying to deploy a django app on AWS with a setup where I have one EC2 instance that is running nginx/uwsgi and a second EC2 instance where I have MySQL 5.5 installed. Both belong to the default ...
1
vote
2answers
875 views

Am I uninstalling, installing Mysql the right way?

I changed my.cnv and nobody can connect to mysql again. So I decided to reinstall mysql. I did sudo aptitude purge mysql-server followed by sudo aptitude install mysql-server then I got this ...
2
votes
1answer
234 views

My sql consuming as much as 60% cpu time on start

I'm running a Wordpress installation on an Amazon Ec2 micro instance(linux ami). Using the default configuration Apache kept using up all the memory and shutting down mysql rendering wordpress ...
1
vote
4answers
337 views

Remote Mysql in EC2 instance

I have a MySql server instance in Amazon EC2. In my.cnf If I write bind-address = 127.0.0.1 , server can starts. But If I write bind-address = SERVER_IP, it gives Bind error. So to connect this ...