Closed Bug 982309 Opened 11 years ago Closed 11 years ago

Set Bugzilla slaves to MIXED mode replication

Categories

(Data & BI Services Team :: DB: MySQL, task)

Product:
Data & BI Services Team
Component:
DB: MySQL
Platform:
x86
macOS
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: bjohnson, Unassigned)

Details

In order to reduce the volume and load of the binary logs for the bugzilla systems, we would like to turn on MIXED mode replication instead of the current STATEMENT. This means that MySQL will decide when it's better to use a statement or send only the delta of a change, which will reduce network traffic and disk IO for replication. This is to be applied on slaves now, and on the master during the downtime for bug 982293.
For phx bugzilla servers, Committed revision 85175.
Sheeri-Cabral:nodes scabral$ svn commit -m "adding flush_log_at_trx_commit, MIXED binlog mode, and fdatasync flush_method to bugzilla in scl3" Sending databases.pp Transmitting file data . Committed revision 85236. This is a dynamic variable, so I have set it on the slaves (bugzilla2-6 in scl3, phx was done yesterday and the master.
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.