Re: [ClusterLabs] MYSQL data on DRBD

[Антон Сацкий]

Digimer  yes U r right i need   to run Mysql on one server
but somehow  when i run
pcs resource create MYSQL lsb:mysql
pacameker  also trying to start mysql on a backup server

Oct 25 12:43:42 voipserver.primary pengine[21418]:  warning: Processing
failed op start for MYSQL on voipserver.backup: unknown error (1)
Oct 25 12:43:42 voipserver.primary pengine[21418]:  warning: Processing
failed op start for MYSQL on voipserver.backup: unknown error (1)
Oct 25 12:43:43 voipserver.primary pengine[21418]:  warning: Processing
failed op start for MYSQL on voipserver.backup: unknown error (1)
Oct 25 12:43:43 voipserver.primary pengine[21418]:  warning: Processing
failed op start for MYSQL on voipserver.backup: unknown error (1)

On Tue, Oct 24, 2017 at 10:55 PM, Digimer  wrote:

> On 2017-10-24 10:31 AM, Ken Gaillot wrote:
> > On Tue, 2017-10-24 at 13:48 +0300, Антон Сацкий wrote:
> >> HI list
> >> need  inf how to setup cluster MYSQL
> >> if DB files and  libs are on DRBD
> >
> > Hi Antony,
> >
> > There was a recent discussion of such a setup on this list. The general
> > conclusion was that it poses problems, especially during mysql
> > upgrades. A better possibility might be to use mysql native replication
> > between the two servers. If desired, a pair of servers on a DRBD
> > cluster could be used for each endpoint instead of a single server.
> >
> >>
> >> PS only one instance of mysql  is running
>
> Running MySQL on one node at a time with DRBD replicating should be just
> fine. The trick comes when you want to run it in two+ places at the same
> time.
>
> Anthony,
>
> You setup a colocated service with DRBD -> FS -> MySQL -> virtual IP and
> run DRBD in single primary. With proper fencing (which you need anyway),
> you'll be just fine.
>
> --
> Digimer
> Papers and Projects: https://alteeve.com/w/
> "I am, somehow, less interested in the weight and convolutions of
> Einstein’s brain than in the near certainty that people of equal talent
> have lived and died in cotton fields and sweatshops." - Stephen Jay Gould
>
> ___
> Users mailing list: Users@clusterlabs.org
> http://lists.clusterlabs.org/mailman/listinfo/users
>
> Project Home: http://www.clusterlabs.org
> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> Bugs: http://bugs.clusterlabs.org
>



-- 
Best regards
Antony
tel.   +380669197533
tel2. +380636564340
Paypal http://paypal.me/Satskiy

satski...@gmail.com 
___
Users mailing list: Users@clusterlabs.org
http://lists.clusterlabs.org/mailman/listinfo/users

Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org

Re: [ClusterLabs] MYSQL data on DRBD

[Digimer]

On 2017-10-24 10:31 AM, Ken Gaillot wrote:
> On Tue, 2017-10-24 at 13:48 +0300, Антон Сацкий wrote:
>> HI list 
>> need  inf how to setup cluster MYSQL   
>> if DB files and  libs are on DRBD
> 
> Hi Antony,
> 
> There was a recent discussion of such a setup on this list. The general
> conclusion was that it poses problems, especially during mysql
> upgrades. A better possibility might be to use mysql native replication
> between the two servers. If desired, a pair of servers on a DRBD
> cluster could be used for each endpoint instead of a single server.
> 
>>  
>> PS only one instance of mysql  is running 

Running MySQL on one node at a time with DRBD replicating should be just
fine. The trick comes when you want to run it in two+ places at the same
time.

Anthony,

You setup a colocated service with DRBD -> FS -> MySQL -> virtual IP and
run DRBD in single primary. With proper fencing (which you need anyway),
you'll be just fine.

-- 
Digimer
Papers and Projects: https://alteeve.com/w/
"I am, somehow, less interested in the weight and convolutions of
Einstein’s brain than in the near certainty that people of equal talent
have lived and died in cotton fields and sweatshops." - Stephen Jay Gould

___
Users mailing list: Users@clusterlabs.org
http://lists.clusterlabs.org/mailman/listinfo/users

Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org

Re: [ClusterLabs] MYSQL data on DRBD

[Ken Gaillot]

On Tue, 2017-10-24 at 13:48 +0300, Антон Сацкий wrote:
> HI list 
> need  inf how to setup cluster MYSQL   
> if DB files and  libs are on DRBD

Hi Antony,

There was a recent discussion of such a setup on this list. The general
conclusion was that it poses problems, especially during mysql
upgrades. A better possibility might be to use mysql native replication
between the two servers. If desired, a pair of servers on a DRBD
cluster could be used for each endpoint instead of a single server.

>  
> PS only one instance of mysql  is running 
>     
> 
> -- 
> Best regards
> Antony
> tel.   +380669197533
> tel2. +380636564340
> Paypal http://paypal.me/Satskiy
> satski...@gmail.com
-- 
Ken Gaillot 

___
Users mailing list: Users@clusterlabs.org
http://lists.clusterlabs.org/mailman/listinfo/users

Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org

[ClusterLabs] MYSQL data on DRBD

[Антон Сацкий]

HI list
need  inf how to setup cluster MYSQL
if DB files and  libs are on DRBD
PS only one instance of mysql  is running


-- 
Best regards
Antony
tel.   +380669197533
tel2. +380636564340
Paypal http://paypal.me/Satskiy

satski...@gmail.com 
___
Users mailing list: Users@clusterlabs.org
http://lists.clusterlabs.org/mailman/listinfo/users

Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org