<!-- keep this as a security measure: * Set ALLOWTOPICCHANGE = Main.TWikiAdminGroup,Main.LCGAdminGroup * Set ALLOWTOPICRENAME = Main.TWikiAdminGroup,Main.LCGAdminGroup #uncomment this if you want the page only be viewable by the internal people #* Set ALLOWTOPICVIEW = Main.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 * Master master replication http://www.hbyconsultancy.com/blog/create-a-master-master-mysql-replication-ubuntu-server-10-04-x64.html * Semisynchronous replication http://dev.mysql.com/doc/refman/5.6/en/replication-semisync-installation.html -- Main.GeorgeBrown - 2013-08-12
This topic: LCGTier2
>
WebHome
>
ToolsBoard
>
FormsAndTemplates
>
MySQLReplication
Topic revision: r1 - 2013-08-12 - GeorgeBrown
Copyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki?
Send feedback