That's a good note about MySQL replication. You can use it to remove point-of-failure which currently is your DB server.
Regards/Pagarbiai, Mindaugas Kezys http://www.kolmisoft.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Collier Sent: Thursday, August 23, 2007 12:21 AM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: Re: [asterisk-users] Multiple servers using realtime I use a centralized database (with replication) for several servers, and it works very well. I keep all the mysql traffic on a separate network from the SIP traffic. It makes it easy to add capacity. If you are doing all the mySQL on one box anyway, I don?t see any adavantage to using separate databases. -----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Peder @ NetworkOblivion Enviado el: miercoles, 22 de agosto de 2007 19:06 Para: Asterisk Users Mailing List - Non-Commercial Discussion Asunto: [asterisk-users] Multiple servers using realtime I am in the process of setting up several * servers using realtime and connecting to mysql. I am trying to figure out if I should just use one database and one set of tables for all of the user data. Or if I should have separate databases for each * box. The boxes are independent of each other in that customerA only connects to box A. They will never fail over to box B or anything like that. I want to use realtime for queues,voicemail, sippeers and extensions. The only issue that I have come up with so far is that a common voicemail table would cause each box to try and send out mwi indicators since it appears each * box pulls all of the voicemail boxes from the DB every 10 seconds. Any thoughts on whether I should go with one DB, or separate per box DB's? There is one mysql box, I am not referring to mysql on each box, I am referring to whether I should use separate DB's within the one mysql box for each * box. Thanks. Peder _______________________________________________ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
