Tagged Questions

0
votes
1answer
33 views

Mysql working remotely but not localy

I have a cloud based application in PHP with one master server and multiple slaves. All servers are using master's database (mysql). I already done this steps CREATE USER 'mysql'@'%' IDENTIFIED BY ...
0
votes
0answers
49 views

2013 - Lost connection to MySQL server at 'reading initial communication package', system error: 0

I know you can find tons upon tons of threads and information about this issue, but non of the threads I've found provided a useful answer. (In my case) I've tried to fix this issue for about 12 hours ...
0
votes
0answers
34 views

Ubuntu 12.04 Openstack MySQL Connecction Not Responding

I'm installing Openstack Grizzly using the guide found here: Openstack-Grizzly-Install-Guide I would like to run Openstack on a single machine with 3 physical network interfaces. I've named them ...
1
vote
1answer
49 views

Percona on 2nd node will not start

I have setup two Vagrant VMs to simulate Percona XtraDB Cluster for our development needs. The first VM comes online just fine, and everything works. However, when I try to start Percona on the 2nd VM ...
1
vote
1answer
87 views

Simulate slow network connection to MySQl server

I tried fiddler and wireshark to simulate slow network connections. I could slow down the network with fiddler but it is for Http and https protocols. With wireshark I was able to capture TCP & ...
1
vote
1answer
69 views

When to use a MySQL socket and when to use a host:port?

Many applications allow me to connect to Mysql using a username, password host and port. Some allow me to configure a socket instead of the host:port. Is there any clear benefit of one over the ...
-1
votes
1answer
155 views

Mysql on Ubuntu 12.04 with static IP is very slow

My setup Ubuntu 12.04 static ip address mysql 5.5.28 This is a box used in my local network only for developping. So I installed Ubuntu and did not change much but setting the static IP. Mysql is ...
0
votes
2answers
153 views

Can't Connect To Local Mysql Using IP Address, but CAN connect from remote server

Here's an interesting one that does not seem to fall into any of the mysql connection issues I've read about or searched for: On an Ubuntu 12.04 box I had some system updates waiting to install, and ...
0
votes
1answer
84 views

After creating a mysql user with all privileges, the user cannot create databases in phpMyAdmin and only sees information_schema table

This is a recurring problem for some reason... Using mysql 5.5, I am simply trying to create a user that can connect to the database remotely, have access to all databases, and create databases. I ...
0
votes
1answer
255 views

Random “Lost connection to MySQL server at 'reading initial communication packet', system error: 0”

Sometimes I get the error from MYSQL server: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 I cannot find the cause, since most of the time it works, ...
0
votes
1answer
160 views

Can't connect to mysql remotely

I am running an ubuntu server, which has a LAMP stack. The problem is I can't access MySQL remotely. I have uncommented the bind-address, in the my.cnf file, but this has no effect. netstat -tap | ...
0
votes
3answers
5k views

How to start mysql server in ubuntu 12.04

I have problems after updating ubuntu from 11.10 to 12.04 with mysql - before upgrade everything worked fine after upgrade - mysql cannot start mysql server properly. Any ideas? This is my error ...
2
votes
3answers
476 views

How to speed up Drupal 7 with remote DB (not DNS resolving)

we have Drupal 7 on Ubuntu LTS virtual machine (VMWare) with MySQL 5.1 server on the same physical server, but on a different virtual machine. The Drupal website is currently under development, ...
0
votes
1answer
22 views

Creating Local AMP Application on Network Share

I've recently begun to develope web applications with Apache web server, MySQL database server and PHP. My work is looking for a cheap efficient way to update an older split Access database which ...
1
vote
1answer
141 views

MySQL connection issue with error 2003 / 111

I'm running a mysql server using the following command: mysqld --no-defaults --user=root --port=3310 --bind-address=0.0.0.0 --skip-grant-tables & My understanding is that this command starts ...
0
votes
1answer
61 views

Tunneling mysql through a second server not visible to the outside

This is the setup: I have 1 debian server deep within the network running a mysql server. I have a second debian server who is exclusively allowed to access the mysql server of the first server. I ...
1
vote
0answers
615 views

Cannot connect to MySQL on RDS (Amazon Web Services) from my laptop

I'm having some trouble connecting to a MySQL 5.1 server on an RDS instance on AWS from my laptop. The detailed description of the problem is here: ...
6
votes
1answer
5k views

MySQL [Warning] IP address could not be resolved

I'm running MySQL5.6.3 on a CentOS 6.1 virtual machine running on Windows XP in VirtualBox. The network card is configured in bridge mode, so my physical & virtual machines share the same ...
0
votes
1answer
174 views

Access mysql database from an Amazon Windows EC2 instance to another EC2 windows instance

I have 2 Amazon EC2 instances running WAMP stack. They are both in the same amazon account but different regions. Normally if I had this setup on Godaddy I would have used SOAP service to access data ...
4
votes
5answers
202 views

What are the 'gotcha's' a software developer needs to look out for if tasked with setting up a production ready server?

As a software developer I am very used to installing my typical stack (java, mysql and tomcat/apache) on my development machine. But setting up and securing a production machine is not something I ...
1
vote
1answer
252 views

Does Amazon AWS block multiple connection from the same IP?

I use Amazon AWS, however, I am noticing a problem. I have a machine I host outside of AWS which needs to make multiple connections to a database located within AWS. It needs to make several queries ...
11
votes
8answers
2k views

If I send data to my computer using its public hostname, does it actually go over the internet?

To clarify: I'm using my public hostname to connect to a MySQL database. The hostname resolves to my server's external IP (e.g. 1.2.3.4). Is the data I'm sending/receiving via the MySQL connection ...
0
votes
2answers
264 views

Apache Delay in Requesting Web Pages During High Traffic

I have a server running CentOS 5, MySQL 5.1, and PHP 5.2. I have a problem that I'm not sure where to start in troubleshooting. It seems that during periods of high traffic, Apache will occasionally ...
0
votes
2answers
93 views

Mysql proxying and port mapping

Hi I have something silly like idea to proxying mysql connections. I have upload an image of my concept to here http://i52.tinypic.com/o7src3.png There is a single machine on local network running ...
1
vote
3answers
2k views

Intermittent “Lost connection to MySQL server at 'reading initial communication packet'”

Our web environment consists of two servers. Web front-end. Dell PowerEdge R610, RHEL 5.5, Apache 2.2.17, php 5.2.14. Database server. Dell PowerEdge R710, Windows 2008 R2 Standard x64, MySQL ...
4
votes
3answers
2k views

Why can't I connect to Amazon RDS after setting it up?

So, I just created the Amazon RDS account. And I started an instance of database. The "endpoint" is: abcw3n-prod.cbmbuiv8aakk.us-east-1.rds.amazonaws.com Great! Now I try to connect to it from one ...
1
vote
4answers
213 views

apache server A attempts conn to mysql server B. times out. what am i missing?

I have an apache web server (Red Hat Enterprise Linux Server release 5.5 (Tikanga)) running PHP 5.3.2. I am trying to make a connection with php to a new Ubuntu 10.04 64 bit server running mysql ...
0
votes
1answer
379 views

Intermintent slow MySQL Connections

We keep getting errors like this on our PHP sites. Can't connect to MySQL server on '192.168.100.85' (4) web is the web server 192.168.1.116 mysql is the mysql server 192.168.100.85 So I built ...
1
vote
5answers
831 views

DMZ configuration and firewall throughput

I've been asked to look into placing a firewall between a webserver (Debian/Apache/PHP) in the DMZ and a backend MySQL database to achieve "isolation". Right now, iptables is running on the MySQL ...
1
vote
1answer
34 views

How to discover which name/address connections from one network to another uses?

In MySQL you have to authorized a user based on the name of the origin network. From my network to a remote one all connections appear as sent from mail.mycompany.com. But connections to another ...
1
vote
1answer
275 views

4 - 7 second delay accessing Mysql across the network

our company has recently purchased a new server with the intention of replacing our aging database server. its a full 64bit 2008 enterprise system, i have got the basic server setup and configured ...
0
votes
1answer
255 views

Is it possible to use the MMM tool without virtual IP capability?

We are on a host (Serverbeach) that does not support Virtual/floating IPs until you reserve at least a half-rack, which is just a little more than we are willing to spend per month right now. We do ...
0
votes
1answer
475 views

other computer in the network cannot connect to mysql database

I have a vb.net program that uses mysql as its database. And it works when the computer has wampservr installed. But the program gets an unhandled exception error when the computer where its running ...
3
votes
3answers
855 views

Long connection times from PHP to MySQL on EC2

I'm having an intermittent issue connecting to a database slave with InnoDB. Intermittently I get connections taking longer than 2 seconds. These servers are hosted on Amazon's EC2. The app server is ...
3
votes
3answers
1k views

Open mysql only to localhost and a particular address

My config: ubuntu server 9 and msyql 5 my.cnf = bind-address = 0.0.0.0 my iptables script = iptables -A INPUT -i eth0 -s 99.88.77.66 -p tcp --destination-port 3306 -j ACCEPT I can connect from ...
1
vote
5answers
3k views

MySQL performance over a (local) network much slower than I would expect

MySQL queries in my production environment are taking much longer than I would expect them too. The site in question is a fairly large Drupal site, with many modules installed. The webserver (Nginx) ...
0
votes
4answers
156 views

help with a social network's server

I am about to launch a social network that will contain media, blogs, messaging, profiles... etc. The mySQL server will be particularly burden by ajax calls to the db, media bandwidth, and ffmpeg ...
3
votes
2answers
192 views

MySQL connection security

I have 2 Windows 2003 servers. One is running IIS with Microsoft's FastCGI extension and PHP. The other server is running MySQL 5.1. I want to setup some PHP applications on the IIS Server and have ...