Solution to CPAN hangs on Fetching with LWP:

When I tried to fetch stuff with CPAN it started hanging right away

Fetching with LWP:
  ftp://ftp.planetmirror.com/pub/perl/CPAN/modules/02packages.details.txt.gz

This is likely happening because you are behind a NAT or firewall, and you need to do ftp in passive mode.
Find your perls libnet.cfg file:

% locate libnet.cfg
/etc/perl/Net/libnet.cfg

Edit that file and change the ftp_int_passive setting to 1.

How to repair mysql master-master replication errors

Say you have a server in the replication setup down for a couple of days, and when you turn it back on and check if sync is working proper:

mysql -uroot -p
show slave status\G

In case it's all good:

Slave_IO_Running: Yes
Slave_SQL_Running: Yes

Possible error 1:

Slave_IO_Running: Yes
Slave_SQL_Running: No

Can be fixed by this url