Thanks Don, Gurhan, Peter! uhg. I am sure I searched the docs first. *sigh*
-----Original Message----- From: Don Vu [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 3:19 PM To: Gurhan Ozen; Luc Foisy; MYSQL-List (E-mail) Subject: RE: Two database servers, same physical server more detail on this can be found here http://www.mysql.com/doc/M/u/Multiple_servers.html -----Original Message----- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 3:10 PM To: Luc Foisy; MYSQL-List (E-mail) Subject: RE: Two database servers, same physical server Hi, To run multiple mysqld servers, you at least have to specify a different port number, different socket file path, different pid and error log file to get it started. Different mysqld servers may point to the same database. To do this, just define the necessary information for your new mysqld server in a my.cnf file, and start it with ./bin/safe_mysqld --defaults-file=/path/to/new/my.cnf & . Gurhan -----Original Message----- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 1:33 PM To: MYSQL-List (E-mail) Subject: Two database servers, same physical server Has someone done this before? What things do I have to take into consideration The following are things I know that may be issues reading mysql.sock reading my.cnf database directory ( there is a parameter for command line operation ) I would suppose I would have to create a dual instance of the daemon script Anything else I might be missing? What should I do to make this work? ------------------- Why do I want to do this? Replication. One slave can not be slave to mulitple masters. ( as far as I know ). I do not want to have a so many servers as I have clients ( the replication is a saftey thing offered by us, most clients still have thier own replication server, but some just can not afford it, so we replicate for them. ) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
