Re: Bugzilla HA How to?

S Bob <[email protected]> Thu, 11 Mar 2021 13:54:54 -0700
Newsgroups gmane.comp.mozilla.devel.webtools
Message-ID <[email protected]>
1) Use PostgreSQL as the db engine

2) Setup a Hot Standby database node via PostgreSQL built in streaming 
replication

3) install Bugzilla on both nodes

4) use a DNS failover method (or something similar) to perform the 
following for a primary node failure:

a) Promote the PostgreSQL Hot Standby
b) Update the DNS / Proxy / URL so now connections are directed to the 
secondary site
c) send an alert so someone can investigate and repair the HA cluster



On 3/11/21 1:23 PM, Laci D wrote:
> Thank you for your advice!
>
> On Thursday, March 11, 2021 at 11:49:31 AM UTC-5, Thorsten Schöning wrote:
>> Guten Tag Laci D,
>> am Donnerstag, 11. März 2021 um 17:29 schrieben Sie:
>>> It is more like a planned failover, current server upgrade takes
>>> about two hours (OS upgrade, reboots, etc.) while Bugzilla is
>>> unavailable, I'd like to cut this planned downtime as short as
>>> possible. This is the main goal.
>> How do you do it for other hosted services? If you don't, don't care
>> for Bugzilla too much as well at least for the beginning. HA is REALLY
>> complex and nothing to start with only based on advices on this list.
>> Otherwise pretty much do what you are already doing with other
>> services, Bugzilla is only one more.
>>
>> There simply is no golden bullet for you in my opinion: A cluster with
>> shared storage for Bugzilla and its database will allow you most
>> likely to simply take one of the hosts offline for maintenance.
>> Bugzilla would be served by the other nodes and all would be fine.
>>
>> OTOH, those clusters shouldn't be underestimated, even with tools like
>> Proxmox making things pretty easy in THEORY. Additionally, when it's
>> about upgrading Bugzilla, the shared storage/database means that you
>> need to take all Bugzilla instances offline anyway, upgrade all of
>> them and back online again only after everything succeeded.
>>
>> I don't think I can provide any more advices on this. :-) If at all,
>> you might ask on HA-specific mailing lists/forums, because the
>> problems to solve for Bugzilla are not too Bugzilla-specific: Some
>> files and a database. Sounds VERY common with web apps... ;-)
>> Mit freundlichen Grüßen
>>
>> Thorsten Schöning
>>
>> -- 
>> AM-SoFT IT-Service - Bitstore Hameln GmbH i.G.
>> Mitglied der Bitstore Gruppe - Ihr Full-Service-Dienstleister für IT und TK
>>
>> E-Mail: [email protected]
>> Web: http://www.AM-SoFT.de/
>>
>> Tel: 05151- 9468- 0
>> Tel: 05151- 9468-55
>> Fax: 05151- 9468-88
>> Mobil: 0178-8 9468-04
>>
>> AM-SoFT IT-Service - Bitstore Hameln GmbH i.G., Brandenburger Str. 7c, 31789 Hameln
>> AG Hannover HRB neu - Geschäftsführer: Janine Galonska
>>
>>
>> Für Rückfragen stehe ich Ihnen sehr gerne zur Verfügung.
>>
>> Mit freundlichen Grüßen
>>
>> Thorsten Schöning
>>
>>
>> Tel: 05151 9468 0
>> Fax: 05151 9468 88
>> Mobil:
>> Webseite: https://www.am-soft.de
>>
>> AM-Soft IT-Service - Bitstore Hameln GmbH i.G. ist ein Mitglied der Bitstore Gruppe - Ihr Full-Service-Dienstleister für IT und TK
>>
>> AM-Soft IT-Service - Bitstore Hameln GmbH i.G.
>> Brandenburger Str. 7c
>> 31789 Hameln
>> Tel: 05151 9468 0
>>
>> Bitstore IT-Consulting GmbH
>> Zentrale - Berlin Lichtenberg
>> Frankfurter Allee 285
>> 10317 Berlin
>> Tel: 030 453 087 80
>>
>> CBS IT-Service - Bitstore Kaulsdorf UG
>> Tel: 030 453 087 880 1
>>
>> Büro Dallgow-Döberitz
>> Tel: 03322 507 020
>>
>> Büro Kloster Lehnin
>> Tel: 033207 566 530
>>
>> PCE IT-Service - Bitstore Darmstadt UG
>> Darmstadt
>> Tel: 06151 392 973 0
>>
>> Büro Neuruppin
>> Tel: 033932 606 090
>>
>> ACI EDV Systemhaus Dresden GmbH
>> Dresden
>> Tel: 0351 254 410
>>
>> Das Systemhaus - Bitstore Magdeburg GmbH
>> Magdeburg
>> Tel: 0391 636 651 0
>>
>> Allerdata.IT - Bitstore Wittenberg GmbH
>> Wittenberg
>> Tel: 03491 876 735 7
>>
>> Büro Liebenwalde
>> Tel: 033054 810 00
>>
>> HSA - das Büro - Bitstore Altenburg UG
>> Altenburg
>> Tel: 0344 784 390 97
>>
>> Bitstore IT – Consulting GmbH
>> NL Piesteritz
>> Piesteritz
>> Tel: 03491 644 868 6
>>
>> Solltec IT-Services - Bitstore Braunschweig UG
>> Braunschweig
>> Tel: 0531 206 068 0
>>
>> MF Computer Service - Bitstore Gütersloh GmbH
>> Gütersloh
>> Tel: 05245 920 809 3
>>
>> Firmensitz: AM-Soft IT-Service - Bitstore Hameln GmbH i.G. , Brandenburger Str. 7c , 31789 Hameln
>> Geschäftsführer Janine Galonska
> _______________________________________________
> support-bugzilla mailing list
> [email protected]
> https://lists.mozilla.org/listinfo/support-bugzilla
> PLEASE put [email protected] in the To: field when you reply.
_______________________________________________
support-bugzilla mailing list
[email protected]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [email protected] in the To: field when you reply.