Questions[ip](server)

I have never had the privilege of working in an environment that required complicated routing or if it did require it, it was handled upstream of me. I've always used very simple static routing configurations and never needed to do any multipath routing -- hence my general confusion regarding this subject. I would like to understand multicasting and anycasting better.

• What is the difference between unicast, anycast, broadcast and multicast traffic?
• What situations are they generally used in and why (e.g., what applications use which method)?
• How do you calculate how much broadcast traffic is too much for a given network segment or broadcast domain?
• What are the security implications of allowing broadcast and multicast traffic?

Is there a secret way to bind MySQL to more than one IP address?

As far as I can see the bind-address parameter in the my.cnf does not support more than one IP and you can't have it more than once.

It's from this answer:

https://stackoverflow.com/questions/2482411/is-this-pdo-bug-fixed-now/2482424#2482424

When the host is "localhost", MySQL Unix clients use a Unix socket, AKA Unix Domain Socket, rather than a TCP/IP socket for the connection, thus the TCP port doesn't matter.

I know that 127.0.0.1 ~ 127.255.255.254 are the loopback IP addresses for most modern operating systems, and these IP addresses can be used to refer to our own computer.

But what's 0.0.0.0? It seems it also refers to the local computer, so what's the difference?

And, could you explain the following IP connections for me:

Is there a built-in command line tool that will do reverse DNS look-ups in Windows? I.e., something like <toolname> w.x.y.z => mycomputername

I've tried:

• nslookup: seems to be forward look-up only.
• host: doesn't exist
• dig: also doesn't exist.

I found "What's the reverse DNS command line utility?" via a search, but this is specifically looking for a *nix utility, not a Windows one.