DBI and the shadowdb

[Myk Melez]

Bradley Baetz wrote:

>>Btw- Are there any plans to make it possible to install a read-only 
>>installation of Bugzilla that directs all write requests to another 
>>installation.  This, along with replication, would provide an quick and 
>>easy scalability solution (just add more boxes).
>>
>>    
>>
>
>Well, we could use DBD::multiplex. The problem is the definition of 'write 
>request', esp with consistent data, and so on.
>
I'm thinking of a simpler solution: a parameter designating the urlbase 
of the master installation.  If non-empty, Bugzilla includes it in the 
"action" attribute of all forms whose submission results in a database 
write.  Then users could choose (or have chosen for them via 
round-robin) a server to use for querying and retrieving bugs, and 
writes still go through a single master installation.  This approach 
also avoids the need to open up MySQL on the master machine to other 
machines.

-myk