433341 - Move database load from master to slaves

Status: RESOLVED FIXED

(support.mozilla.org :: General, defect)

Description

[Laura Thomson :laura]

This means adding this functionality to Tiki.  It seems like it should go into the database layer.

(I was sure we already had a bug for this: please dupe this if it already exists.)

Comment 1

[Mike Beltzner [:beltzner, not reading bugmail]]

This blocks a release blocker - what's our ETA?

Comment 3

[Laura Thomson :laura]

Nearly done - aiming to get the patch into review tomorrow.

Comment 4

[Laura Thomson :laura]

Attachment: Basic master-slave support for tikiwiki

To test this, you'll need a shadowdb, and to add the following lines to your db/local.php e.g.
$shadow_host ='[host]';
$shadow_user='[username]';
$shadow_pass='[password]';
$shadow_dbs='[database_name]';

Comment 5

[Michael Morgan [:morgamic]]

Comment on attachment 323776 [details] [diff] [review]
Basic master-slave support for tikiwiki

This works on khan - would like to see some tests instead of the echo/debug statements, but let's get this checked in and up in staging so we can test it.

Comment 6

[Michael Morgan [:morgamic]]

Comment on attachment 323776 [details] [diff] [review]
Basic master-slave support for tikiwiki

Also, make sure that when we deploy this we make people aware of the config change.  Laura - that is up to you.

Comment 7

[Laura Thomson :laura]

Fixed in r15181.  We will load test and test on stage next.

Comment 8

[Louis-Philippe Huberdeau]

The database layer was almost entirely rewritten as part of making PDO optional. Direct upstreaming did not make sense. As a result, a different implementation was made. However, it should behave in a very similar way and be compatible.

Tiki commit r22653 and installer updates in r22654.

How do I flag tiki_upstreamed?

Comment 9

[David Tenser [:djst]]

(In reply to comment #8)
> How do I flag tiki_upstreamed?

Simply add the string to the Whiteboard field (I just did it for this bug). Thanks!

Comment 10

[Stephen Donner [:stephend] Not actively reading bugmail]

[e-mail] didn't have "editbugs" in Bugzilla; he now does.

Comment 11

[David Tenser [:djst]]

Thanks Stephen!