rolling schema upgrade RSU

[GETandSELECT]

Hi

How to temp. remove on node from cluster for rolling schema upgrade RSU SET GLOBAL wsrep_OSU_method='RSU';? What's the simplest way? Or is it better only disable node in Switchboard? Can you write a few lines about RSU?

thank you

[cf-gitbot]

We have created an issue in Pivotal Tracker to manage this:

https://www.pivotaltracker.com/story/show/153117534

The labels on this github issue will be updated when the story is started.

[menicosia]

Hi @GETandSELECT it turns out we don't have an OSS document for this, but the commercial docs have something that may work for you.

Let us know, I'd love to hear about your experiences using RSU some time in the future!

-- Marco Nicosia Product Manager Pivotal Software, Inc.

[ldangeard-orange]

Hi @GETandSELECT, turn a node to RSU it's just for simple opérations, like :

• CREATE INDEX for a large table
• CREATE TABLE new table
• Create new columns or drop columns (be careful with your application)

SET GLOBAL wsrep_OSU_method='RSU'
CREATE INDEX..
SET GLOBAL wsrep_OSU_method='TOI'

Warning : In RSU insert, update and delete are replicated ! Do not CREATE TABLE <newtable> and afterINSERT INTO <new table>, the galera cluster crash because table not exist and the other nodes

[menicosia]

@ldangeard-orange, in this line:

In RSU insert, update and delete are replicated !

Did you mean are not replicated?

But yes, in general, RSU is only intended for long-running DDL, like adding a new column with a default value. It can also be used, I believe, for very expensive DML, like running a query which will create a huge data delta.

-- Marco Nicosia Product Manager Pivotal Software, Inc.

[menicosia]

@GETandSELECT just ping on this issue; have you gotten what you need from mine and @ldangeard-orange's comments?

[ldangeard-orange]

No comment. Thanks

[menicosia]

Hey @GETandSELECT: I notice that GH has no "direct message" facility. I wish to ask you a couple of questions, would you mind either connecting with me on LinkedIn etc (your choice) or dropping me an e-mail at mnicosia@pivotal.io?