Db2

 View Only
Expand all | Collapse all

Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

  • 1.  Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted Tue June 04, 2024 11:24 AM
    Edited by Luis Dorantes Mon June 24, 2024 02:37 PM

    If you missed the webinar, you can find the recording here.

    Join us for an insightful discussion on June 18, 2024 at 11:00 AM ET to get an overview of Pacemaker 101. Tharmiga Loganathan will delve into the pivotal transition from TSA to Pacemaker.

    Click here to register and add the event to your calendar.

    Where is the link to join? Check your email the day before the event!

    How to get the most out of this webinar:

    • Explore the Db2 Community.

    • Ask questions for the presenter by replying to this discussion post before, during and after the webinar. Tharmiga Loganathan will be happy to answer your questions and share insights.

    • Check out upcoming Db2 events here.

    We look forward to seeing you there!



    ------------------------------
    Medha Parekh
    ------------------------------



  • 2.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted Mon June 17, 2024 05:42 PM

    Is Pacemaker available for AIX?



    ------------------------------
    Hector Fernandez
    ------------------------------

    Original Message


  • 3.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted Tue June 18, 2024 04:07 AM

    Pacemaker is currently running on Linux only, but AIX support is on the roadmap and will be available in one of the next DB2 releases.

    Regards, Damir



    ------------------------------
    Damir Wilder
    ------------------------------

    Original Message


  • 4.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted 13 days ago

    Hi Damir,

    Thanks for the info.
    We are looking into building our first Purescale environment, of a considerable size. Currently, we use TSA as our clustering solution for different services on AIX, however, are in the process of replacing it with PowerHA.

    Pacemaker is generally not available on AIX, as far as we understand. Will the future DB2 (and Purescale) setup for AIX support PowerHA as integrated clustering solution, or will pacemaker be ported to AIX (which would be quite an endeavour).

    From my point of view PowerHA is much more robust than pacemaker or TSA, so I would hope for PowerHA for Purescale.

    Thanks again, and Regards,

    Matthias



    ------------------------------
    Matthias Hofer
    ------------------------------

    Original Message


  • 5.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted 11 days ago

    Hi Matthias,

    TSA is definitely going away so it's good (and advisable) to replace it with something else (PowerHA, Pacemaker...).

    However, as I don't work for IBM I can't really tell you if PowerHA will be supported for the Purescale in the future - maybe an IBMer can chime in here and give their opinion on the matter?

    Some clients of mine who also use both technologies (PowerHA/AIX and Pacemaker-MF/Linux) share your opinion on PowerHA being more robust than Pacemaker, at least for now, so it would (probably?) make sense to keep the PowerHA support for Purescale on AIX. Either that or improve the Pacemaker-Mutual Failover option (which is an equivalent of PowerHA on Linux platforms).

    In any case, I think it would be worth to go to the DB2 Ideas Portal (https://ibm-data-and-ai.ideas.ibm.com/) and open a new idea for this case. If it gains enough votes it will certainly be looked at by the right people :-)

    Kind regards, Damir

     



    ------------------------------
    Damir Wilder
    Senior Consultant
    Triton Consulting
    London
    ------------------------------

    Original Message


  • 6.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted 11 days ago

    Hi Matthias, as you probably know, Purescale has a very tight integration with the cluster manager, and it is a significant effort to add support for other cluster managers.  We are currently not looking to support Pacemaker in AIX, so TSA is our only option. We have not looked at expanding the support to PowerHA.

    Christian



    ------------------------------
    Christian Garcia-Arellano STSM, Db2 Senior Architect, and Master Inventor
    ------------------------------

    Original Message


  • 7.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted 10 days ago
    Edited by Matthias Hofer 10 days ago

    Hi Christian,

    Thanks for your information.

    In

    https://www.ibm.com/docs/en/db2/11.5?topic=pacemaker-restrictions and

    https://community.ibm.com/community/user/datamanagement/blogs/alan-lee/2023/09/18/the-book-of-db2-pacemaker-chapter-1 (Q8)

    It says, that the AIX support is on the roadmap and that non-TSA will be supported in a future release (even saying "The days of TSA in Db2 is numbered"). What you pointed out sounds like there will be no actual move away from TSA as an integrated cluster solution on AIX.

    Can you confirm that the statement about the roadmap for AIX is incorrect and that TSA is here to stay for Purescale on AIX?

    Thanks again for the clarification, and Regards,

    Matthias



    ------------------------------
    Matthias Hofer
    ------------------------------

    Original Message


  • 8.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted 10 days ago

    Matthias,

    This was discussed at the recent Db2 Technical Advisory Board meeting prior to IDUG EMEA a couple of weeks ago.

    It does appear to be a change of strategy on the AIX front.  We all thought that TSA/MP was going away for everything and that Pacemaker would be the way forward.

    But the position now appears to be that there will be a different cluster manager most appropriate to the operating system -

    • Pacemaker on Linux
    • TSA/MP on AIX
    • Windows Cluster Manager on Windows (just for HADR I think)

    As someone who supports both AIX and Linux systems it isn't exactly thrilling to have to understand multiple cluster managers.  

    It sounds like they've looked at the amount of work involved in porting Pacemaker to AIX and decided they didn't have resources to both do the port and then support it.

    Phil



    ------------------------------
    Philip Nelson
    Senior Database Software Engineer
    Lloyds Banking Group / ScotDB Limited
    Edinburgh
    ------------------------------

    Original Message


  • 9.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted 10 days ago

    Phil,

    Thanks for the fascinating insights!

    We used PowerHA/HACMP for many years in our enviroment, but switched to TSA about 12 years ago to have a common clustering solution for AIX and Linux.

    However, we fled to Pacemaker in Linux, not only because of quality/desgin issues with TSA but also because SAP HANA only supported Pacemaker as integrated solution.

    After many years now we are ready to move everything in AIX from TSA to PowerHA, which we just tested again a year ago and is a fascinating product and seems very well built and integrated, compared to the other solutions.

    So I might open an "idea" to have PowerHA supported as integrated clustering solution in DB2 [Purescale] on AIX so that TSA can finally completely removed from the products and one can use a dependable setup (Power, AIX, PowerHA) for DB2.

    Please, share as well your thoughts on this "idea" and if there is any chance to have the TSA requirement removed in such a way in any future.

    Thanks again,

    Matthias



    ------------------------------
    Matthias Hofer
    ------------------------------

    Original Message


  • 10.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted 10 days ago

    Hi Matthias,

    Phil's answer is correct, that is the new direction from the Db2 team. The only clarification I would make is that it is not just related to the amount of work involved, but also due to the very tight integration of the cluster manager with the operating system. Since Pacemaker was developed for Linux, when we looked at the porting effort, it really required very deep AIX skills and likely changes within AIX itself in order to support it, and this would be better suited to be done by the AIX team.  So the new direction is really to continue to exploit the best cluster manager for each platform. We also feel the pain point you point out, but the support of Pacemaker opens us to exploiting the best cluster manager for Linux environments. In addition, with the introduction of the db2cm tool to manage all HA integrations with Pacemaker, including HADR, MF, DPF and pureScale (the last 2 are new in v12.1), we have a much better story for DBAs to manage all of the HA platforms we support on Linux, so we feel that this is a big step up in the usability. 

    Christian



    ------------------------------
    Christian Garcia-Arellano STSM, Db2 Senior Architect, and Master Inventor
    ------------------------------

    Original Message


  • 11.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted 9 days ago

    Hi Christian,

    > So the new direction is really to continue to exploit the best cluster manager for each platform. 

    I think this is a good strategy! And I feel that this is Pacemaker for Linux!
    However, I would also feel this should be PowerHA on AIX.

    > We also feel the pain point you point out, but the support of Pacemaker opens us to exploiting the best cluster manager for Linux environments. 

    I fully argree!

    Maybe there was a misunderstanding: I am not here to push a port of Pacemaker to AIX, because I would also deem this unrealistic, especially taking quality in account. Instead, I am pushing to make the "best cluster manager for each platform" the integrated solution, which in my view is, again PowerHA on AIX and Pacemaker on Linux.

    You would not have any effort in porting it, "only" the integration into the DB2 toolset.

    I hope, by that there is a chance you don't need to support TSA in the future any more, which maybe should make your (and our) life easier.

    Thanks again!

    Matthias



    ------------------------------
    Matthias Hofer
    ------------------------------

    Original Message


  • 12.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted 9 days ago

    Hi Matthias, we are not looking at PowerHA, there are no plans to replace the cluster manager we use in AIX. 

    Christian



    ------------------------------
    Christian Garcia-Arellano STSM, Db2 Senior Architect, and Master Inventor
    ------------------------------

    Original Message


  • 13.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted 5 days ago

    Hi Christian,

    Thanks for the clarification.

    I opened now an "IBM idea" regarding this topic:

    https://ibm-data-and-ai.ideas.ibm.com/ideas/DB24LUW-I-2062

    Everybody who feels the same way, feel free to vote for the idea/change request.

    Thanks for the helpful discussion, and have good time!

    Matthias



    ------------------------------
    Matthias Hofer
    ------------------------------

    Original Message


  • 14.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted 13 days ago
    Edited by Matthias Hofer 12 days ago

    [ double post removed ]



  • 15.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted Tue June 18, 2024 09:20 PM

    There were a couple of questions that were asked during the presentation today. Here is a copy of all of the Q&A:

    Question 1: In DPF balanced HA configuration, does pacemaker automatically resize bufferpool and other Db2 memory area fit system memory as there are more number of DB partitions running on each surviving hosts after partitions are redistributed?

    Answer 1: For the "balanced HA" configuration, you must size your instance memory size with the fact that partitions may failover in mind. That is you need to configure the partitions to leave room for other partitions to start on the local host. It does not automatically resize for you at this point.

    Question 2: If we have only 2 nodes, is Qdevice mandatory and do we need a 3rd host for setting up Qdevice?

    Answer 2: The Qdevice is required for fencing functionality. So if you have just two nodes and there is a split brain (network partition), the nodes can't communicate to each other. They can't actually tell which host should stay up and which host should get fenced. So you need the Qdevice there as an arbitrator to determine who stays up and who goes down. And yes, the Qdevice should be on a 3rd host.

    Big thanks to @Gerry Sommerville for answering those questions during the webinar.



    ------------------------------
    Tharmiga Loganathan
    ------------------------------

    Original Message


  • 16.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted Tue June 18, 2024 09:22 PM

    Hello.

    Thank you for your webinar yesterday.
    If you don't mind, can I get the document?

    Thank you.



    ------------------------------
    DAEYOUL LEE
    ------------------------------

    Original Message


  • 17.  RE: Webinar:Pacemaker 101 - Intro to Pacemaker Available on Demand

    Posted Tue June 18, 2024 09:41 PM

    Hi @DAEYOUL LEE you can find Presentation Material and Recording in this Link 
    If you missed the webinar, you can find the recording here.



    ------------------------------
    Luis Dorantes | Data Community Manager
    IBM
    ------------------------------

    Original Message