Resolving local networks with Xip.io

I recently stumbled upon a brilliant service. Developing locally always involves editing the /etc/hosts file to resolve a domain to your local host and then having to setup DNS servers to be able to check on my mobile or tablet.
Xip.io seems to have solved this issue by creating a custom DNS service that allows you to resolve a custom domain to an internal ip address so when any other device does a lookup it resolves correctly.

For example; your machine is on 10.0.0.10 and you need to check it on your mobile. You don’t want to upload it to your sever, setup a host, setup the database and all that. If you set the host on your local machine as

www.10.0.0.10.xip.io

when your mobile tries to do a DNS lookup the remote DNS server extracts the 10.0.0.10 from the Domain name and returns that back as the IP.

You can use any precursor to the ip address;

host1.10.0.0.10.xip.io
host2.10.0.0.10.xip.io
shop.10.0.0.10.xip.io

Brilliant idea!

PHP 5.6 CentOS 6

One of the bad things with the default repos on CentOS is that the PHP releases are really dated.
I recently needed a later version of PHP on one of my servers so did some digging to find the following webtatic repo for all the latest PHP and module releases.

rpm -Uvh https://mirror.webtatic.com/yum/el6/latest.rpm

That will install the yum repository for you so you can do the magical yum installs
The usual and basic modules for PHP 5.6 are as follows;

yum install php56w php56w-mysql php56w-xml
Continue reading

Percona Repo for CentOS 6

I have been wanting to use the Percona MySQL drop-in replacement for a while now. When trying CentOS 7, Percona is already into repos as the replacement for Mysql Server.

Below is the command to add the Percona repos into your yum repos lists.

yum install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

Then to install Percona 5.7 for example

yum install Percona-Server-server-57 Percona-Server-client-57

As we know, its a drop-in replacement for MySQL so the rest works as before; Don’t forget to optimize and use the mysql_secure_installation to remove the test database and setup root passwords.

NOTE: 57 setups a temporary root password, to find this check the /var/log/mysqld.log file for the following line
2016-02-27T14:49:11.247553Z 1 [Note] A temporary password is generated for root@localhost: rS:+xxxxxx