List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 4 2000 11:21pm
Subject:RE: Two MySQL servers
View as plain text  
>Is there a way to do this so I don't have to specify the socket and port
>number every time I start MySQL?

Depends on how much work you want to do.

You can either compile a bunch of binaries, where each one knows its
own startup parameters, or you can specify the parameters for each
server when you start it.

I'm not sure why the latter is such a lot of work.  You put the
information to run the servers in some startup script, once, then you
just run the script.  You're done.


>
>Regards,
>Jason
>
>>  -----Original Message-----
>>  From: Dan Sjolseth [mailto:Dan.Sjolseth@stripped]
>>  Sent: Tuesday, April 04, 2000 10:58 AM
>>  To: mysql@stripped
>>  Subject: Re: Two MySQL servers
>>
>>
>>  At 10:20 AM 4/4/00 -0600, you wrote:
>>
>>  >I am attempting to run multiple MySQL servers on the same box and am
>>  >having problems.  I read the MySQL manual and I think I followed the
>>  >instructions exactly.  Here is what I ran for configure:
>>  >
>>  >./configure --prefix=/home/userdir/mysql2 --with-tcp-port=3316
>>  >--with-unix-socket=mysql2.sock
>>  >
>>  >I've also tried it with specifying /tmp/mysql2.sock as well.  When I try
>>  >to start the server it shuts down the other server and won't start.  Any
>>  >help would be appreciated.
>>  >
>>  >Thanks,
>>  >
>>  >Jason
>>
>>  Jason,
>>
>>  I start 7 servers here. He is a snipit from my rc.mysql Hope this helps.
>>
>>    echo ""
>>    echo -n "Starting Database Servers - Please wait"
>>
>>    MDAEMONLOG=1.Callisto.Clickrebates.Com.log
>>    MDAEMONPID=1.Callisto.Clickrebates.Com.pid
>>    MDAEMONERR=1.Callisto.Clickrebates.Com.err
>>    MSOCKNAMES=/tmp/mysqld.1.sock
>>    MDAEMONPRT=4001
>>
>>    export MDAEMONLOG MDAEMONPID MDAEMONPRT MDAEMONERR MSOCKNAMES
>>
>>    /usr/local/bin/safe_mysqld -O max_connections=1024 -O key_buffer=64M -O
>>  table_cache=10M -O sort_buffer=10M -O record_buffer=10M --s
>>  ocket=$MSOCKNAMES --port=$MDAEMONPRT
>>  --pid-file=/usr/local/var/$MDAEMONPID
>>  --skip-thread-priority --skip-locking >/dev/null 2>&1 &
>>
>>    echo -n "."
>>    sleep 5
>>
>>    MDAEMONLOG=2.Callisto.Clickrebates.Com.log
>>    MDAEMONPID=2.Callisto.Clickrebates.Com.pid
>>    MDAEMONERR=2.Callisto.Clickrebates.Com.err
>>    MSOCKNAMES=/tmp/mysqld.2.sock
>>    MDAEMONPRT=4002
>>
>>    export MDAEMONLOG MDAEMONPID MDAEMONPRT MDAEMONERR MSOCKNAMES
>>
>>    /usr/local/bin/safe_mysqld -O max_connections=1024 -O key_buffer=64M -O
>>  table_cache=10M -O sort_buffer=10M -O record_buffer=10M --s
>>  ocket=$MSOCKNAMES --port=$MDAEMONPRT
>>  --pid-file=/usr/local/var/$MDAEMONPID
>>  --skip-thread-priority --skip-locking >/dev/null 2>&1 &
>>
>>    echo -n "."
>  >   sleep 5

-- 
Paul DuBois, paul@stripped
Thread
Two MySQL serversJason Cox4 Apr
  • Re: Two MySQL serversDan Sjolseth4 Apr
    • RE: Two MySQL serversJason5 Apr
      • RE: Two MySQL serversPaul DuBois5 Apr
        • RE: Two MySQL serversJason5 Apr
          • RE: Two MySQL serversPaul DuBois5 Apr
            • RE: Two MySQL serversJason5 Apr
              • RE: Two MySQL serversPaul DuBois5 Apr
                • synchronization over WebRobert Schott2 May