Re: WIKI - Shared webhosting - problem with mysql socket [message #23281 is a reply to message #23269] |
Thu, 15 November 2007 08:32   |
tauren
Messages: 7 Registered: November 2007
|
Junior Member |
|
|
curx wrote on Thu, 15 November 2007 01:56 | Hi,
you must relink the mysql.sock on every restart the VE, because it's a hard not a soft link.
You can experience with the vz mount/unmount scripts to set a hard link from VE to another one.
|
Thanks, that helps for VE startup/shutdown. But the hard link is lost even if mysql is restarted within the mysql VE. A "service mysqld restart" removes the mysql.sock and creates a new one, thus losing the hard link.
As ToyKeeper suggested on freenode #openvz, a cron job could run every minute to see if the mysql.sock file has changed. If it has, then all hard links could be recreated. But that is more of a hack that a real solution. It may have to do though, as I haven't come up with a real solution yet. If there are any ideas, I'm all ears.
BTW, I updated the WIKI to mention this behavior.
Tauren
|
|
|