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. ) Now that I have written the above "R" word, this mail will be completely ignored. Why is that? I have yet to see answers to any questions in regards to replication. Is it that nobody else uses replication except the people who have problems, or just that no person has extended knowlegde on the issue and they just keep their mouths shut so they don't lead others astray. Just curious. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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