Hello,
I'm looking for the best practises for setting Kamailio and the associated hardware requirements.
Kamailio must deliver registrar and routing functions for 500k aliases, 5k registered accounts and ~10k routes set in carrierroute module or similar.
My worries mainly concern DB integration. Is it better to setup Kamailio DB on the same server (no network issue, etc.) or on another server?
Your opinion/feedback experience would be appreciated. Thanks!
Regards,
Igor.
--- Ce courrier électronique ne contient aucun virus ou logiciel malveillant parce que la protection avast! Antivirus est active. http://www.avast.com
Am Mittwoch, 30. Oktober 2013, 12:28:16 schrieb Igor Potjevlesch:
I'm looking for the best practises for setting Kamailio and the associated hardware requirements.
Kamailio must deliver registrar and routing functions for 500k aliases, 5k registered accounts and ~10k routes set in carrierroute module or similar. My worries mainly concern DB integration. Is it better to setup Kamailio DB on the same server (no network issue, etc.) or on another server?
Hi Igor,
in my experience using a local (read-only) replicate of the kamailio database for authentification and other read-only functionality brings the best performance, as its eliminates the network overhead. For read-write functionality one like to have a central database server, and I would recommend this as well for better performance.
I would recommend that you do some tests with a testing tool, and then decide if you want to go for a local replicate or a dedicated DB is fine. With regards to special hardware recommendations - I my experience any recent 1 HE "enterprise line" server (from Dell, HP, IBM etc..) should be fine.
Best regards,
Henning Westerholt
Hi Henning,
Great suggestion! Do you have a configuration example with 2 MySQL connections? Also, for modules params, how can we define a MySQL links RO and another RW?
Regards,
Igor.
-----Message d'origine----- De : Henning Westerholt [mailto:hw@kamailio.org] Envoyé : mercredi 30 octobre 2013 12:37 À : sr-users@lists.sip-router.org Cc : Igor Potjevlesch Objet : Re: [SR-Users] Hardware requirements/recommandations
Am Mittwoch, 30. Oktober 2013, 12:28:16 schrieb Igor Potjevlesch:
I'm looking for the best practises for setting Kamailio and the associated hardware requirements.
Kamailio must deliver registrar and routing functions for 500k aliases, 5k registered accounts and ~10k routes set in carrierroute module
or similar.
My worries mainly concern DB integration. Is it better to setup Kamailio DB on the same server (no network issue, etc.) or on another
server?
Hi Igor,
in my experience using a local (read-only) replicate of the kamailio database for authentification and other read-only functionality brings the best performance, as its eliminates the network overhead. For read-write functionality one like to have a central database server, and I would recommend this as well for better performance.
I would recommend that you do some tests with a testing tool, and then decide if you want to go for a local replicate or a dedicated DB is fine. With regards to special hardware recommendations - I my experience any recent 1 HE "enterprise line" server (from Dell, HP, IBM etc..) should be fine.
Best regards,
Henning Westerholt
--- Ce courrier électronique ne contient aucun virus ou logiciel malveillant parce que la protection avast! Antivirus est active. http://www.avast.com
Am Mittwoch, 30. Oktober 2013, 14:35:06 schrieb Igor Potjevlesch:
[using a read-only slave and a dedicated read-write DB]
Great suggestion! Do you have a configuration example with 2 MySQL connections? Also, for modules params, how can we define a MySQL links RO and another RW?
Hi Igor,
well, you just need to point the appropriate modules database URL in the cfg file to the appropriate destination. E.g. auth module to the local slave, usrloc module to the dedicated master etc..
Regards,
Henning
Hi Henning,
Oh ok. I was thinking that, for example, usrloc can be connected to "DBURL_RO" for read-only actions and "DBURL_RW" for read-write actions.
Regards,
Igor.
-----Message d'origine----- De : Henning Westerholt [mailto:hw@kamailio.org] Envoyé : mercredi 30 octobre 2013 14:38 À : Igor Potjevlesch Cc : sr-users@lists.sip-router.org Objet : Re: [SR-Users] Hardware requirements/recommandations
Am Mittwoch, 30. Oktober 2013, 14:35:06 schrieb Igor Potjevlesch:
[using a read-only slave and a dedicated read-write DB]
Great suggestion! Do you have a configuration example with 2 MySQL connections? Also, for modules params, how can we define a MySQL links RO and another RW?
Hi Igor,
well, you just need to point the appropriate modules database URL in the cfg file to the appropriate destination. E.g. auth module to the local slave, usrloc module to the dedicated master etc..
Regards,
Henning
--- Ce courrier électronique ne contient aucun virus ou logiciel malveillant parce que la protection avast! Antivirus est active. http://www.avast.com
Am Mittwoch, 30. Oktober 2013, 16:34:41 schrieb Igor Potjevlesch:
Oh ok. I was thinking that, for example, usrloc can be connected to "DBURL_RO" for read-only actions and "DBURL_RW" for read-write actions.
Hi Igor,
the p_usrloc module supports this functionality, and you can also configure different connections with the db_cluster module, i think.
Regards,
Henning Westerholt
Hi Henning,
Nice features but they look to be more complex than the schema that you proposed. Kamailio is not impacted by MySQL replication traffic which generate writes on his disk?
Regards,
Igor.
-----Message d'origine----- De : Henning Westerholt [mailto:hw@kamailio.org] Envoyé : mercredi 30 octobre 2013 16:37 À : Igor Potjevlesch Cc : sr-users@lists.sip-router.org Objet : Re: [SR-Users] Hardware requirements/recommandations
Am Mittwoch, 30. Oktober 2013, 16:34:41 schrieb Igor Potjevlesch:
Oh ok. I was thinking that, for example, usrloc can be connected to "DBURL_RO" for read-only actions and "DBURL_RW" for read-write actions.
Hi Igor,
the p_usrloc module supports this functionality, and you can also configure different connections with the db_cluster module, i think.
Regards,
Henning Westerholt
--- Ce courrier électronique ne contient aucun virus ou logiciel malveillant parce que la protection avast! Antivirus est active. http://www.avast.com
Am Mittwoch, 30. Oktober 2013, 17:06:56 schrieb Igor Potjevlesch:
Nice features but they look to be more complex than the schema that you proposed. Kamailio is not impacted by MySQL replication traffic which generate writes on his disk?
Hi Igor,
no, normally you've enough CPU cores that one for the mysql replication job should be available. And normally you don't replicate several mbit/s to the disk in a configured environment.
Henning
-----Message d'origine----- De : Henning Westerholt [mailto:hw@kamailio.org] Envoyé : mercredi 30 octobre 2013 16:37 À : Igor Potjevlesch Cc : sr-users@lists.sip-router.org Objet : Re: [SR-Users] Hardware requirements/recommandations
Am Mittwoch, 30. Oktober 2013, 16:34:41 schrieb Igor Potjevlesch:
Oh ok. I was thinking that, for example, usrloc can be connected to "DBURL_RO" for read-only actions and "DBURL_RW" for read-write actions.
Hi Igor,
the p_usrloc module supports this functionality, and you can also configure different connections with the db_cluster module, i think.
Regards,
Henning Westerholt
Ce courrier électronique ne contient aucun virus ou logiciel malveillant parce que la protection avast! Antivirus est active. http://www.avast.com
-
Henning Westerholt -
Igor Potjevlesch