As Cal stated, there is actually a very important reason. MySQL is
lacking in fine-grained security. I can give a user the ability to add
databases. But can I give that user the ability to only drop databases
he/she created? I sure haven't found any documented method.
So, if you're in a large organization, and you don't have a certain level
of trust between the groups within that organization, each group will need
it's own instance of MySQL. Those instances could be on sererate physical
machines (2 database servers), but sometimes that's not feasible (budget
constraints, whatever).
Now, CS's orginal question... it should be possible just to dump and load
the tables from the vendor provided copy of mysql into your existing
instance. You'll need to check version numbers though (if the vendor
product isn't using a recent MySQL, you're probably SOL and will have to
go with 2 instances).
Mark R. Andrachek, Jr.
Analyst I
Federal Reserve Bank of Richmond
[EMAIL PROTECTED]
(804) 697-7971
Francisco Reinaldo <[EMAIL PROTECTED]>
06/13/2002 10:44 AM
To: [EMAIL PROTECTED], Chris Stefanick <[EMAIL PROTECTED]>,
MySQL
Support <[EMAIL PROTECTED]>
cc:
Subject: RE: setting up two instances of mySQL
Hi Chris,
I am Tom, you know your manager, did you say that I am
wrong!!!
Just kidding :-).
Well I cannot find any good reason for having two
databases in two different instance. Do you have two
Oracles or Microsoft SQL Server instances in the
computer? Nope.
The only reason when that is acceptable, is when you
want to keep two version of the same database engine.
Like having 3.23 and 4.0.
Having two MySQL instances is going to complicate
things making everything more difficult to maintain
and install.
Good Luck.
--- Cal Evans <[EMAIL PROTECTED]> wrote:
> 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
>
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
---------------------------------------------------------------------
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
