Board Optimization - datastore cache to XCache - boost your vBulletin

中文用户讨论@vbulletin-china.cn

(note: do not apply this patch on vBulletin 3.7 as it's included already)
This patch allow you to use XCache as a datastore cache in vBulletin. This is definitely your choice if you have installed and enabled XCache on you server already.

Take care that this is a beta version and was not heavily tested. And i'm not familiar with vBulletin source code as i just started reading it today, but i don't have any difficulty reading it thanks to my years of php skill

Take aware that some vB plugin is not compatible with vB_datastore_*, not just vB_datastore_XCache. So, in case you find vB_datastore_XCache won't work, you'd better try datastore to file or memcache. If one of the others works but not vB_datastore_XCache, do report it to me so i can fix it.

Pre-requirement

• a working php installtion
• a working vBulletin 3.6.5 installtion
• a working XCache installtion
• set "xcache.var_size = 10M" or so in php ini

Install the modification
for those of you who can't run "patch", u may patch the file manually

• download Attachment 61372 (class_datastore_xcache.php)
• save the file as vBulletin.3.6/upload/includes/class_datastore_xcache.php
• open vBulletin.3.6/upload/includes/class_datastore.php in your favor editor
• add a line in class_datastore.php (see below)
• update upload/includes/config.php to enable it (see below)

example class_datastore.php after modification:

PHP Code:

        }
        return true;
    }
}

// add class_datastore_xcache, enable it in config.php
require_once(DIR . '/includes/class_datastore_xcache.php');

/*======================================================================*\
|| ####################################################################
|| # Downloaded: 12:33, Fri Mar 2nd 2007
|| # CVS: $RCSfile$ - $Revision: 15474 $
|| ####################################################################
\*======================================================================*/ 


example config.php after modification:

PHP Code:


    // vB_Datastore_Filecache  - for using a cache file
// $config['Datastore']['class'] = 'vB_Datastore_Filecache';
$config['Datastore']['class'] = 'vB_Datastore_XCache';
    // vB_Datastore_Memcached - for using a Memcache server
    // It is also necessary to specify the hostname or IP address and the port the server is listening on 


Trouble Shooting
q. i have multiple vBulletin instance installed, the seems to mix data after install this plugin
a. this applies to apc too because, if you wanna fix it, try
open class_core.php, look for:
$this->prefix =& $this->registry->config['Datastore']['prefix'];
and modify to:
$this->prefix = $this->registry->config['Datastore']['prefix'] . $_SERVER['SERVER_NAME']; // or HTTP_HOST

q. Warning: unserialize() expects parameter 1 to be string, array given in $a.php on line $b
a. upgrade your plugin/hack that $a.php belongs to, e.g. vbjournal/vbgallery etc. OR open $a.php and locate at line $b, remove unserialize call, e.g.:
replace $var = unserialize($this->data);
with $var = $this->data;
be careful do not remove the whole line, just the unseralize( and )

[Masala4india]

i m also getting this error
Fatal error: Class vb_datastore_xcache: Cannot inherit from undefined class vb_datastore in /home/forum/public_html/includes/class_datastore_xcache.php on line 14

i checked the answer of phpxcache regarding this error but unable to do. Please guide me.

[foulplay]

Anybody get this mod working okay? Sounds like a brilliant idea!

[Zia]

its working on our site without any single issue...

b4 using it..u must have xcache installed

[Atakan KOC]

Fatal error: XCache variable data cache is not enabled, please set xcache.var_size in php.ini in /includes/class_datastore_xcache.php on line 39

[Snider]

Originally Posted by Atakan KOC

Fatal error: XCache variable data cache is not enabled, please set xcache.var_size in php.ini in /includes/class_datastore_xcache.php on line 39

Read the post !!

[gabrielt]

I prefer installing memcached (for datastore) then use XCache for the rest of the php files. From my tests, this combination improves the VB performance by over 250%. Expecially if you use 2 servers or more for your site.

I am running memcached here. Can I use both or they are mutual exclusive? Anyone made performance tests comparing the two?

Thanks
Gabriel.

[eva2000]

haven't used memcached but just installed xcache/datastore hack on one of my forums.. made a tremendous difference to the speed

excellent stuff !

anyone have any ideas how this would work with load balanced multi web server setup ? guess memcached would work better for load balanced servers ?

[gabrielt]

anyone have any ideas how this would work with load balanced multi web server setup ? guess memcached would work better for load balanced servers ?

I use memcached on my setup, I have two webservers and I installed memcached on my MySQL server, so the memcached on MySQL server caches for both webservers.

Gabriel.

[phpxcache]

Originally Posted by gabrielt

I am running memcached here. Can I use both or they are mutual exclusive? Anyone made performance tests comparing the two?

Thanks
Gabriel.

you can use XCache as opcode cacher, while using xcache OR memcached as vBulletin datastore cache.

[Yellow Slider]

Originally Posted by phpxcache

you can use XCache as opcode cacher, while using xcache OR memcached as vBulletin datastore cache.

Can you explain how?, I'll installed the Xcache hack, and It will Cache the php files?, can someone explain what do you mean by "datastore"?

how can I work with memcache and Xcache to get the most out of the two of them?
memcache will cache the DB ( how exactly ? ) there is another hack?
and the Xcache will cache the php time? and the php process time will be faster?