-2
votes
0answers
35 views

Mysql resolving 127.0.0.1 to hostname [migrated]

I'm trying to connect to mysql using the command mysql -h 127.0.0.1 It comes up with the error ERROR 1045 (28000): Access denied for user 'root'@'mydomain.com' (using password: NO) Why is ...
0
votes
1answer
96 views

OpenVZ: Custom settings on container startup / Choosing the right MySQL Server

What I have: Two servers running Wheezy/OpenVZ with One MySQL container on each host master/master replicated (mysql1/mysql2) Replicated DNS on each host (dns1/dns2) different web-containers on ...
0
votes
2answers
43 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 ...
1
vote
2answers
178 views

website on ubuntu suddenly running slow

The website that I administrate suddenly started running slowly today. I'm trying to figure out where the bottleneck is. I created a 14kb text file and this takes 5 seconds to open in the browser! I'm ...
0
votes
3answers
340 views

MySQL - Hostname Issue

I'm experiencing an unusual issue with my production mysql server. Currently I only have two production servers so I had all the server host name entries in /etc/hosts files on each server. A few days ...
0
votes
1answer
104 views

Restrict MySQL Access of Users to a Specific Domain

I'd like to create a new user in mysql which will be able to connect only from my servers. I've seen a way to do it through IP ranges or domain names (e.g. CREATE USER 'repl'@'%.mydomain.com' ...
1
vote
1answer
577 views

bind9 dlz/mysql at ubuntu segfault libmysqlclient.so

I have a big problem. I installed the bind9 nameserver to three different computer. two Ubuntu 10.04.4 LTS, and one Ubuntu 11.10 I compiled it 9.7.0, 9.7.3, 9.9.0 with this method: ./configure ...
7
votes
1answer
13k 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
428 views

Wrong DNS name for client when client connects to MySQL - how to use another client host name?

I'm trying use a host restricted MySQL user when connecting from one Amazon EC2 instance to another. I wanted to use elastic ip address for their dns function, but you can probably ignore the Amazon ...
4
votes
2answers
3k views

Dns server which is better bind or mydns?

I am going to start a new website which is going to require DNS servers. It might have over 10,000 zones and will get more zone files as we get bigger. The problem is, which dns server software do you ...
7
votes
4answers
824 views

BIND HTTP “API”

First off, I'm a bit of a bind n00b so if I say things that don't make sense just ignore them =) Is there any software that would allow "API" like commands for creating, updating, deleting etc. zones ...
0
votes
2answers
622 views

can't connect to MySQL from localhost on Centos 5

I have a fresh install of Centos 5.5 on a new VPS and MySQL seems unable to resolve the keyword 'localhost' - if I use 127.0.0.1 instead it works fine. I checked the /etc/hosts file which is as ...
1
vote
2answers
338 views

remote Mysql connections taking 5 seconds to establish

Setup is as follows, Ubuntu 8.04 server in DMZ running Mysql 5 Remote connections from php on windows machines outside the DMZ are taking 5 seconds to establish (at which point the speed of mysql is ...
1
vote
3answers
557 views

What other ways can I load balance EC2 servers without using Elastic Load Balancing?

I have a web application that consists of a web server managed by a web hosting firm, a set of EC2 instances in amazons cloud and a MySQL database (hosted on the webserver). MySQL is behind a firewall ...
0
votes
2answers
539 views

Help - since adding an elastic load balancer to my EC2 web application I cannot connect with the MySQL database (not in AWS)

I have a web application that uses an EC2 instance to receive uploaded images, resize and store on S3 and update my MySQL database with the image record. This database is hosted outside Amazon Web ...
0
votes
2answers
96 views

Proper way to migrate site DNS

Two part question: What is the industry best practices for handling a major DNS change? I have an app that uses Mysql the app was replicated on both servers including the database. During DNS ...
2
votes
1answer
523 views

Grant access rights to a MySQL instance based on hostname instead of IP address?

I have a MySQL database that I would like to remotely access from Windows Azure which does not provide fixed IP addresses at this point. Instead of white-listing a very large IP range to cover the ...
0
votes
2answers
78 views

Migrated to new server, DNS setup >48 hrs, some MySQL inserts from domain still show up on old server

Title says it all - I've migrated to a new dedicated server at a different IP.. It's been more than 48 hours since DNS was setup. Some MySQL inserts (standard php variables invoke mysql) from at ...
2
votes
3answers
632 views

load balancing two web servers each on two different isp's?

I have two ISP's that provide me hosting via apache / php / mysql. I am running drupal on them. On occasion the mysql server will go away (crash), so I was hoping to find a reasonable way to have ...
7
votes
1answer
4k views

Remote connection to MySQL server takes very long

I have a MySQL 5.0.75 server running on my Linux notebook to which I want to connect from another machine in the local network. This connection takes 5-6 seconds: mysql -h 172.22.65.101 -u myuser ...