cancel
Showing results for 
Search instead for 
Did you mean: 

EDB-EFM-REPLICATIONS

Level 3 Adventurer

EDB-EFM-REPLICATIONS

Ho folks,

             I have a 4 servers,each node running in efm services,pem client and three is running database. also .

1.master

2.slave 1

3.slave 2

4.witness

Os team plan to apply patch.which one can i bring down first..

please share the details of which one i going to down first and which i going to start first after patch.please included the service and database also.

 

yours

Diny

Tags (1)
15 REPLIES 15
Highlighted
EDB Team Member

Re: EDB-EFM-REPLICATIONS

Hi  Din2pg,

 

EFM Service should have the sequence as 

1.Stop EFM Service on Witness

2.Stop EFM Service on Slave 2

3.Stop EFM Serivce on Slave 1

4.Stop EFM Serivce on Master.

 

1.Start EFM Service on Witness

2.Start EFM Service on Master

3.Start EFM Serivce on Slave 2

4.Start EFM Serivce on Slave1

 

Database cluster stop, start can be followed  with the above sequence.

 

 

EDB Team Member

Re: EDB-EFM-REPLICATIONS

Are you patching the database or efm?

 

If the database, I'd recommend:

1. Stop efm agent on one standby, patch/restart database, then start the efm agent.

2. Repeat for the other standby.

3. Perform a switchover.

4. Perform step #1 on the original master.

5. Run the 'efm set-priority' command to make the original master the highest priority and perform another switchover to go back to the original master.

 

If you're upgrading efm, just stop all the agents, e.g. 'efm stop-cluster.' Then upgrade them and start them again.

 

Cheers,

Bobby

 

EDB Team Member

Re: EDB-EFM-REPLICATIONS

 


@Rahul wrote:

Hi  Din2pg,

 

EFM Service should have the sequence as 

1.Stop EFM Service on Witness

2.Stop EFM Service on Slave 2

3.Stop EFM Serivce on Slave 1

4.Stop EFM Serivce on Master.

If you're going to stop all of them, you might as well use the 'efm stop-cluster' command. This is especially useful with older versions of efm so that the <clustername>.nodes file doesn't change on each node.

 

It also doesn't matter what order you start the agents. Though if you shut them down like above then the <clustername>.nodes file on the master won't have any addresses in it, so you might as well start that one first because it's easiest.

 

Bobby

 

Level 3 Adventurer

Re: EDB-EFM-REPLICATIONS

Hi @bbissett 

            Thanks for you promt action..but i want to clarify some thing.

see..

1.Now iam going to patch standby 1---------->can i change any parameter in master(like archive command,pg_hba.conf file edit)

       --Ios patching completed now standby1 bring back all serverice and database-----> rsync is working or not?

2.Clinet give full downtime of the four servers.which one i need to down first

      ---mster or standby 1 or standby 2(please dont confuse/include witness server)

      -

EDB Team Member

Re: EDB-EFM-REPLICATIONS


@Din2pg wrote:

Hi @bbissett 

            Thanks for you promt action..but i want to clarify some thing.

see..

1.Now iam going to patch standby 1---------->can i change any parameter in master(like archive command,pg_hba.conf file edit)

       --Ios patching completed now standby1 bring back all serverice and database-----> rsync is working or not?

2.Clinet give full downtime of the four servers.which one i need to down first

      ---mster or standby 1 or standby 2(please dont confuse/include witness server)

      -


Sorry, I can't help you with #1. For #2, it's safer I believe to patch the standby databases before the master.

 

Hopefully someone else can help out here.

 

Bobby

 

EDB Team Member

Re: EDB-EFM-REPLICATIONS

Just to be really clear about my initial question: you're talking about patching the databases, not upgrading efm, right?

 

Bobby

 

Level 3 Adventurer

Re: EDB-EFM-REPLICATIONS

Hi @bbissett 

              yes only patching time how to start and stop the serial's..not upgrade efm...

 

Thanks

Diny

EDB Team Member

Re: EDB-EFM-REPLICATIONS

Hi Din, 

 

As per my understanding. Your question would be stopping/starting agents when Maintenance.

The answer would be. For stopping EFM services , Please follow below sequence 

 

1.Stop EFM Service on Witness

2.Stop EFM Service on Slave 2

3.Stop EFM Serivce on Slave 1

4.Stop EFM Serivce on Master.

 

For Starting EFM services: You can go with any order. 

 

Please let me know if you need anymore details. 

 

Regards

Siva.

 

EDB Team Member

Re: EDB-EFM-REPLICATIONS

 


@sivamekala wrote:

Hi Din, 

 

As per my understanding. Your question would be stopping/starting agents when Maintenance.

The answer would be. For stopping EFM services , Please follow below sequence 

 

1.Stop EFM Service on Witness

2.Stop EFM Service on Slave 2

3.Stop EFM Serivce on Slave 1

4.Stop EFM Serivce on Master.

 

For Starting EFM services: You can go with any order. 

 


 

I think this was already covered above. It does not matter what order you stop the efm agents or what order you start them. Personally, I would use the 'efm stop-cluster' command and stop them all at once.

 

Cheers,

Bobby