Cluster Cache Question

Author Message

Felipe Jaramillo

Friday 28 September 2007 9:17:17 am

Hello all,

We are studying using cluster solutions in some sites. The documentation page (http://ez.no/doc/ez_publish/technical_manual/3_9/features/clustering) says:

"Data that must be synchronized between the different servers is stored using the database:

* Binary files
* Image and image alias files
* Caches related to content:
o Content view cache
o Template block cache
o Expiry cache
o URL alias cache
o RSS cache
o User info cache
o Class identifier cache
o Sort key cache

Other files are stored using the filesystem, including (but not limited to):

* INI files
* Template files
* Compiled templates
* PHP files
* Log files
* Caches that are not related to content:
o Global INI cache
o INI cache
o Codepage cache
o Character transformation cache
o Template cache
o Template override cache

My question is about how these files, especially INI Files are shared or syncronized among the cluster nodes.

Does a normal cluster setup require an rsync of these files? Wouldn't it be better to store everything on the DB?

Thanks in advance! "

Regards,

Felipe

Felipe Jaramillo
eZ Certified Extension Developer
http://www.aplyca.com | Bogotá, Colombia

Xavier Dutoit

Friday 28 September 2007 9:42:48 am

Hi,


[DatabaseSettings]
DatabaseImplementation=ezmysql
Server=localhost
User=itwillbe
Password=quitedifficultto
Database=retrievefromthedb

;)

What do you have against rsync ?

http://www.sydesy.com

Felipe Jaramillo

Friday 28 September 2007 9:19:39 pm

Xavier,

Good point, it was hilarious!

This is the story: one of our clients datacenter security department decided they would not let any traffic from port 80 change any files in the filesystem, after having security problems with other web solutions.

It is pretty obvious what one would think of a security policy like this, but for now we are forced to take the time to consider how this could be achieved.

All cache that can expire or be cleared, should eventually be able to generate itself into the DB through normal traffic in port 80, while the admin area runs in a more relaxed port 8080.

The way we're doing this is to use a cluster configuration on a single server, but need to be able to persist things like INI cache, template cache and probably compiled template cache too.

Regards,

Felipe

Felipe Jaramillo
eZ Certified Extension Developer
http://www.aplyca.com | Bogotá, Colombia

André R.

Saturday 29 September 2007 3:39:51 am

Be aware of higher mysql load with the cluster setup.
Thats one reason why not everything is in db, it wouldn't make sense.

Also be aware that the cluster soulution is higly improved in 3.10, but only works in mysql now.
So since 3.10 is about to be finalised you might want to use 3.10 or 4.0 ( the php5 version) from the beginning.

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 30 2025 22:27:16
Script start
Timing: Jan 30 2025 22:27:16
Module start 'layout'
Timing: Jan 30 2025 22:27:16
Module start 'content'
Timing: Jan 30 2025 22:27:16
Module end 'content'
Timing: Jan 30 2025 22:27:16
Script end

Main resources:

Total runtime0.0254 sec
Peak memory usage6,144.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0051 588.0234151.1953
Module start 'layout' 0.00520.0037 739.2188220.6563
Module start 'content' 0.00890.0148 959.87501,001.8672
Module end 'content' 0.02370.0016 1,961.742233.9922
Script end 0.0253  1,995.7344 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002610.3479140.0002
Check MTime0.00104.0527140.0001
Mysql Total
Database connection0.00062.415310.0006
Mysqli_queries0.00239.071230.0008
Looping result0.00000.043210.0000
Template Total0.00114.210.0011
Template load0.00083.113310.0008
Template processing0.00031.099110.0003
Override
Cache load0.00051.939010.0005
General
dbfile0.00103.810380.0001
String conversion0.00000.031040.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs