Enterprise Advanced Configuration

(1)

Enterprise Advanced Configuration

Winfried de Vries

(2)

TT

THE FAST TRACK TO ONLINE

Enterprise Advanced Configuration

Performance Hardware set-up Issues Security Trouble-shooting woensdag 13 mei 2009

(3)

TT

Enterprise System Components

Database FileStore Application Server Clients: InDesign, InCopy, Content Station etc.

(4)

TT

Enterprise System Components

Database

FileStore

Application

Server

Clients: InDesign,

InCopy, Content

Station etc.

Memory++

woensdag 13 mei 2009

(5)

TT

Enterprise System Components

Database

Application

Server

Memory++

Disk IO++

(6)

TT

Enterprise System Components

Database

FileStore

Application

Server

Clients: InDesign,

InCopy, Content

Station etc.

Memory++

Disk IO++

(7)

TT

Enterprise System Components

Database FileStore Application Server Clients: InDesign, InCopy, Content Station etc.

(8)

TT

Performance Issues

How is your system performing

(9)

TT

Performance Issues

(10)

TT

Performance Issues

or

(11)

TT

Performance Issues

(12)

TT

Why can there be performace issues?

(13)

TT

Why can there be performace issues?

Woodwing has got no control over the setup of the components

(14)

TT

Why can there be performace issues?

Because the hardware, OS and database choices are a partner/customer decision.

(15)

TT

Why can there be performace issues?

Because the hardware, OS and database choices are a partner/customer decision. Customizations and interfaces that are not optimized.

(16)

TT

Measuring performace, how?

(17)

TT

Measuring performace, how?

specify the ʻscopeʼ of the measurement:

(18)

TT

Measuring performace, how?

limit the scope to what can be measured accurately.

create a reproducible scenario and prerequisites.

Make a copy of the used files for future comparisons.

(19)

TT

Measuring performace, how?

limit the scope to what can be measured accurately.

create a reproducible scenario and prerequisites.

Make a copy of the used files for future comparisons.

Test on a ʻcleanʼ system:

(20)

TT

keep in mind that writing down logfiles has got influence on performance.

look ʻtop-downʼ, first total time, then start narrowing down. User functions Enterprise commands, Database actions, Data transfer, Client Performance

Measuring performace

(21)

TT

Performance logging

Switch on debugging on server

Configserver.php

For performance logging, use INFO For functional debugging, use DEBUG

// ---// Debugging - Low-level logging of SQL, SOAP details etc.

// ---define ('DEBUGLEVEL', 'INFO'); // NONE, ERROR, WARN, INFO, DEBUG

define ('OUTPUTDIRECTORY', '/log/'); // including '/', e.g. "c:/enterpriselog/output/" define ('PROFILELEVEL', 1); // [0,5] 0: no profiling, 5: most detailed

(22)

TT

Performance logging

Set profilelevel to 5 to get maximum server info

peformanceProfiler.dat sce_profile_mysq.htm

(23)

TT

Database performance pitfall

Table scans, caused by:

Queries on columns that have no index Mostly in interfaces and customizations

Use database monitoring tools:

(24)

TT

Security

(25)

TT

(26)

TT

Why security?

Information abuse

(27)

TT

Why security?

Information abuse

(28)

TT

Why security?

Information abuse

Production disturbance User mistakes

(29)

TT

Why security?

Information abuse

Production disturbance User mistakes

(30)

TT

Secure Enterprise installation

(31)

TT

Secure Enterprise installation

(32)

TT

Secure Enterprise installation

Change password of default WoodWing user SSL (HTTPS)

(33)

TT

Secure Enterprise installation

(34)

TT

Secure Enterprise installation

Separate database user for woodwing File access (config.php, directories, ...)

(35)

TT

(36)

TT

Secure Enterprise set-up

Full / Limited Administrators

(37)

TT

Secure Enterprise set-up

Full / Limited Administrators Workflow

(38)

TT

Secure Enterprise set-up

Password rules

(39)

TT

Secure Enterprise set-up

Password rules

(40)

TT

Secure Enterprise set-up

Password rules

config/configserver.php Customize with a plug-in

(41)

TT

Enterprise backup

Standard version control

Settings in config/configserver.php Workflow Status property

Trash Can

(42)

TT

Troubleshooting

(43)

TT

(44)

TT

Troubleshooting in Enterprise

Why:

To get detailed information about a problem in the system.

(45)

TT

Troubleshooting in Enterprise

Why:

To get detailed information about a problem in the system.

With as goal:

To solve the problem yourself !

(46)

TT

Approach

(47)

TT

Approach

(48)

TT

Approach

Make sure the issue is reproducible:

Write down/collect prerequisites (if any). • upload attached image ʻproblem1.jpgʻ to Enterprise

(49)

TT

Approach

Write down/collect prerequisites (if any). • upload attached image ʻproblem1.jpgʻ to Enterprise Write a scenario.

(50)

TT

Approach

1. from InDesign, logon as user ʻxxxʼ on server ʻmyserverʼ

(51)

TT

Approach

1. from InDesign, logon as user ʻxxxʼ on server ʻmyserverʼ 2. create a layout and save-version with name ʻlayout1ʼ

(52)

TT

Approach

1. from InDesign, logon as user ʻxxxʼ on server ʻmyserverʼ 2. create a layout and save-version with name ʻlayout1ʼ 3. place uploaded image with name ʻproblem1.jpgʼ

on layout ʻlayout1ʼ

(53)

TT

Approach

1. from InDesign, logon as user ʻxxxʼ on server ʻmyserverʼ 2. create a layout and save-version with name ʻlayout1ʼ 3. place uploaded image with name ʻproblem1.jpgʼ

on layout ʻlayout1ʼ

(54)

TT

Test on a clean system

To create a clean system:

Remove or switch of all non-standard server plugins. test without any other users, or :

−create a separate Application Server with debug on, using the same database and filestore

−create a complete copy of the system as test system.

Application Server Application Server Production Debug woensdag 13 mei 2009

(55)

TT

Is the scenario still valid?

Replay the scenario on the clean system.

Is the issue still there?

No? -> Switch on customizations one-by-one until problem appears again.

(56)

TT

Switch on logging

Server side:

configserver.php

Client side

wwsettings.xml

<SCEnt:LogFile RequestBuffer ="Macintosh HD:ClientLog:" ResponseBuffer="Macintosh HD:ClientLog:" SOAPResponse ="Macintosh HD:ClientLog:" SOAPRequest ="Macintosh HD:ClientLog:" Advanced ="true"/>

Text // ---// Debugging - Low-level logging of SQL, SOAP details etc.

// ---define ('DEBUGLEVEL', 'DEBUG'); // NONE, ERROR, WARN, INFO, DEBUG

define ('OUTPUTDIRECTORY', '/log/'); // including '/', e.g. "c:/enterpriselog/output/" define ('PROFILELEVEL', 1); // [0,5] 0: no profiling, 5: most detailed

define ('LOGSQL', false); // log the SQL, requires DEBUGLEVEL DEBUG or INFO

(57)

TT

(58)

TT