Proposal for "DB_Virtual"

» Metadata » Status
  • Category: Database
  • Proposer: Joe Stump 
  • License: PHP v3.0
  • Status: Proposed
» Description
DB_Virtual allows you to set up a single master and N nodes to balance traffic across multiple DB servers. Compatible with PEAR DB's API. It sends 100% of all manipulation queries to the master node and then uses weighted round robin scheduling to balance queries across all of the nodes.
» Dependencies » Links
  • PHP 5.0.0+
  • DB 1.7.6
  • PEAR 1.4.0b1+
» Timeline » Changelog
  • First Draft: 2006-02-25
  • Proposal: 2006-02-25
  • Joe Stump
    [2006-02-27 03:55 UTC]

    Added package source file per request from comments.
  • Joe Stump
    [2006-03-03 17:57 UTC]

    Updated to the latest version of the package (0.0.7). Updated the package source file as well. Changes include:

    * Fixed a bug in DB_Virtual::autoCommit() that wasn't passing $onoff to the master's autoCommit()
    * Added DB_Virtual::queryMaster() so you can send queries directly to the master
    * Fixed a bug with last_query and getOne(), getAll(), etc.
    * Fixed a possible divide by zero error
    * Added check for weights less than zero