[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 <lists at alteeve.ca> 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 at 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
<http://paypal.me/Satskiy?ppid=PPC000654&cnac=PL&rsta=en_PL(en_DK)&cust=NN8XJS9XEP22C&unptid=21db79ac-ef8d-11e5-9553-9c8e992ea258&t=&cal=4d776c21ca7d2&calc=4d776c21ca7d2&calf=4d776c21ca7d2&unp_tpcid=ppme-social-business-profile-created&page=main:email&pgrp=main:email&e=op&mchn=em&s=ci&mail=sys>
satskiy.a at gmail.com <mail%3Asatskiy.a at gmail.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.clusterlabs.org/pipermail/users/attachments/20171025/c37ef432/attachment-0002.html>