The pros are you can run them under separate user/group ids therefore you can make it much harder for someone with access to only one to get to the other's data.
The cons are that you will have 2 copies running therefore it will take longer to maintain. =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -----Original Message----- From: Chris Stefanick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 7:56 AM To: MySQL Support Subject: setting up two instances of mySQL I have one product already using a mySQL database. We just inherited a new product (via an acquisition) that uses it's own mySQL database which we're going to stick on the same server. My manager wants me to setup a second instance of mySQL on the machine for the new product's database. I don't see the point. Why not just have both databases running under the same instance of mySQL? Which brings me to my question. What are the pros and cons of setting up multiple instances of mySQL on the same machine? Thanks so much, CS --------------------------------------------------------------------- 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