MySQL with skip-networking, binding a socket to TCP

In: Linux|MySQL

10 Jul 2010

Recently I started migrating an old server, which had skip-networking within my.cnf, which is not a dynamic option and requires you to restart the mysql server.

I typically rsync the source code and static data to a new machine. Configure the webserver with the relevant vhosts and change the database connection details to point to the old server. After the site has been tested on the new server and dns has fully resolved move the database server across.

However, with skip-networking enabled you would have to restart MySQL and is not feasible during working hours. After a little searching I came across socat, which allows you to bind a socket to tcp.

socat -v tcp-l:6666,reuseaddr,fork unix:/var/run/mysqld/mysqld.sock

socat is very flexible and the man pages for socat are pretty extensive .

1 Response to MySQL with skip-networking, binding a socket to TCP

Avatar

PHP5 & ADSI (Active Directory Service Interfaces) | Development, Analysis And Research

November 28th, 2010 at 2:42 am

[…] providers,..winmgmts://cim://LDAP://WinNT://NDS://NWCOMPAT://More ProvidersSome simple examples… Read the rest of this entry » /**/ You can follow any responses to this entry through the RSS 2.0 feed. You can leave a […]

Comment Form

About this blog

I have been a developer for roughly 10 years and have worked with an extensive range of technologies. Whilst working for relatively small companies, I have worked with all aspects of the development life cycle, which has given me a broad and in-depth experience.