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

Re: MYSQL database slave support [message #165203 is a reply to message #165201]

Tue, 10 May 2011 03:02

naudefj

Messages: 3771
Registered: December 2004

Karma:

Senior Member
Administrator
Core Developer

How about sending all queres during POST requests to the master? That will allow us to remove most of these hints. For example, in db.inc:

-	/* Connect to slave, if specified. */
-	if (!empty($GLOBALS['DBHOST_SLAVE_HOST'])) {
+	/* Connect to slave, if specified and not a POST request. */
+	if (!empty($GLOBALS['DBHOST_SLAVE_HOST']) && !$GLOBALS['is_post']) {

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: Sun May 12 04:51:32 GMT 2024

Total time taken to generate the page: 0.03860 seconds