|
Main -> News -> Virtual DBVirtual DB module as DB conn mixerWhy a virtual db module?Until now all modules requiring db support had only one (real) db_url connection and it was bad if that connection went down. Here is where virtual db module comes in: The real connections are handled transparently to the module using the virtual url. Now if the current real connection goes down the virtual db_url will just switch to a new one transparently to the module, giving uninterrupted db access. The virtual url could just as well use all the real connections at the same time . Ex: when an insert operation takes place it will insert in all the real dbs. Yet another mode would be to use the real dbs in a round-robin fashion maybe for load-balancing. This could be used to spread queries, inserts across multiple db servers. Find more at : http://www.opensips.org/html/docs/modules/devel/db_virtual.html#id226415 What if i don't want the module to use a real db at runtime?There is MI support to get the state information for all real dbs (per virtual url). The module also provides a MI function to set the state(enabled/disabled) for each real db (per virtual url). See: http://www.opensips.org/html/docs/modules/devel/db_virtual.html#id228157 What happens when a connection fails?If a real connection fails it will be marked globally and closed. The module that uses it will not spent time trying to reconnect and will not block waiting for timeout. A separate timer process will probe the real url. If is succeeds connecting, the connection will be marked globally and considered for reconnection by each process that uses it. See: http://www.opensips.org/html/docs/modules/devel/db_virtual.html#id227167 So, the virtual db module provides means to:
| News OpenSIPS LiveDVD04th of August 2010
OpenSIPS Virtual Machine is now available ... OpenSIPS 1.6.302nd of August 2010
OpenSIPS 1.6.3 major release gets better... OpenSIPS @ ClueCon29th of July 2010
OpenSIPS 2.0 @ ClueCon 2010. OpenSIPS eBootcamp12th of July 2010
Remote OpenSIPS learning with Ebootcamp program. OpenSIPS @ Amoocon 20104th of May 2010
OpenSIPS had 2 papers at Amoocon 2010. SIMPLE Aggregation14th of April 2010
Presence and BLF state aggregation. OpenSIPS Certified Professional13th of April 2010
OpenSIPS certification program launched. OpenSIPS webinar30th of March 2010
Next webinars is Variables in OpenSIPS scripting OpenSIPS 1.6.211th of March 2010
OpenSIPS 1.6.2 is brings new features... OpenSIPS Control Panel 4.008th of March 2010
OpenSIPS CP 4.0 comes with user provisioning... Conference on "OpenSIPS 2.0"5th of March 2010
VoIP Users Conference will host an audio conference OpenSIPS webinar25th of February 2010
Next webinars is Explaining the default script OpenSIPS 2.0 Design15th of February 2010
Design of OpenSIPS 2.0 is unveiled OpenSIPS webinar28th of January 2010
Next OpenSIPS webinars is SIP Introduction Building Telephony Systems with OpenSIPS 1.621st of January 2010
New edition is available... OpenSIPS 1.6.1 is released21st of December 2009
OpenSIPS 1.6.1 minor release is out... OpenSIPS Development Course17th of December 2009
OpenSIPS Devel Course for 2010... OpenSIPS Bootcamps 201009th of December 2009
2010 Schedule for Bootcamp events... User Location is faster13th of November 2009
USRLOC is 3 time faster than before... OpenSIPS Control Panel 3.030th of October 2009
OpenSIPS CP 3.0 major release is out... OpenSIPS 1.6.0 is released16th of October 2009
OpenSIPS 1.6.0 major release is out... OpenSIPS VoIP Service21th of September 2009
OpenSIPS project offers free VoIP services... OpenSIPS & Astricon21th of September 2009
OpenSIPS talks and exhibits at Astricon 2009... SVN freeze17th of September 2009
SVN trunk gets frozen to prepare 1.6 release... New types of script routes10th of September 2009
New additions to configuration file routes... STUN server7th of September 2009
OpenSIPS has now a built-in STUN server... Pseudovariable implementation extended3rd of September 2009
Added new operations for pvars to give more power to the script writer... OpenSIPS Asterisk Integration30th of August 2009
Tutorial for realtime integration... OpenSIPS 1.5.3 is released27th of August 2009
OpenSIPS 1.5.3 minor release is out... AAA and RADIUS support18th of April 2009
New AAA API and RADIUS enhancements in OpenSIPS OpenSIPS webinar4th of April 2009
Next OpenSIPS webinars is Types of Routs in OpenSIPS B2BUA3rd of August 2009
A B2BUA signaling implementation in OpenSIPS DB virtual23th of July 2009
A DB conn mixer for failover, parallel and LB Codec manipulation23th of July 2009
SDP codecs and priorities manipulation Memcached interfacing16th of July 2009
memcached support for memory caching API OpenSIPS 1.5.2 is released15th of July 2009
OpenSIPS 1.5.2 minor release is out... OpenSIPS@ClueCon14th of July 2009
OpenSIPS talks at ClueCon OpenSIPS webinar30th of June 2009
Next OpenSIPS webinars is Routing in SIP REGISTRAR enhancements29th of June 2009
REGISTRAR module becomes more flexible OpenSIPS free webinars01st of June 2009
OpenSIPS webinars program was launched OpenSIPS-CP 2.0 is released13rd of April 2009
OpenSIPS Control Panel 2.0 major release is out... OpenSIPS 1.5.1 is released13rd of April 2009
OpenSIPS 1.5.1 minor release is out... OpenSIPS 1.5.0 is released23rd of March 2009
OpenSIPS 1.5.0 major release is out... OpenSIPS 1.4.5 is released23rd of March 2009
OpenSIPS 1.4.5 minor release is out... OpenSIPS as Load Balancer4th of March 2009 OpenSIPS at Amoocon (AsteriskTAG)24th of February 2009 |