[Koha-devel] [Koha] Redundant infrastructure for Koha

[Chris Cormack]

If you allow people to upload files sure.

We usually don't that is what a CMS is for. (Uploaded images are
stored in the db)

And yes talking to a DB is a solved problem, thousands of applications
around the world do that already.
The only thing that is unique to Koha is Zebra

Chris

On 8 November 2016 at 09:17, Rodrigo Santellan <rsantellan at gmail.com> wrote:
> Chris,
>
> What about the uploaded files? You will need to replicate them to the other
> server.
>
> What about the cross connection of the DB, you will use mysql proxy in the
> middle?
>
> I'm really curious about those answers.
>
> Regards.
>
> On Mon, Nov 7, 2016 at 5:05 PM, Chris Cormack <chris at bigballofwax.co.nz>
> wrote:
>>
>> On 8 November 2016 at 08:50, Michael Kuhn <mik at adminkuhn.ch> wrote:
>> > Hi,
>> >
>> > We are looking for a solution to build a redundant infrastructure for
>> > Koha.
>> >
>> > What we want to do is shown in the diagram
>> > http://adminkuhn.ch/download/Redundant.png
>> >
>> > The main objective of such a solution is: If one of the Application
>> > Servers
>> > goes down the other will take over the job without losing any time. If
>> > the
>> > DB-Server Master goes down we will be able to build the Master out of
>> > the
>> > Slave and create a new Slave next to the new Master.
>> >
>> > Has anyone ever built such an infrastructure with Koha and can give us
>> > some
>> > advice how to proceed? Is this possible with Koha anyway?
>>
>>
>> Will shift this to Koha-devel
>>
>> Yes this is possible and quite easy to do. What makes it tricky is
>> Zebra, which you have left out
>> of your diagram.
>> You either need to have the full zebra index on both your application
>> servers (which means modifying rebuild_zebraqueue to make
>> sure it gets built by each machine)
>> Or you need to use something like nfs or another distributed
>> filesystem. Or use rsync etc.
>>
>> It becomes a lot easier with elasticsearch of course, because you just
>> have your elastic cluster
>> and they talk to that.
>>
>> Hope this helps
>>
>> Chris
>>
>> >
>> > Best wishes: Michael
>> > --
>> > Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
>> > Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
>> > T 0041 (0)61 261 55 61 · E mik at adminkuhn.ch · W www.adminkuhn.ch
>> > _______________________________________________
>> > Koha mailing list  http://koha-community.org
>> > Koha at lists.katipo.co.nz
>> > https://lists.katipo.co.nz/mailman/listinfo/koha
>> _______________________________________________
>> Koha-devel mailing list
>> Koha-devel at lists.koha-community.org
>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>> website : http://www.koha-community.org/
>> git : http://git.koha-community.org/
>> bugs : http://bugs.koha-community.org/
>
>