[nylug-talk] Is there a general best practice location to install mysql?

[Kenneth Dombrowski]

On 07-10-05 07:49 -0700, Peter C. Norton wrote:
> On Fri, Oct 05, 2007 at 09:11:03AM -0400, Brandorr wrote:
> > 
> > If that is the case how do people support concurrent installs of mysql 4 and 5?
> 
> I think that "support" of two databases is not always easily
> automatable. Doing this usually requires more than just reloacting
> binaries, since each version, at least, will require at least some
> configuration on the part of the user for the location and naming of
> sockets, and re-numbering of tcp ports. If you do this automatically,
> you're going to have to do a bit of poking and prodding at the client
> side, too. 
> 

I've used mysqld_multi to manage concurrent installs of mysql 4 and 5

http://dev.mysql.com/doc/refman/5.0/en/mysqld-multi.html

It can also be used to run multiple instances of a single version; at a minimum,
these are the options you have to define for each instance: 

[mysqld2]
datadir                 = /var/lib/mysql-sa
# spamassassin logs a lot of binary crap that messes up my terminal
# log                   = /var/log/mysql/mysql-sa.log
log-slow-queries        = /var/log/mysql/mysql-sa-slow.log
pid-file                = /var/run/mysqld/mysqld-sa.pid
port                    = 3307
socket                  = /var/run/mysqld/mysqld-sa.sock


I've heard mysqld_multi is now deprecated in favor of mysqlmanager 

http://dev.mysql.com/doc/refman/5.0/en/instance-manager.html

Kenneth