Re: Bugzilla HA How to?

I was thinking to do something like:
- point bugzilla.hostame.com to bugzilla-01.hostame.com
- stand up a bugzilla-02.hostame.com server which syncs /usr/local/www/bugzilla/data/ from 01 to 02 (either with rsync or with zfs snapshots, the servers are/will be on FreeBSD)

During a maintenance window we'd be doing:
- set bugzilla-01.hostame.com read only (if bugzilla has such an option, if not change DB connection to a read only replica)
- sync /usr/local/www/bugzilla/data/ from 01 to 02
- point bugzilla.hostame.com to bugzilla-02.hostame.com
- do required maintenance on bugzilla-01.hostame.com (patching, migrating, upgrading, etc)
- set bugzilla-02.hostame.com read only (if bugzilla has such an option, if not change DB connection to a read only replica)
- sync /usr/local/www/bugzilla/data/ from 02 to 01
- set bugzilla-01.hostame.com read/write
- point bugzilla.hostame.com to bugzilla-02.hostame.com

What do you think, does this look feasible?

Viel dank!
Laci


On Thursday, March 11, 2021 at 3:18:03 AM UTC-5, Thorsten Schöning wrote:
> Guten Tag Laci D, 
> am Mittwoch, 10. März 2021 um 21:23 schrieben Sie:
> > Does anyone have experience setting up Bugzilla in a highly available architecture? 
> > Basically to have two servers behind one hostname, either 
> > active-active or active-passive setup.
> I can't remember a such specific discussion on this list yet. 
> 
> Because there are so many different possibilities to implement HA, it 
> might be a better idea if you start with telling people about what 
> technologies you have experience with, how automated you NEED things 
> to be, which downtime you really CAN NOT accept for which reason etc. 
> 
> E.g., in the easiest case Bugzilla supports using a shadow database 
> already, which makes at least that part some kind of fault tolerant 
> for at least reads. 
> 
> https://bugzilla.readthedocs.io/en/5.0/administering/parameters.html#shadow-database 
> 
> OTOH, Bugzilla stores things in the file system as well, so a shadow 
> database wouldn't cover everything anyway. Though, depending on your 
> needs, file systems can be pretty efficiently mirrored with somewhat 
> low admin maintenance using simply RSYNC and a cronjob or by sending 
> snapshots for file systems like BTRFS and ZFS using a cron job. I'm 
> successfully using ZREP with Ubuntu 16.04 for some years in some kind 
> of active-passive setup. 
> 
> http://www.bolthole.com/solaris/zrep/ 
> 
> So you don't necessarily need clusters like Proxmox, shared block 
> devices like with DRBD or alike. It heavily depends on your needs. 
> 
> https://pve.proxmox.com/wiki/Main_Page 
> https://en.wikipedia.org/wiki/Distributed_Replicated_Block_Device 
> 
> 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.