hi I am trying to connect mysql server running on amazon linux instance but did not succeeded yet .
Scenario : i installed mysql server in amazon's ec2 instance .
I have 2 servers, both running Ubuntu server 11.10.
The first server runs Apache and PHP and it connects to a Mysql database on the second server.
The problem is slow mysql response on the second server.mysql logs does not show any errros other than: 120526 12:56:27 [Note] Plugin 'FEDERATED' is disabled.
I am having problems connecting to remote mysql server. I am running two ec2 instances, one has mysql server configured and the other is from where I need to connect to.
Things I have done...
1. I have modified /etc/my.conf to comment out skip-networking and added bind-address to point to mysql server ip.
2. I made sure port 3306 is open for listening.
3.
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.example.com.err --open-files-limit=20000 --pid-file=/var/lib/mysql/server1.example.com.pid
Memory is at %10 always and Cpu at %1
Also
/usr/local/apache/bin/httpd -k start -DSSL
I have like 10 of them running
I'm running a php website. I have two servers.
Please help me to check is this Mysql Database Server load too high? I found the mysql CPU usage is always higher than 100%.
The problem is that my MySQL server keeps crashing every few seconds. Even if I repeat a simple SQL command several times, the MySQL server goes down:
mysql> show databases;
ERROR 2006 (HY000): MySQL server has gone away
No connection.
Hi all,
Fedora 17, 64bits
I ran following commands;
$ sudo yum install httpd
$ sudo yum install mysql
$ sudo yum install mysql-server
installing above packages.
I haven't configured them.
Then I ran again;
$ sudo yum remove httpd
$ sudo yum remove mysql
on running;
$ sudo yum remove mysql-server
Code:
Loaded plugins: langpacks, presto, refresh-packagekit
No Match for a
I'm desperate, and hoping some kind soul can rescue me! I'm dealing with restoring a completely crashed server. Everything is back up except for there's an issue with one domain which uses MySQL (no other domains on the server use MySQL).
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 mysql mysql-server mysql-devel
the only packages proposed by yum are MySQL-devel-community and MySQL-server-community.
Email this page
