KOHA with PostgreSQL
Hi List, just wondering, if any experience using KOHA with PostgreSQL database, and my second inquiry is - any libraries using Koha for the bibliographic database with ca. 4 million records. Is it stable? thanks Araik
Unfortunately, Koha will not currently work with PostgreSQL. It's pretty heavily tied to either MySQL or MariaDB. We are in the midst of an effort to convert old code to use a database abstraction layer that would allow PostgreSQL, but that's not likely to be finished in the near future. However, there are a number of libraries using Koha at that scale. You will need a fairly powerful server (or two, with the database on a separate server), but it's workable. 2015-10-09 2:05 GMT-06:00 Arayik Manukyan <araik@flib.sci.am>:
Hi List, just wondering, if any experience using KOHA with PostgreSQL database, and my second inquiry is - any libraries using Koha for the bibliographic database with ca. 4 million records. Is it stable? thanks Araik
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Jesse Weaver
I'd like to share that we serve more than 13.200.000 records (adding more than 20.000 items per day) to 1.126 public libraries consoritum with 1.000.000 users (adding more than 2.000 new users everyday), I think it is biggest Koha installation around the world, We use Mariadb on clustered servers and we are very comfortable with the performance. Of course, our technical staff trace the servers and databased everyday. -- /Saygılarımla/ /Mengü YAZICIOĞLU/ /MERKEZ Adres : Mustafa Kemal Mah. Seferoğlu Plaza 2141.Sk No:11/6 ÇANKAYA/ANKARA Telefon : +90 - 312 - 219 84 30 Cep : +90 - 532 - 701 90 27 e-posta : mengu@devinim.com.tr / On 09-10-2015 18:31, Jesse wrote:
Unfortunately, Koha will not currently work with PostgreSQL. It's pretty heavily tied to either MySQL or MariaDB. We are in the midst of an effort to convert old code to use a database abstraction layer that would allow PostgreSQL, but that's not likely to be finished in the near future.
However, there are a number of libraries using Koha at that scale. You will need a fairly powerful server (or two, with the database on a separate server), but it's workable.
2015-10-09 2:05 GMT-06:00 Arayik Manukyan <araik@flib.sci.am>:
Hi List, just wondering, if any experience using KOHA with PostgreSQL database, and my second inquiry is - any libraries using Koha for the bibliographic database with ca. 4 million records. Is it stable? thanks Araik
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
You can share the URL of this library, it sounds great regards -Carlos +569 6668 32 94 2015-10-11 16:15 GMT-03:00 Mengu Yazicioglu <mengu@devinim.com.tr>:
I'd like to share that we serve more than 13.200.000 records (adding more than 20.000 items per day) to 1.126 public libraries consoritum with 1.000.000 users (adding more than 2.000 new users everyday),
I think it is biggest Koha installation around the world, We use Mariadb on clustered servers and we are very comfortable with the performance. Of course, our technical staff trace the servers and databased everyday.
--
/Saygılarımla/ /Mengü YAZICIOĞLU/ /MERKEZ Adres : Mustafa Kemal Mah. Seferoğlu Plaza 2141.Sk No:11/6 ÇANKAYA/ANKARA Telefon : +90 - 312 - 219 84 30 Cep : +90 - 532 - 701 90 27 e-posta : mengu@devinim.com.tr /
On 09-10-2015 18:31, Jesse wrote:
Unfortunately, Koha will not currently work with PostgreSQL. It's pretty heavily tied to either MySQL or MariaDB. We are in the midst of an effort to convert old code to use a database abstraction layer that would allow PostgreSQL, but that's not likely to be finished in the near future.
However, there are a number of libraries using Koha at that scale. You will need a fairly powerful server (or two, with the database on a separate server), but it's workable.
2015-10-09 2:05 GMT-06:00 Arayik Manukyan <araik@flib.sci.am>:
Hi List,
just wondering, if any experience using KOHA with PostgreSQL database, and my second inquiry is - any libraries using Koha for the bibliographic database with ca. 4 million records. Is it stable? thanks Araik
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
http://koha.ekutuphane.gov.tr Just in Turkish for the moment, sorry. This is the portal of all 1.126 public libraries of Turkey. On 11-10-2015 23:17, Carlos Rodrigo Cordova Sandoval wrote:
You can share the URL of this library, it sounds great
regards
-Carlos +569 6668 32 94
2015-10-11 16:15 GMT-03:00 Mengu Yazicioglu <mengu@devinim.com.tr <mailto:mengu@devinim.com.tr>>:
I'd like to share that we serve more than 13.200.000 records (adding more than 20.000 items per day) to 1.126 public libraries consoritum with 1.000.000 users (adding more than 2.000 new users everyday),
I think it is biggest Koha installation around the world, We use Mariadb on clustered servers and we are very comfortable with the performance. Of course, our technical staff trace the servers and databased everyday.
--
/Saygılarımla/ /Mengü YAZICIOĞLU/ /MERKEZ Adres : Mustafa Kemal Mah. Seferoğlu Plaza 2141.Sk No:11/6 ÇANKAYA/ANKARA Telefon : +90 - 312 - 219 84 30 Cep : +90 - 532 - 701 90 27 e-posta : mengu@devinim.com.tr <mailto:mengu@devinim.com.tr> /
On 09-10-2015 18:31, Jesse wrote:
Unfortunately, Koha will not currently work with PostgreSQL. It's pretty heavily tied to either MySQL or MariaDB. We are in the midst of an effort to convert old code to use a database abstraction layer that would allow PostgreSQL, but that's not likely to be finished in the near future.
However, there are a number of libraries using Koha at that scale. You will need a fairly powerful server (or two, with the database on a separate server), but it's workable.
2015-10-09 2:05 GMT-06:00 Arayik Manukyan <araik@flib.sci.am <mailto:araik@flib.sci.am>>:
Hi List, just wondering, if any experience using KOHA with PostgreSQL database, and my second inquiry is - any libraries using Koha for the bibliographic database with ca. 4 million records. Is it stable? thanks Araik
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha
Oh wow... Those are really impressive figures! Is it just one huge Koha install, or does every single library has its own Koha? If it is just one Koha, i guess you had to make specific patches? (I imagine having hundreds of libraries defined in the branches could be a problem at some places in the interface...) It's great to see Koha being put to such use anyway! Is there a public opac we can see? Best regards, Le 11/10/2015 21:15, Mengu Yazicioglu a écrit :
I'd like to share that we serve more than 13.200.000 records (adding more than 20.000 items per day) to 1.126 public libraries consoritum with 1.000.000 users (adding more than 2.000 new users everyday),
I think it is biggest Koha installation around the world, We use Mariadb on clustered servers and we are very comfortable with the performance. Of course, our technical staff trace the servers and databased everyday.
-- Gaetan Boisson Chef de projet bibliothécaire BibLibre 06 52 42 51 29 108 avenue Breteuil 13006 Marseille gaetan.boisson@biblibre.com
Hi, It's in only one Koha installation for all public libraries, and we've done many implementations for them, and hopefully we do not face with any problems. There are some small issues but we can handle them. koha.ekutuphane.gov.tr is public OPAC, but in Turkish unfortunately, you may search some specific letter for example "a" for Tum Kutuphaneler and you'll see the speed. Thanks. Mengu On 12-10-2015 13:10, Gaetan Boisson wrote:
Oh wow... Those are really impressive figures! Is it just one huge Koha install, or does every single library has its own Koha? If it is just one Koha, i guess you had to make specific patches? (I imagine having hundreds of libraries defined in the branches could be a problem at some places in the interface...)
It's great to see Koha being put to such use anyway! Is there a public opac we can see?
Best regards,
Le 11/10/2015 21:15, Mengu Yazicioglu a écrit :
I'd like to share that we serve more than 13.200.000 records (adding more than 20.000 items per day) to 1.126 public libraries consoritum with 1.000.000 users (adding more than 2.000 new users everyday),
I think it is biggest Koha installation around the world, We use Mariadb on clustered servers and we are very comfortable with the performance. Of course, our technical staff trace the servers and databased everyday.
Hi Mengu, curious, which version of Koha are you running? And are you using a custom theme for the OPAC? Katrin Am 12.10.2015 um 16:13 schrieb Mengu Yazicioglu:
Hi,
It's in only one Koha installation for all public libraries, and we've done many implementations for them, and hopefully we do not face with any problems. There are some small issues but we can handle them.
koha.ekutuphane.gov.tr is public OPAC, but in Turkish unfortunately,
you may search some specific letter for example "a" for Tum Kutuphaneler and you'll see the speed.
Thanks. Mengu
On 12-10-2015 13:10, Gaetan Boisson wrote:
Oh wow... Those are really impressive figures! Is it just one huge Koha install, or does every single library has its own Koha? If it is just one Koha, i guess you had to make specific patches? (I imagine having hundreds of libraries defined in the branches could be a problem at some places in the interface...)
It's great to see Koha being put to such use anyway! Is there a public opac we can see?
Best regards,
Le 11/10/2015 21:15, Mengu Yazicioglu a écrit :
I'd like to share that we serve more than 13.200.000 records (adding more than 20.000 items per day) to 1.126 public libraries consoritum with 1.000.000 users (adding more than 2.000 new users everyday),
I think it is biggest Koha installation around the world, We use Mariadb on clustered servers and we are very comfortable with the performance. Of course, our technical staff trace the servers and databased everyday.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Changing the name of this interesting thread, so it can be found in the archives. :) Bob On 13/10/15 01:13, Mengu Yazicioglu wrote:
Hi,
It's in only one Koha installation for all public libraries, and we've done many implementations for them, and hopefully we do not face with any problems. There are some small issues but we can handle them.
koha.ekutuphane.gov.tr is public OPAC, but in Turkish unfortunately,
you may search some specific letter for example "a" for Tum Kutuphaneler and you'll see the speed.
Thanks. Mengu
On 12-10-2015 13:10, Gaetan Boisson wrote:
Oh wow... Those are really impressive figures! Is it just one huge Koha install, or does every single library has its own Koha? If it is just one Koha, i guess you had to make specific patches? (I imagine having hundreds of libraries defined in the branches could be a problem at some places in the interface...)
It's great to see Koha being put to such use anyway! Is there a public opac we can see?
Best regards,
Le 11/10/2015 21:15, Mengu Yazicioglu a écrit :
I'd like to share that we serve more than 13.200.000 records (adding more than 20.000 items per day) to 1.126 public libraries consoritum with 1.000.000 users (adding more than 2.000 new users everyday),
I think it is biggest Koha installation around the world, We use Mariadb on clustered servers and we are very comfortable with the performance. Of course, our technical staff trace the servers and databased everyday.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Bob Birchall Director Calyx Group Pty Limited Mob: 0414 796 988 Email: bob@calyx.net.au Web: www.calyx.net.au This email and any attachments are proprietary and confidential and are intended solely for the use of the individual to whom it is addressed. If you have received this email in error, please let us know immediately by reply email and delete it from your system. You may not use, disseminate, distribute or copy this message nor disclose its contents to anyone. Calyx Group Pty Limited – P.O. Box 6041 North Sydney NSW 2059 – ABN 25 083 195 804 Participating in the Koha Open ILS project: http://koha-community.org
That will be better Bob and I'd like to give some more information on that project. Project went live on 2014 April. All public libraries were using another LIS before and it was distributed. With that project, all libraries started to use a central Koha system located on Ankara, capital of Turkey. It was a derived version of Koha 2.x (co called TG distribution) but we implemented many new modules on it. Therefore we can say a quite derived version of Koha 2.x. Because of distributed system data were very dirty, there were hundreds of biblios of a single book. Hence we wrote two modules to handle them and we merged more than 4.000.000 biblios with the better one, automatically. There is a Catalog Center for public libraries now, and they also merge dirty biblios with the better one. They also create original biblios. This will yield the biggest Turkish catalog center. For the moment, we try to migrate to newest version 3.20.x and tests started on that. I think it will go live in 2-3 months. We will also implement all modules to the new version that we originally developed (There are many, some are related with local solutions). Maybe, it will be nice to talk about infrastructure. There is one Load balancer, 4 web servers, 4 clustered databases (MariaDB), 1 specific server for ID cards, barcodes, labels. We do not only implement and serve to Koha project, we also manage those servers' databases, web servers, performance issues, etc. I'd like to share some interested statistics, too. More than 6.000.000 books circulated in 18 months, there is a record of more than 30.000 circulation for a single day. In average, 2.000 borrowers are being added to system each day but we saw app. 4.500 new borrowers last Saturday. Koha is everywhere in Turkey with that project, even in some small villages. Ministry of Culture has some trucks with books and they travel around the Turkey and circulate books. If you have any other question I will be happy to share. I'm planning to join next Koha Conf, and if I would have a chance I want to share this project with all of you. Thanks. Mengü On 13-10-2015 01:36, Bob Birchall wrote:
Changing the name of this interesting thread, so it can be found in the archives. :) Bob
On 13/10/15 01:13, Mengu Yazicioglu wrote:
Hi,
It's in only one Koha installation for all public libraries, and we've done many implementations for them, and hopefully we do not face with any problems. There are some small issues but we can handle them.
koha.ekutuphane.gov.tr is public OPAC, but in Turkish unfortunately,
you may search some specific letter for example "a" for Tum Kutuphaneler and you'll see the speed.
Thanks. Mengu
On 12-10-2015 13:10, Gaetan Boisson wrote:
Oh wow... Those are really impressive figures! Is it just one huge Koha install, or does every single library has its own Koha? If it is just one Koha, i guess you had to make specific patches? (I imagine having hundreds of libraries defined in the branches could be a problem at some places in the interface...)
It's great to see Koha being put to such use anyway! Is there a public opac we can see?
Best regards,
Le 11/10/2015 21:15, Mengu Yazicioglu a écrit :
I'd like to share that we serve more than 13.200.000 records (adding more than 20.000 items per day) to 1.126 public libraries consoritum with 1.000.000 users (adding more than 2.000 new users everyday),
I think it is biggest Koha installation around the world, We use Mariadb on clustered servers and we are very comfortable with the performance. Of course, our technical staff trace the servers and databased everyday.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- /Saygılarımla/ /Mengü YAZICIOĞLU/ /MERKEZ Adres : Mustafa Kemal Mah. Seferoğlu Plaza 2141.Sk No:11/6 ÇANKAYA/ANKARA Telefon : +90 - 312 - 219 84 30 Cep : +90 - 532 - 701 90 27 e-posta : mengu@devinim.com.tr /
Thanks a lot for the details. I am pretty sure a lot of people will be interested in your talk at the next Kohacon! All the best for your move to 3.20, that sounds like a great project too! Le 13/10/2015 08:56, Mengu Yazicioglu a écrit :
That will be better Bob and I'd like to give some more information on that project.
Project went live on 2014 April. All public libraries were using another LIS before and it was distributed. With that project, all libraries started to use a central Koha system located on Ankara, capital of Turkey.
It was a derived version of Koha 2.x (co called TG distribution) but we implemented many new modules on it. Therefore we can say a quite derived version of Koha 2.x. Because of distributed system data were very dirty, there were hundreds of biblios of a single book. Hence we wrote two modules to handle them and we merged more than 4.000.000 biblios with the better one, automatically. There is a Catalog Center for public libraries now, and they also merge dirty biblios with the better one. They also create original biblios. This will yield the biggest Turkish catalog center.
For the moment, we try to migrate to newest version 3.20.x and tests started on that. I think it will go live in 2-3 months. We will also implement all modules to the new version that we originally developed (There are many, some are related with local solutions).
Maybe, it will be nice to talk about infrastructure. There is one Load balancer, 4 web servers, 4 clustered databases (MariaDB), 1 specific server for ID cards, barcodes, labels. We do not only implement and serve to Koha project, we also manage those servers' databases, web servers, performance issues, etc.
I'd like to share some interested statistics, too.
More than 6.000.000 books circulated in 18 months, there is a record of more than 30.000 circulation for a single day. In average, 2.000 borrowers are being added to system each day but we saw app. 4.500 new borrowers last Saturday.
Koha is everywhere in Turkey with that project, even in some small villages. Ministry of Culture has some trucks with books and they travel around the Turkey and circulate books.
If you have any other question I will be happy to share. I'm planning to join next Koha Conf, and if I would have a chance I want to share this project with all of you.
Thanks. Mengü
On 13-10-2015 01:36, Bob Birchall wrote:
Changing the name of this interesting thread, so it can be found in the archives. :) Bob
On 13/10/15 01:13, Mengu Yazicioglu wrote:
Hi,
It's in only one Koha installation for all public libraries, and we've done many implementations for them, and hopefully we do not face with any problems. There are some small issues but we can handle them.
koha.ekutuphane.gov.tr is public OPAC, but in Turkish unfortunately,
you may search some specific letter for example "a" for Tum Kutuphaneler and you'll see the speed.
Thanks. Mengu
On 12-10-2015 13:10, Gaetan Boisson wrote:
Oh wow... Those are really impressive figures! Is it just one huge Koha install, or does every single library has its own Koha? If it is just one Koha, i guess you had to make specific patches? (I imagine having hundreds of libraries defined in the branches could be a problem at some places in the interface...)
It's great to see Koha being put to such use anyway! Is there a public opac we can see?
Best regards,
Le 11/10/2015 21:15, Mengu Yazicioglu a écrit :
I'd like to share that we serve more than 13.200.000 records (adding more than 20.000 items per day) to 1.126 public libraries consoritum with 1.000.000 users (adding more than 2.000 new users everyday),
I think it is biggest Koha installation around the world, We use Mariadb on clustered servers and we are very comfortable with the performance. Of course, our technical staff trace the servers and databased everyday.
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Gaetan Boisson Chef de projet bibliothécaire BibLibre 06 52 42 51 29 108 avenue Breteuil 13006 Marseille gaetan.boisson@biblibre.com
Hi, Am 11.10.2015 um 21:15 schrieb Mengu Yazicioglu:
I think it is biggest Koha installation around the world, We use Mariadb on clustered servers and we are very comfortable with the performance. Of course, our technical staff trace the servers and databased everyday.
sounds awesome! Would you mind sharing some more details about your server setup? Cheers, Mirko
participants (8)
-
Arayik Manukyan -
Bob Birchall -
Carlos Rodrigo Cordova Sandoval -
Gaetan Boisson -
Jesse -
Katrin Fischer -
Mengu Yazicioglu -
Mirko Tietgen