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

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 31 2025 07:31:18
Script start
Timing:	Jan 31 2025 07:31:18
Module start 'layout'
Timing:	Jan 31 2025 07:31:18
Module start 'content'
Timing:	Jan 31 2025 07:31:18
Module end 'content'
Timing:	Jan 31 2025 07:31:18
Script end

Main resources:

Total runtime	0.0161 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0067	588.2578	151.2266
Module start 'layout'	0.0067	0.0016	739.4844	36.6797
Module start 'content'	0.0084	0.0064	776.1641	90.1875
Module end 'content'	0.0148	0.0013	866.3516	33.9922
Script end	0.0161		900.3438

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0024	14.7318	14	0.0002
Check MTime	0.0010	6.2863	14	0.0001
Mysql Total
Database connection	0.0011	6.5483	1	0.0011
Mysqli_queries	0.0022	13.8217	3	0.0007
Looping result	0.0000	0.0548	1	0.0000
Template Total	0.0010	6.4	1	0.0010
Template load	0.0007	4.6496	1	0.0007
Template processing	0.0003	1.6752	1	0.0003
Override
Cache load	0.0005	3.3015	1	0.0005
General
dbfile	0.0027	16.7444	8	0.0003
String conversion	0.0000	0.0548	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs