Load balancing and UseSlaveServer=true

Next topic

Author	Message
Tony Wood	Monday 28 April 2003 4:51:08 am Hi, I am testing the slave server setup with two machines a master and slave. The servers are running mySQL 4 with replication Master->Slave working correctly. Can you please let me know how eZ decides to use the slave server? Does it default to the slave or master if DNS match? Does it test speed of connection and choose fastest? Does it open two connections? Some guidelines on usage please. tia tony Tony Wood : twitter.com/tonywood Vision with Technology Experts in eZ Publish consulting & development Power to the Editor! Free eZ Training : http://www.VisionWT.com/training eZ Future Podcast : http://www.VisionWT.com/eZ-Future
Bård Farstad	Monday 28 April 2003 7:22:30 am You need to configure the slave server in site.ini ( an override for your system ). The slave servers are used on read queries only. Write queries are sent to the main database server. If more than one slave server is used in the setup eZ publish will just choose a random slave. The algorithm is as follows: if ( $numberServers > 1 ) { $index = rand( 1, $numberServers ) - 1; } else $index = 0; Pretty simple, for now. Yes, eZ publish will open one read and one write connection on the slave server. On the master the same connection will be used. --bård Documentation: http://ez.no/doc
Tony Wood	Monday 28 April 2003 7:53:31 am Thanks for explanation i understand how it can be used correctly now and have tested it here and it works. If it all pans out well it will go into the production environment. Could the db server used by eZ could be added to the debug output, so you could see the read server and the write server used. I look forward to seeing how the loadbalancing develops. tony Tony Wood : twitter.com/tonywood Vision with Technology Experts in eZ Publish consulting & development Power to the Editor! Free eZ Training : http://www.VisionWT.com/training eZ Future Podcast : http://www.VisionWT.com/eZ-Future
Gabriel Ambuehl	Monday 28 April 2003 8:15:12 am I'd be quite interested to hear something about the frontend/backend you're using there. At what point do I need to think about boosting DB performance as opposed to adding more power for the frontend webservers? Visit http://triligon.org
Tony Wood	Monday 28 April 2003 8:21:32 am We have a failover solution in place so i have access to two databases the slave and the master. I am looking to see if i can speed up the DB access by using the slave environments. We are looking at getting speed from everywhere, the main area to hit is PHP but every second counts so we are looking at the backend too. Tony Wood : twitter.com/tonywood Vision with Technology Experts in eZ Publish consulting & development Power to the Editor! Free eZ Training : http://www.VisionWT.com/training eZ Future Podcast : http://www.VisionWT.com/eZ-Future
Gabriel Ambuehl	Monday 28 April 2003 10:19:01 am That's what my benchmarks said as well. MySQL took maybe 3% CPU, PHP all the rest... Visit http://triligon.org

eZ debug

Timing:	Jan 18 2025 19:31:21
Script start
Timing:	Jan 18 2025 19:31:21
Module start 'layout'
Timing:	Jan 18 2025 19:31:21
Module start 'content'
Timing:	Jan 18 2025 19:31:22
Module end 'content'
Timing:	Jan 18 2025 19:31:22
Script end

Main resources:

Total runtime	0.6514 sec
Peak memory usage	4,096.0000 KB
Database Queries	68

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0063	588.0391	152.6406
Module start 'layout'	0.0063	0.0041	740.6797	39.4922
Module start 'content'	0.0103	0.6399	780.1719	616.1328
Module end 'content'	0.6502	0.0012	1,396.3047	16.1406
Script end	0.6514		1,412.4453

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0040	0.6126	16	0.0002
Check MTime	0.0014	0.2080	16	0.0001
Mysql Total
Database connection	0.0008	0.1274	1	0.0008
Mysqli_queries	0.5921	90.8844	68	0.0087
Looping result	0.0006	0.0942	66	0.0000
Template Total	0.6198	95.1	2	0.3099
Template load	0.0020	0.3046	2	0.0010
Template processing	0.6178	94.8406	2	0.3089
Template load and register function	0.0001	0.0173	1	0.0001
states
state_id_array	0.0013	0.1991	1	0.0013
state_identifier_array	0.0014	0.2092	2	0.0007
Override
Cache load	0.0017	0.2633	38	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0007	0.1124	3	0.0002
Fetch class attribute name	0.0011	0.1632	8	0.0001
XML
Image XML parsing	0.0011	0.1710	3	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0030	10	0.0000
General
dbfile	0.0020	0.3050	23	0.0001
String conversion	0.0000	0.0013	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
4	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
6	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
8	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 22 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs