Re: Multiple instances of MySQL

2009-04-12 Thread Mel Flynn
On Thursday 09 April 2009 21:43:36 Brent Bloxam wrote: Mel Flynn wrote: Any reason a jail can't be used? This would allow sharing the binary using null or union fs, little overhead, yet seperated from host install and no maintenance of port installed files, like rc.d/mysql-server.

Re: Multiple instances of MySQL

2009-04-09 Thread Brent Bloxam
Mel Flynn wrote: Any reason a jail can't be used? This would allow sharing the binary using null or union fs, little overhead, yet seperated from host install and no maintenance of port installed files, like rc.d/mysql-server. Unionfs, unix sockets and flush operations don't like each other

Re: Multiple instances of MySQL

2009-04-08 Thread Mel Flynn
On Tuesday 07 April 2009 14:55:26 DAve wrote: However, I would suggest that you provide, as you suggest, a separate instance of mysql just for this client as well. If they screw up the instance they won't affect other customers. To run a separate instance, I would suggest using

Re: Multiple instances of MySQL

2009-04-07 Thread DAve
Norbert Papke wrote: On April 6, 2009, DAve wrote: Has anyone setup two instances of MySQL on the same server? One running just a client's DBs? Any advice would be helpful. It's just a matter of making sure that the two instances don't share any ports or files. It works well. You'll have

Re: Multiple instances of MySQL

2009-04-07 Thread DAve
Paul Schmehl wrote: --On April 6, 2009 11:41:06 PM -0400 DAve dave.l...@pixelhammer.com wrote: Olivier Nicole wrote: Hi, Has anyone setup two instances of MySQL on the same server? One running just a client's DBs? Any advice would be helpful. That is not answering your question

Multiple instances of MySQL

2009-04-06 Thread DAve
Good morning all, I have a situation where I am being instructed to allow a client to access MySQL remotely. We generally put those clients on a VPS and allow them free reign. In this case we cannot, they are on a shared host server. Opening our PIX to allow connections through to MySQL, and

Re: Multiple instances of MySQL

2009-04-06 Thread Olivier Nicole
Hi, Has anyone setup two instances of MySQL on the same server? One running just a client's DBs? Any advice would be helpful. That is not answering your question directly, but MySQL works finr over an SSH tunnel. You'd have your users connect/authenticate with SSH first to establish the

Re: Multiple instances of MySQL

2009-04-06 Thread Norbert Papke
On April 6, 2009, DAve wrote: Has anyone setup two instances of MySQL on the same server? One running just a client's DBs? Any advice would be helpful. It's just a matter of making sure that the two instances don't share any ports or files. It works well. You'll have to create a custom

Re: Multiple instances of MySQL

2009-04-06 Thread DAve
Olivier Nicole wrote: Hi, Has anyone setup two instances of MySQL on the same server? One running just a client's DBs? Any advice would be helpful. That is not answering your question directly, but MySQL works finr over an SSH tunnel. You'd have your users connect/authenticate with SSH

Re: Multiple instances of MySQL

2009-04-06 Thread Paul Schmehl
--On April 6, 2009 11:41:06 PM -0400 DAve dave.l...@pixelhammer.com wrote: Olivier Nicole wrote: Hi, Has anyone setup two instances of MySQL on the same server? One running just a client's DBs? Any advice would be helpful. That is not answering your question directly, but MySQL works