Bind-address use?

--=-HQwMwXLtBsarq9T4GYJq
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

Hi All

I am unable to find an answer on what the bind-address in
mysql-5.1 actually does.

From the config file it says that it provides the same function
as the previous skip-networking function.

However, let's say I configure the bind-adress value to the IP
of the machine, will this cause any issues with applications connecting
to the database from various other machines?


My reason for looking into this is because currently we are
experiencing intermittend connection problems (error 2013) but I have
not been able to pinpoint the issue and was wondering if this is not
perhaps the issue.


Thank you in advance for all responses

Regards
Machiel

--=-HQwMwXLtBsarq9T4GYJq--

Re: Bind-address use?

--20cf30549f19b901200496cdb4b8
Content-Type: text/plain; charset=ISO-8859-1

Hi,
You may have multiple interfaces and each multiple ips (private or public).
With bind-address you force mysql to listen to a specific ip address instead
of any. In case you have both public and private ips, binding to the
private, for example, prevents from connections from the internet.
Just keep in mind a server may belong to multiple subnets and mysql normally
listens to connections coming from any of em.
Cheers
Claudio
On Dec 7, 2010 9:16 AM, "Machiel Richards" wrote:
> Hi All
>
> I am unable to find an answer on what the bind-address in
> mysql-5.1 actually does.
>
> From the config file it says that it provides the same function
> as the previous skip-networking function.
>
> However, let's say I configure the bind-adress value to the IP
> of the machine, will this cause any issues with applications connecting
> to the database from various other machines?
>
>
> My reason for looking into this is because currently we are
> experiencing intermittend connection problems (error 2013) but I have
> not been able to pinpoint the issue and was wondering if this is not
> perhaps the issue.
>
>
> Thank you in advance for all responses
>
> Regards
> Machiel

--20cf30549f19b901200496cdb4b8--

Re: Bind-address use?

--=-a2K1ApR7gAz+i2ccHebj
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

what will the effect be if we disable this option in the config file by
means of hashing out the option?

will it break the database or just listen on any device?

-----Original Message-----
From: Claudio Nanni
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: Bind-address use?
Date: Tue, 7 Dec 2010 09:22:31 +0100



Hi,
You may have multiple interfaces and each multiple ips (private or
public).
With bind-address you force mysql to listen to a specific ip address
instead of any. In case you have both public and private ips, binding to
the private, for example, prevents from connections from the internet.
Just keep in mind a server may belong to multiple subnets and mysql
normally listens to connections coming from any of em.
Cheers
Claudio

On Dec 7, 2010 9:16 AM, "Machiel Richards" wrote:
> Hi All
>
> I am unable to find an answer on what the bind-address in
> mysql-5.1 actually does.
>
> From the config file it says that it provides the same function
> as the previous skip-networking function.
>
> However, let's say I configure the bind-adress value to the IP
> of the machine, will this cause any issues with applications
connecting
> to the database from various other machines?
>
>
> My reason for looking into this is because currently we are
> experiencing intermittend connection problems (error 2013) but I have
> not been able to pinpoint the issue and was wondering if this is not
> perhaps the issue.
>
>
> Thank you in advance for all responses
>
> Regards
> Machiel


--=-a2K1ApR7gAz+i2ccHebj--

Re: Bind-address use?

--20cf303f64be25c1340496ce420c
Content-Type: text/plain; charset=ISO-8859-1

if you dont specify it it will listen to all interfaces,
and it is the standard option.

you dont break anything.

Claudio



2010/12/7 Machiel Richards

> what will the effect be if we disable this option in the config file by
> means of hashing out the option?
>
> will it break the database or just listen on any device?
>
>
> -----Original Message-----
> *From*: Claudio Nanni
> >
> *To*: Machiel Richards
> >
> *Cc*: mysql mailing list
> >
> *Subject*: Re: Bind-address use?
> *Date*: Tue, 7 Dec 2010 09:22:31 +0100
>
>
>
> Hi,
> You may have multiple interfaces and each multiple ips (private or public).
> With bind-address you force mysql to listen to a specific ip address
> instead of any. In case you have both public and private ips, binding to the
> private, for example, prevents from connections from the internet.
> Just keep in mind a server may belong to multiple subnets and mysql
> normally listens to connections coming from any of em.
> Cheers
> Claudio
>
> On Dec 7, 2010 9:16 AM, "Machiel Richards" wrote:
> > Hi All
> >
> > I am unable to find an answer on what the bind-address in
> > mysql-5.1 actually does.
> >
> > From the config file it says that it provides the same function
> > as the previous skip-networking function.
> >
> > However, let's say I configure the bind-adress value to the IP
> > of the machine, will this cause any issues with applications connecting
> > to the database from various other machines?
> >
> >
> > My reason for looking into this is because currently we are
> > experiencing intermittend connection problems (error 2013) but I have
> > not been able to pinpoint the issue and was wondering if this is not
> > perhaps the issue.
> >
> >
> > Thank you in advance for all responses
> >
> > Regards
> > Machiel
>
>


--
Claudio

--20cf303f64be25c1340496ce420c--

RE: Bind-address use?

" intermittent connection problems (error 2013)"

Look at SHOW PROCESSLIST; when you're having a connection problem. If you=
see lots of "unathenticated user" in the list, then it means you're having=
DNS problems.

Typically the best way to handle this is to set skip-name-resolve, and usin=
g ip addresses instead of hostnames in your mysql users for authentication.


-----Original Message-----
From: Claudio Nanni [mailto:claudio.nanni@gmail.com]
Sent: Tuesday, December 07, 2010 1:02 AM
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: Bind-address use?

if you dont specify it it will listen to all interfaces,
and it is the standard option.

you dont break anything.

Claudio



2010/12/7 Machiel Richards

> what will the effect be if we disable this option in the config file by
> means of hashing out the option?
>
> will it break the database or just listen on any device?
>
>
> -----Original Message-----
> *From*: Claudio Nanni io.nanni@gmail.com%3e>
> >
> *To*: Machiel Richards lr@rdc.co.za%3e>
> >
> *Cc*: mysql mailing list %3cmysql@lists.mysql.com%3e>
> >
> *Subject*: Re: Bind-address use?
> *Date*: Tue, 7 Dec 2010 09:22:31 +0100
>
>
>
> Hi,
> You may have multiple interfaces and each multiple ips (private or public=
).
> With bind-address you force mysql to listen to a specific ip address
> instead of any. In case you have both public and private ips, binding to =
the
> private, for example, prevents from connections from the internet.
> Just keep in mind a server may belong to multiple subnets and mysql
> normally listens to connections coming from any of em.
> Cheers
> Claudio
>
> On Dec 7, 2010 9:16 AM, "Machiel Richards" wrote:
> > Hi All
> >
> > I am unable to find an answer on what the bind-address in
> > mysql-5.1 actually does.
> >
> > From the config file it says that it provides the same function
> > as the previous skip-networking function.
> >
> > However, let's say I configure the bind-adress value to the IP
> > of the machine, will this cause any issues with applications connecting
> > to the database from various other machines?
> >
> >
> > My reason for looking into this is because currently we are
> > experiencing intermittend connection problems (error 2013) but I have
> > not been able to pinpoint the issue and was wondering if this is not
> > perhaps the issue.
> >
> >
> > Thank you in advance for all responses
> >
> > Regards
> > Machiel
>
>


--
Claudio

This message contains confidential information and is intended only for the=
individual named. If you are not the named addressee, you are notified th=
at reviewing, disseminating, disclosing, copying or distributing this e-mai=
l is strictly prohibited. Please notify the sender immediately by e-mail i=
f you have received this e-mail by mistake and delete this e-mail from your=
system. E-mail transmission cannot be guaranteed to be secure or error-fre=
e as information could be intercepted, corrupted, lost, destroyed, arrive l=
ate or incomplete, or contain viruses. The sender therefore does not accept=
liability for any loss or damage caused by viruses or errors or omissions =
in the contents of this message, which arise as a result of e-mail transmis=
sion. [FriendFinder Networks, Inc., 220 Humboldt Court, Sunnyvale, CA 94089=
, USA, FriendFinder.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Bind-address use?

> " intermittent connection problems (error 2013)"
>=20
> Look at SHOW PROCESSLIST; when you're having a connection problem. =
If you see lots of "unathenticated user" in the list, then it means =
you're having DNS problems.
>=20
> Typically the best way to handle this is to set skip-name-resolve, and =
using ip addresses instead of hostnames in your mysql users for =
authentication.

Or fix your DNS, if it's under your control.

If you have a named(8) running on your LAN, you should not have DNS =
timeouts. It doesn't have to be authoritative -- set up a caching server =
on the same machine that runs mysql and talk to it via localhost.

Take it from someone who just had to change all my static IPs -- keep =
IPs out of your database connection code! ("Oh, THAT won't happen to =
me!" And then, it does...)-:

----------------
Some of the current attempts at energy accounting, like the triple =
bottom line, are an absolute a joke. They're an insult to children even =
in terms of their intellectual content, because they try and compare =
vague abstractions of social and environmental values =97 just dot =
pointed =97 against a completely econometric financial accounting system =
of an organization which is actually doing the work. -- David Holmgren
:::: Jan Steinman, EcoReality Co-op ::::


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg