mahara-contributors team mailing list archive

[Hugh Davenport <1039773@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Basically allow a master connection, which is used for writes, and
multiple slave connections, used for reads. These databases should be
synced to each other (hot standby replication)

We can determine which is read/write two ways, adding an extra parameter to execute_sql, and choose based on that,
or see what sql commands are passed in, if it is a write one, then send to master, otherwise pick a slave.

** Affects: mahara
     Importance: Wishlist
         Status: Triaged

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/1039773

Title:
  add support for multiple databases

Status in Mahara ePortfolio:
  Triaged

Bug description:
  Basically allow a master connection, which is used for writes, and
  multiple slave connections, used for reads. These databases should be
  synced to each other (hot standby replication)

  We can determine which is read/write two ways, adding an extra parameter to execute_sql, and choose based on that,
  or see what sql commands are passed in, if it is a write one, then send to master, otherwise pick a slave.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1039773/+subscriptions