MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Hal Vaughan Date:February 17 2005 4:28pm
Subject:Re: Using Different Database Groups On the Same Computer
View as plain text  
On Thursday 17 February 2005 10:56 am, Hassan Schroeder wrote:
> Hal Vaughan wrote:
> > I see that, but even when I bypass them, I can run 2 instances of mysqld,
> > it shows up in the task list as 2 separate tasks, but they both use the
> > data directory specified in the last instance I run.
>
> Uh, that doesn't really make sense -- a *running* instance isn't
> going to switch data directories because another process started
> up :-)

That's what's happening.  I have no idea why.  Here's what I'm doing now:
(each command is in a separate console)

mysqld --port=3307 --datadir=/dbtest/mysql
mysqld --port=3306 --datadir=/var/lib/mysql
mysql --port=3307
mysql --port=3306

When I do this, then do a "show databases;" in either new instance of mysql 
(both are open at the same time, in separate consoles), I get the databases 
in the last version of mysqld that I specified.

> Sounds like something in the way you're invoking this is causing
> the first instance to be restarted, and then it's using the second
> set of parameters.

I do a "ps-ax" and get this (only mysqld tasks pasted in):

13391 pts/10   S      0:00 mysqld --port=3307 --datadir=/dbtest/mysql
13401 pts/10   S      0:00 mysqld --port=3307 --datadir=/dbtest/mysql
13402 pts/10   S      0:00 mysqld --port=3307 --datadir=/dbtest/mysql
13403 pts/10   S      0:00 mysqld --port=3307 --datadir=/dbtest/mysql
13450 pts/9    S      0:00 mysqld --port=3306 --datadir=/var/lib/mysql
13451 pts/9    S      0:00 mysqld --port=3306 --datadir=/var/lib/mysql
13452 pts/9    S      0:00 mysqld --port=3306 --datadir=/var/lib/mysql
13453 pts/9    S      0:00 mysqld --port=3306 --datadir=/var/lib/mysql


> My preference to do this is to create a complete new config file,
> say /etc/alt.cnf, and use that to configure the second process.
> That way you can be relatively sure there aren't any overlapping
> resources.

I'll try that, in case config options can trump a command line.

Hal


> HTH!
> --
> Hassan Schroeder ----------------------------- hassan@stripped
> Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com
>
>                            dream.  code.
Thread
Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
  • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
    • Re: Using Different Database Groups On the Same ComputerHassan Schroeder17 Feb
      • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
        • Re: Using Different Database Groups On the Same ComputerHassan Schroeder17 Feb
          • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
            • Re: Using Different Database Groups On the Same ComputerHassan Schroeder17 Feb
              • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
        • Re: Using Different Database Groups On the Same ComputerKristen G. Thorson17 Feb
RE: Using Different Database Groups On the Same ComputerSST - Adelaide)17 Feb
  • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
RE: Using Different Database Groups On the Same ComputerSST - Adelaide)17 Feb
  • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb
RE: Using Different Database Groups On the Same ComputerSST - Adelaide)17 Feb
  • Re: Using Different Database Groups On the Same ComputerHal Vaughan17 Feb