MySQL Duplication

Author Message

Yvan ROY

Monday 20 March 2006 10:56:54 am

Hello,

We need to set up two servers for a portal. MySQL has a duplication feature between databases (I'm not an administrator). I would like to know how to set up such a database duplication? To make it easier, only one of the server would be used at a time the other one is a failover server.

Thank you,

Yvan

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

Main resources:

Total runtime0.0223 sec
Peak memory usage2,048.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0085 588.0078151.1953
Module start 'layout' 0.00850.0039 739.203136.6172
Module start 'content' 0.01240.0081 775.820384.8906
Module end 'content' 0.02050.0018 860.710929.9922
Script end 0.0223  890.7031 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002410.6489140.0002
Check MTime0.00114.9803140.0001
Mysql Total
Database connection0.00093.821410.0009
Mysqli_queries0.006328.399630.0021
Looping result0.00000.102410.0000
Template Total0.00125.310.0012
Template load0.00104.323010.0010
Template processing0.00020.958310.0002
Override
Cache load0.00062.886610.0006
General
dbfile0.00219.586180.0003
String conversion0.00000.054440.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