multiple mysql server

[Sean Ellis]

On Sat, Jul 30, 2005 at 07:29:12AM +0000, Sunil Sunder Raj wrote:

Hi Sunil,

thanks for your reply.

My need for a second mysql server is to allow me to implement a database
that will use the utf-8 character set, whilst maintaining some existing
databases that are using the default Latin1 character set. 

I've ammended what you suggest below based on what I've read in the
documentation. Does this look sound? Anybody? I realize that this is
more of a mysql question.  

> 1)  install mysql

Build with --with-extra-charsets to include utf-8

> 2)  copy the mysql data directory to say mysql1
> So you have /var/db/mysql and /var/db/mysql1
> 
> 3) Open the first mysql /var/db/mysql/my.cnf
> Change
> port            = <The port you want the first mysql to listen to>
> bind-address    = <The ip you want the first mysql to bind to>
> 
> 4) start the first mysql server
> 
> 5) Open the second mysql /var/db/mysql1/my.cnf
> Change
> port            = <The port you want the second mysql to listen to>
> bind-address    = <The ip you want the second mysql to bind to>
> 
> 6) Write the startup command for the second mysql server
> /usr/local/bin/mysqld_safe --bind-address=<The ip address you want to bind 
> the second mysql server to> --user=mysql --socket=/tmp/mysql1.sock 
> --datadir=/var/db/mysql1 --pid-file=/var/run/mysql1.pid

--default-character-set=utf8 --default-collation=utf8_general_ci &

Easy enough for me to try out on a test machine. If anyone has any
comments though I would be interested,

cheers,

Sean