DRBD - Revision history

Leo: Text replacement - "Category:Linux{{Navbox Linux}}" to "{{Navbox Linux}}Category:Linux"

2019-09-01T06:22:07Z

Text replacement - "Category:Linux{{Navbox Linux}}" to "{{Navbox Linux}}Category:Linux"

← Older revision		Revision as of 06:22, 1 September 2019
Line 301:		Line 301:


	[[Category:Linux]]~~{{Navbox Linux}}~~		{{Navbox Linux}}[[Category:Linux]]
	[[Category:LinuxUtilities]]		[[Category:LinuxUtilities]]

Leo: Text replacement - "{{Navbox Linux}}{{Navbox Linux}}" to "{{Navbox Linux}}"

2019-09-01T05:11:15Z

Text replacement - "{{Navbox Linux}}{{Navbox Linux}}" to "{{Navbox Linux}}"

← Older revision		Revision as of 05:11, 1 September 2019
Line 301:		Line 301:


	[[Category:Linux]]~~{{Navbox Linux}}~~{{Navbox Linux}}		[[Category:Linux]]{{Navbox Linux}}
	[[Category:LinuxUtilities]]		[[Category:LinuxUtilities]]

Leo: Text replacement - "Category:Linux" to "Category:Linux{{Navbox Linux}}"

2019-09-01T05:07:33Z

Text replacement - "Category:Linux" to "Category:Linux{{Navbox Linux}}"

← Older revision		Revision as of 05:07, 1 September 2019
Line 301:		Line 301:


	[[Category:Linux]]{{Navbox Linux}}		[[Category:Linux]]{{Navbox Linux}}{{Navbox Linux}}
	[[Category:LinuxUtilities]]		[[Category:LinuxUtilities]]

Leo: Text replacement - "Category:Linux " to "Category:Linux{{Navbox Linux}} "

2019-09-01T03:44:59Z

Text replacement - "Category:Linux " to "Category:Linux{{Navbox Linux}} "

← Older revision		Revision as of 03:44, 1 September 2019
Line 301:		Line 301:


	[[Category:Linux]]		[[Category:Linux]]{{Navbox Linux}}
	[[Category:LinuxUtilities]]		[[Category:LinuxUtilities]]

Leo at 03:25, 1 September 2019

2019-09-01T03:25:35Z

Show changes

Leo: Text replacement - "" to "}}"

2017-02-24T19:14:11Z

Text replacement - "</code>" to "}}"

← Older revision		Revision as of 19:14, 24 February 2017
Line 9:		Line 9:
	yum install drbd84-utils kmod-drbd84		yum install drbd84-utils kmod-drbd84

	You should be able to load the {{code\|drbd~~</code>~~ module:		You should be able to load the {{code\|drbd}} module:
	# modprobe drbd		# modprobe drbd
	# lsmod\|grep drbd		# lsmod\|grep drbd
Line 26:		Line 26:
	make install		make install

	The {{code\|make install~~</code>~~ should have loaded the module and you can verify this:		The {{code\|make install}} should have loaded the module and you can verify this:
	lsmod \| grep drbd		lsmod \| grep drbd

Line 65:		Line 65:
	echo "/dev/drbd0 /mnt/drbd ext4 noauto 0 0 " >> /etc/fstab		echo "/dev/drbd0 /mnt/drbd ext4 noauto 0 0 " >> /etc/fstab

	On all nodes, configure the DRBD config in {{code\|/etc/drbd.d/*conf~~</code>~~. You may want to disable the survey.		On all nodes, configure the DRBD config in {{code\|/etc/drbd.d/*conf}}. You may want to disable the survey.

	On all nodes, configure DRBD by creating a file in {{code\|/etc/drbd.d/mysql.res~~</code>~~ with:		On all nodes, configure DRBD by creating a file in {{code\|/etc/drbd.d/mysql.res}} with:
	<syntaxhighlight lang="text">		<syntaxhighlight lang="text">
	resource mysql {		resource mysql {
Line 96:		Line 96:
	drbdadm -v create-md mysql		drbdadm -v create-md mysql

	If it complains about finding a filesystem, zero out the first few blocks using {{code\|dd~~</code>~~ and try again or ignore and continue.		If it complains about finding a filesystem, zero out the first few blocks using {{code\|dd}} and try again or ignore and continue.

	On all nodes, start the resource:		On all nodes, start the resource:
Line 232:		Line 232:
	drbdadm secondary mysql		drbdadm secondary mysql

	The node which that is to have its data discarded will then need connect with the {{code\|--discard-my-data~~</code>~~ option:		The node which that is to have its data discarded will then need connect with the {{code\|--discard-my-data}} option:
	drbdadm connect --discard-my-data mysql		drbdadm connect --discard-my-data mysql

Leo: Text replacement - "`" to "{{code|"`


2017-02-24T19:12:36Z
Text replacement - "<code>" to "{{code|"

				
				
				
				
				
				← Older revision
				Revision as of 19:12, 24 February 2017
				
Line 9:
Line 9:
  yum install drbd84-utils kmod-drbd84   yum install drbd84-utils kmod-drbd84



You should be able to load the <code>drbd</code> module: You should be able to load the {{code|drbd</code> module:
  # modprobe drbd   # modprobe drbd
  # lsmod|grep drbd   # lsmod|grep drbd
Line 26:
Line 26:
  make install   make install



The <code>make install</code> should have loaded the module and you can verify this: The {{code|make install</code> should have loaded the module and you can verify this:
  lsmod | grep drbd   lsmod | grep drbd



Line 65:
Line 65:
  echo "/dev/drbd0 /mnt/drbd ext4 noauto 0 0 " >>  /etc/fstab   echo "/dev/drbd0 /mnt/drbd ext4 noauto 0 0 " >>  /etc/fstab



On all nodes, configure the DRBD config in <code>/etc/drbd.d/*conf</code>. You may want to disable the survey. On all nodes, configure the DRBD config in {{code|/etc/drbd.d/*conf</code>. You may want to disable the survey.



On all nodes, configure DRBD by creating a file in <code>/etc/drbd.d/mysql.res</code> with: On all nodes, configure DRBD by creating a file in {{code|/etc/drbd.d/mysql.res</code> with:
<syntaxhighlight lang="text"> <syntaxhighlight lang="text">
resource mysql { resource mysql {
Line 96:
Line 96:
  drbdadm -v create-md mysql   drbdadm -v create-md mysql



If it complains about finding a filesystem, zero out the first few blocks using <code>dd</code> and try again or ignore and continue. If it complains about finding a filesystem, zero out the first few blocks using {{code|dd</code> and try again or ignore and continue.



On all nodes, start the resource: On all nodes, start the resource:
Line 232:
Line 232:
  drbdadm secondary mysql   drbdadm secondary mysql



The node which that is to have its data discarded will then need connect with the <code>--discard-my-data</code> option: The node which that is to have its data discarded will then need connect with the {{code|--discard-my-data</code> option:
  drbdadm connect --discard-my-data mysql   drbdadm connect --discard-my-data mysql



Leo: /* Other Commands */
2015-04-13T22:23:11Z
Other Commands

				
				
				
				
				
				← Older revision
				Revision as of 22:23, 13 April 2015
				
Line 217:
Line 217:
  drbdadm role mysql   drbdadm role mysql




== Split Brain ==

The two nodes will either be in the WFConnection or StandAlone state:
 [root@os-c1 mnt]# drbd-overview 
  0:mysql/0  StandAlone Secondary/Unknown UpToDate/DUnknown 
 
 [root@os-c2 mnt]# drbd-overview 
  0:mysql/0  StandAlone Primary/Unknown UpToDate/DUnknown 

Make both nodes in the StandAlone state by disconnecting the resource if it is in the WFConnection state.

Set the two nodes to secondary
 drbdadm secondary mysql

The node which that is to have its data discarded will then need connect with the <code>--discard-my-data</code> option:
 drbdadm connect --discard-my-data mysql

The node that is to have its data preserved should just connect:
 drbdadm connect mysql

Both nodes should not be in the StandAlone state and should at this point be connected and syncing.











Leo: /* Setting up MySQL */
2015-04-13T20:42:53Z
Setting up MySQL

				
				
				
				
				
				← Older revision
				Revision as of 20:42, 13 April 2015
				
Line 131:
Line 131:
Initialize the database: Initialize the database:
  mysql_install_db     mysql_install_db  

Optionally, set the bind address in <code>my.cnf</code> to the shared cluster IP address. It should default to 0.0.0.0 if you don't do this which is also fine. 
 bind-address = 172.20.10.8 






== Corosync / CRM ==



You'll need crmsh if you want to follow some other guides. Install it using the You'll need crmsh if you want to follow some other guides. Install it using the
Line 145:
Line 143:
  yum install *.rpm   yum install *.rpm
       
Configure the cluster so we have a an IP address set, MySQL running, and the DRBD volume mounted.






  crm configure   crm configure
 
  primitive p_ip_mysql ocf:heartbeat:IPaddr2 \   primitive p_ip_mysql ocf:heartbeat:IPaddr2 \
    params ip="172.20.10.8" cidr_netmask="24" \     params ip="172.20.10.8" cidr_netmask="24" \
Line 185:
Line 183:






We'll need to configure STONITH.

You can see all the available STONITH devices using:
 stonith_admin -I

You can use any of the listed devices as part of your configuration. (Added after stonith:_________)

 crm configure
  property stonith-enabled=true
  property stonith-action=poweroff
  rsc_defaults resource-stickiness=100
  property no-quorum-policy=ignore
  
  primitive vm-fence-c1 stonith:fence_vmware_soap \
   params ipaddr="172.17.12.8" login="root" passwd="xxx" \
     port="OpenStack C1" ssl="1" retry_on="20" shell_timeout="10" \
     login_timeout="10" action="off" verbose="true"
  
  primitive vm-fence-c2 stonith:fence_vmware_soap \
   params ipaddr="172.20.1.27" login="root" passwd="xxx" \
     port="OpenStack C2" ssl="1" retry_on="20" shell_timeout="10" \
     login_timeout="10" action="off" verbose="true"
 
  location l-vm-c1 vm-fence-c1 -inf: os-c1
  location l-vm-c2 vm-fence-c2 -inf: os-c2
 commit



== Other Commands == == Other Commands ==





Leo at 19:05, 13 April 2015
2015-04-13T19:05:47Z


				
				
				
				
				
				← Older revision
				Revision as of 19:05, 13 April 2015
				
Line 115:
Line 115:
You can now mount the device on the primary node: You can now mount the device on the primary node:
  mount /dev/drbd0 /mnt/drbd   mount /dev/drbd0 /mnt/drbd

At this stage, you should be seeing the two volumes beginning to sync:
 # drbd-overview
  0:mysql/0  SyncSource Primary/Secondary UpToDate/Inconsistent /mnt/drbd xfs 35G 34M 35G 1% 
 	[=>..................] sync'ed: 14.4% (30480/35580)M




== Setting up MySQL== == Setting up MySQL==

← Older revision		Revision as of 19:12, 24 February 2017
Line 9:		Line 9:
	yum install drbd84-utils kmod-drbd84		yum install drbd84-utils kmod-drbd84

	You should be able to load the <code>drbd</code> module:		You should be able to load the {{code\|drbd</code> module:
	# modprobe drbd		# modprobe drbd
	# lsmod\|grep drbd		# lsmod\|grep drbd
Line 26:		Line 26:
	make install		make install

	The <code>make install</code> should have loaded the module and you can verify this:		The {{code\|make install</code> should have loaded the module and you can verify this:
	lsmod \| grep drbd		lsmod \| grep drbd

Line 65:		Line 65:
	echo "/dev/drbd0 /mnt/drbd ext4 noauto 0 0 " >> /etc/fstab		echo "/dev/drbd0 /mnt/drbd ext4 noauto 0 0 " >> /etc/fstab

	On all nodes, configure the DRBD config in <code>/etc/drbd.d/*conf</code>. You may want to disable the survey.		On all nodes, configure the DRBD config in {{code\|/etc/drbd.d/*conf</code>. You may want to disable the survey.

	On all nodes, configure DRBD by creating a file in <code>/etc/drbd.d/mysql.res</code> with:		On all nodes, configure DRBD by creating a file in {{code\|/etc/drbd.d/mysql.res</code> with:
	<syntaxhighlight lang="text">		<syntaxhighlight lang="text">
	resource mysql {		resource mysql {
Line 96:		Line 96:
	drbdadm -v create-md mysql		drbdadm -v create-md mysql

	If it complains about finding a filesystem, zero out the first few blocks using <code>dd</code> and try again or ignore and continue.		If it complains about finding a filesystem, zero out the first few blocks using {{code\|dd</code> and try again or ignore and continue.

	On all nodes, start the resource:		On all nodes, start the resource:
Line 232:		Line 232:
	drbdadm secondary mysql		drbdadm secondary mysql

	The node which that is to have its data discarded will then need connect with the <code>--discard-my-data</code> option:		The node which that is to have its data discarded will then need connect with the {{code\|--discard-my-data</code> option:
	drbdadm connect --discard-my-data mysql		drbdadm connect --discard-my-data mysql

← Older revision		Revision as of 22:23, 13 April 2015
Line 217:		Line 217:
	drbdadm role mysql		drbdadm role mysql


			== Split Brain ==

			The two nodes will either be in the WFConnection or StandAlone state:
			[root@os-c1 mnt]# drbd-overview
			0:mysql/0 StandAlone Secondary/Unknown UpToDate/DUnknown

			[root@os-c2 mnt]# drbd-overview
			0:mysql/0 StandAlone Primary/Unknown UpToDate/DUnknown

			Make both nodes in the StandAlone state by disconnecting the resource if it is in the WFConnection state.

			Set the two nodes to secondary
			drbdadm secondary mysql

			The node which that is to have its data discarded will then need connect with the <code>--discard-my-data</code> option:
			drbdadm connect --discard-my-data mysql

			The node that is to have its data preserved should just connect:
			drbdadm connect mysql

			Both nodes should not be in the StandAlone state and should at this point be connected and syncing.

← Older revision		Revision as of 19:05, 13 April 2015
Line 115:		Line 115:
	You can now mount the device on the primary node:		You can now mount the device on the primary node:
	mount /dev/drbd0 /mnt/drbd		mount /dev/drbd0 /mnt/drbd

			At this stage, you should be seeing the two volumes beginning to sync:
			# drbd-overview
			0:mysql/0 SyncSource Primary/Secondary UpToDate/Inconsistent /mnt/drbd xfs 35G 34M 35G 1%
			[=>..................] sync'ed: 14.4% (30480/35580)M


	== Setting up MySQL==		== Setting up MySQL==

DRBD - Revision history

Leo: Text replacement - "Category:Linux{{Navbox Linux}}" to "{{Navbox Linux}}Category:Linux"

Leo: Text replacement - "{{Navbox Linux}}{{Navbox Linux}}" to "{{Navbox Linux}}"

Leo: Text replacement - "Category:Linux" to "Category:Linux{{Navbox Linux}}"

Leo: Text replacement - "Category:Linux " to "Category:Linux{{Navbox Linux}} "

Leo at 03:25, 1 September 2019

Leo: Text replacement - "" to "}}"

Leo: Text replacement - "" to "{{code|"

Leo: /* Other Commands */

Leo: /* Setting up MySQL */

Leo at 19:05, 13 April 2015

Leo: Text replacement - "`" to "{{code|"`