RetroBBS - comp.databases.mysql - How to prevent the MEMBER

How to prevent the MEMBER_ROLE from being changed

<d8b6c05f-8601-4044-ad99-a20a03c63e00n@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=20&group=comp.databases.mysql#20

copy link Newsgroups: comp.databases.mysql

X-Received: by 2002:ac8:5c8c:: with SMTP id r12mr4124014qta.265.1623317194749;
Thu, 10 Jun 2021 02:26:34 -0700 (PDT)
X-Received: by 2002:a05:6214:1502:: with SMTP id e2mr4173516qvy.14.1623317194617;
Thu, 10 Jun 2021 02:26:34 -0700 (PDT)
Path: i2pn2.org!i2pn.org!paganini.bofh.team!usenet.pasdenom.info!usenet-fr.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.mysql
Date: Thu, 10 Jun 2021 02:26:34 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=113.33.220.242; posting-account=Lg1i_QoAAABPYcS85_5cNd8bbfyYawjT
NNTP-Posting-Host: 113.33.220.242
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <d8b6c05f-8601-4044-ad99-a20a03c63e00n@googlegroups.com>
Subject: How to prevent the MEMBER_ROLE from being changed
From: r-ikeda@estore.co.jp (ikeda)
Injection-Date: Thu, 10 Jun 2021 09:26:34 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

by: ikeda - Thu, 10 Jun 2021 09:26 UTC

Is there a way to configure a server configured with single_primary_mode so that the SECONDARY server does not automatically become PRIMARY when the PRIMARY server fails?

※The reason I'm using this configuration is that I'm planning to set up group replication and change the settings later.

I appreciate any guidance or advice you can give me.
Thanks,

Ryo Ikeda

I've looked at the listing, and it's right! -- Joel Halpern

devel / comp.databases.mysql / How to prevent the MEMBER_ROLE from being changed

Subject	Author
How to prevent the MEMBER_ROLE from being changed	ikeda