Re: WIKI - Shared webhosting - problem with mysql socket [message #23367 is a reply to message #23305] |
Fri, 16 November 2007 01:58 |
tauren
Messages: 7 Registered: November 2007
|
Junior Member |
|
|
Thanks curx,
Those are some great ideas. I have created a script to relink the sockets. It can be run manually or via a cron job. I've added it to the wiki if anyone is interested:
http://wiki.openvz.org/Shared_webhosting
Thanks again,
Tauren
curx wrote on Thu, 15 November 2007 07:10 | Hi,
1) ssh connection VE -> VE0
A wrapper, when restarting a mysql-server in VE, a predefined ssh connetion to VE0, maybe different port , which invoke the ln sequence.
* setup a nonpasswd ssh connection with authorizeds_keys
* maybe start a non-sshd-port sshd (port 22!) daemon on VE0, with sshd_option
"PermitRootLogin forced-commands-only"
and a ssh connection like:
VE# ssh -p <PORT> root@<VE0_IP_or_NAME> 'ln /var/lib/vz/root/<VEID_mysqld>/var/run/mysql/mysql.sock /var/lib/vz/root/<VEID_NON_mysqld>/var/run/mysql/mysql.sock'
2) setup a shared folder with mount -o bind ...
3) setup mysqld with connection settings and limit the IP, which can connect to mysqld with iptables or tcpd-wrapper
|
|
|
|