Difference: MySQLReplication (1 vs. 13)

Revision 132013-09-05 - GeorgeBrown

Line: 1 to 1
 
META TOPICPARENT name="FormsAndTemplates"

Revision 122013-09-04 - GeorgeBrown

Line: 1 to 1
 
META TOPICPARENT name="FormsAndTemplates"

Revision 112013-09-04 - GeorgeBrown

Line: 1 to 1
 
META TOPICPARENT name="FormsAndTemplates"

Revision 102013-09-04 - GeorgeBrown

Line: 1 to 1
 
META TOPICPARENT name="FormsAndTemplates"

Revision 92013-08-20 - GeorgeBrown

Line: 1 to 1
 
META TOPICPARENT name="FormsAndTemplates"

Revision 82013-08-20 - GeorgeBrown

Line: 1 to 1
 
META TOPICPARENT name="FormsAndTemplates"

Revision 72013-08-19 - GeorgeBrown

Line: 1 to 1
 
META TOPICPARENT name="FormsAndTemplates"

Revision 62013-08-19 - GeorgeBrown

Line: 1 to 1
 
META TOPICPARENT name="FormsAndTemplates"

Revision 52013-08-19 - GeorgeBrown

Line: 1 to 1
 
META TOPICPARENT name="FormsAndTemplates"

Revision 42013-08-19 - GeorgeBrown

Line: 1 to 1
 
META TOPICPARENT name="FormsAndTemplates"

Revision 32013-08-13 - GeorgeBrown

Line: 1 to 1
 
META TOPICPARENT name="FormsAndTemplates"

Revision 22013-08-13 - GeorgeBrown

Line: 1 to 1
 
META TOPICPARENT name="FormsAndTemplates"

Revision 12013-08-12 - GeorgeBrown

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="FormsAndTemplates"
<-- keep this as a security measure: 
  • Set ALLOWTOPICCHANGE = TWikiAdminGroup,Main.LCGAdminGroup
  • Set ALLOWTOPICRENAME = TWikiAdminGroup,Main.LCGAdminGroup #uncomment this if you want the page only be viewable by the internal people #* Set ALLOWTOPICVIEW = TWikiAdminGroup,Main.LCGAdminGroup
-->

MySQL replication

Usage

  • slurm1 and slurm2 make use of master master semisynchronous replication

Requirements

Semisynchronous replication requires MySQL 5.5 or newer. SL6 ships with MySQL 5.1.x as such you will have do download the newer RPMs from the MySQL website.

These RPMs have been copied to the Phoenix repo and are available through yum. Note you will have to first install MySQL-shared-compat package as otherwise you will receive an error about conflicts.

Setup

  • slurm1 and slurm2 are both masters
    • Both can be written to can changes will be replicated to the other node.

  • slurm1 and slurm2 are both semisynchronous masters and slaves
    • When a transaction is performed on either node the change is replicated before returning (timeout for this is 10 seconds).

TBA: Visual diagram

Config

TBA

Testing

TBA

Monitoring

TBA

Further reading

-- GeorgeBrown - 2013-08-12

 
This site is powered by the TWiki collaboration platform Powered by Perl This site is powered by the TWiki collaboration platformCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback