Hi Folks, Since our network on h323 is keep growing, with the possibility of getting faster in evaluating, I would need a solution for billing which can help to keep track. As far as I read on the mailing list, SQLBill is limited to few hundreds of calls per second, which is far less than future can bring in voip. I like it and use it without problems since a quite a while, but as I told, I, and I think not only, need more (this speaking for the case that it can become known not only for billing system related to gnugk but to RADIUS in general). One of the solutions I am thinking about, is scaling the SQLBill by master-slave relationship. To be more specific, two or tree instances of SQLBill-slaves could work directly with same number of FreeRadius servers, on the same or different machines. The difference from the actual usage could be that the Master instance would only take care about putting together all the cdrs and holding accounts. So when the call will hit any of the slave instances,this will activate a trigger which will force the slave to connect to master and get the account information. After this, the rest of the process should be independent of the master till the call end point, when another trigger will determine the slave to update the account and cdrs - already calculated information, and completely delete from the slave (or temporary keep) this records. The pricelist could be kept on the slaves to avoid additional usage of the master, and maybe replicated into all of the slaves at once, when needed. Please notice that I am just sharing here my thoughts, since I am not an experimented database programmer, and I would choose this solution for the case that the hardware can take more than the postgresql process can do, due to the triggers and complicated (at least for me :)) methods inside a live billing solution. If anyone has any other solution, please don't hesitate to share it with me, since I need one. Cheers, Dan __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________________ Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users Homepage: http://www.gnugk.org/
