Forums / Install & configuration / MySQL-Replication and ViewCaching

MySQL-Replication and ViewCaching

« 
Previous topic
|
Install & configuration
|
Next topic
 »
Author Message

Mark Kruse

Tuesday 08 March 2005 12:33:27 am

Hi!

We have two server with eZ publish and MySQL (Linux + Apache) installed.
One Server is the Editor-System with the MasterDatabase and the other server is for the surfers. This one has a slave database, which is replicated from the master.

We want to use ViewCaching with this configuration.

Does anyone have experience with this?
When new objects are published, how can we achieve, that the corresponding cachefiles on the slave-server are deleted?
Or can we replicate the cachefiles from the master to the slave?

It would be great, if anyone could help us out.

Mark

Gabriel Ambuehl

Tuesday 08 March 2005 12:49:26 am

As long as you don't change templates or upload files, everything that changes should reside in the DB and get replicated automatically. If you do either, you need to copy them over manually. I'd suggest looking into rsync as it's perfect for that use.

Visit http://triligon.org

liu spider

Monday 04 April 2005 10:55:08 am

I'd like to setup a mirror for one ezpublish site, could you share your experience of howto setup and sync the slave database? thanks

http://liucougar.scim-im.org
SCIM Input Method Platform
http://scim.sf.net
SJSD Online Editor
http://sf.net/projects/sjsd

Gabriel Ambuehl

Monday 04 April 2005 11:01:16 am

That's documented very well in the MySQL docs.

Visit http://triligon.org

eZ debug

Timing: Jan 18 2025 21:12:49
Script start
Timing: Jan 18 2025 21:12:49
Module start 'content'
Timing: Jan 18 2025 21:12:49
Module end 'content'
Timing: Jan 18 2025 21:12:50
Script end

Main resources:

Total runtime0.1627 sec
Peak memory usage4,096.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0076 587.8359180.8203
Module start 'content' 0.00760.0057 768.656393.9297
Module end 'content' 0.01330.1494 862.5859522.8281
Script end 0.1626  1,385.4141 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00402.4887200.0002
Check MTime0.00150.9156200.0001
Mysql Total
Database connection0.00100.592910.0010
Mysqli_queries0.118072.50791410.0008
Looping result0.00120.75731390.0000
Template Total0.149191.610.1491
Template load0.00090.545810.0009
Template processing0.148291.061910.1482
Override
Cache load0.00060.397010.0006
Sytem overhead
Fetch class attribute can translate value0.00110.698710.0011
XML
Image XML parsing0.00030.164110.0003
General
dbfile0.00372.2983200.0002
String conversion0.00000.003830.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/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