FUDforum: Database discussions » MYSQL database slave support

Home » General » Database discussions » MYSQL database slave support (Patch included) (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator

MYSQL database slave support [message #164998]

Wed, 13 April 2011 16:35

eclipsewebmaster

Messages: 46
Registered: November 2009
Location: Ottawa, Ontario, Canada

Karma:

Member

I'm preparing to move fudforum onto our database cluster, but it currently lacks slave support.

Attached is a rough patch (Against 3.0.2) that seems to cover the most of it. I tie into FUD_OPT_4 for Use Slave Yes/no. The slave algorithm essentially sends all SELECT queries to the slave, except a) if SELECT /* USE MASTER */ is specified in the query, or b) if db_locked() since that assumes a transaction is taking place.

It would be nice to query the slave to see if it's lagged, but for Bugzilla I typically do that with a shell script and it works quite well, so I'll likely do the same here.

Note: I have not tested this with mysqli.

Attachment: patch.txt
(Size: 6.90KB, Downloaded 1600 times)

Report message to a moderator

[Message index]

		MYSQL database slave support By: eclipsewebmaster on Wed, 13 April 2011 16:35
		Re: MYSQL database slave support By: naudefj on Thu, 14 April 2011 16:35
		Re: MYSQL database slave support By: eclipsewebmaster on Fri, 15 April 2011 11:15
		Re: MYSQL database slave support By: naudefj on Fri, 22 April 2011 05:57
		Re: MYSQL database slave support By: eclipsewebmaster on Mon, 09 May 2011 12:26
		Re: MYSQL database slave support By: naudefj on Mon, 09 May 2011 12:57
		Re: MYSQL database slave support By: eclipsewebmaster on Mon, 09 May 2011 15:45
		Re: MYSQL database slave support By: naudefj on Tue, 10 May 2011 03:02
		Re: MYSQL database slave support By: eclipsewebmaster on Tue, 10 May 2011 10:59
		Re: MYSQL database slave support By: naudefj on Tue, 10 May 2011 16:14
		Re: MYSQL database slave support By: naudefj on Thu, 12 May 2011 10:31
		Re: MYSQL database slave support By: eclipsewebmaster on Fri, 13 May 2011 11:48
		Re: MYSQL database slave support By: eclipsewebmaster on Mon, 16 May 2011 10:05
		Re: MYSQL database slave support By: Ernesto on Tue, 17 May 2011 03:05
		Re: MYSQL database slave support By: naudefj on Tue, 17 May 2011 04:45
		Re: MYSQL database slave support By: naudefj on Tue, 19 July 2011 07:31
		Re: MYSQL database slave support By: eclipsewebmaster on Sat, 23 July 2011 08:49
		Re: MYSQL database slave support By: ew on Mon, 13 May 2013 17:44
		Re: MYSQL database slave support By: naudefj on Mon, 13 May 2013 17:47
		Re: MYSQL database slave support By: naudefj on Sat, 27 July 2013 09:23

Previous Topic:	Insert html content as a value into mysql database?
Next Topic:	mssql 2012

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 18:28:10 GMT 2024

Total time taken to generate the page: 0.03655 seconds