On 5/14/2014 3:45 PM, shawn l.green wrote:
> Hello Bruce,
>
> On 5/14/2014 2:11 PM, Bruce Ferrell wrote:
>> OK, put away the flamethrowers, I KNOW it's dumb.
>>
>> I've been asked for the upteenth time is this possible and if so under
>> what conditions?
>>
>> So I pose the question to the community, is it? Under what conditions?
>> Is it reliable or not?
>>
>> Are there authoritative references to support the answers?
>>
>> Inquiring minds want to know
>>
>> Thanks in advance
>>
>> Bruce Ferrell
>>
>>
>
> To provide confirmation that sharing files is a 'bad idea' between any
> two running mysqld binaries, here are the instructions in the manual on
> how to have two or more mysqld instances (which can be the same program
> or two or more different versions of mysqld) running on your machine at
> the same time. Consider a shared disk as being part of the same machine
> as it's the files that really matter in your situation.
>
> http://dev.mysql.com/doc/refman/5.6/en/multiple-servers.html
>
> Really. I mean it. Don't do it.
>

However, if what you want to do is have two MySQL instances setup to
point to the same files from the same machine or different host machines
(such as in a shared SAN disk), you can do that but only one (and I do
mean exactly one) of them may be started up at a time. This is known as
an Active/Passive configuration and it is one of our published HA options.

http://www.mysql.com/content/download/id/284/

--
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql