dcsimg

How do I upgrade to a distributed architecture?

Products

Webtrends Analytics 8.x
Webtrends Analytics 9.x

Cause

The analysis environment has grown, and it is necessary to take the single Webtrends machine and add additional machines to handle more reporting, or additional features, by upgrading to a distributed architecture. This includes moving the storage folder to a different machine.

Resolution

To upgrade to a distributed installation, perform the following steps:

1. Cancel all currently running scheduled tasks.

2.Stop all Webtrends services-some may not be installed:
Webtrends – Scheduler Agent
Webtrends – User Interface
Webtrends – UI Web Services
Webtrends – Data Retention Service
Webtrends – Report Cache Server
Webtrends – Express Data Mover
Webtrends – Express Analysis Engine
Webtrends – GeoTrends
Webtrends – Email Notification Service
Webtrends – System Monitor
Webtrends – MySQL
SQL Server(MSSQLSERVER)
SQL Server VSS Writer


3. Back up the storage folder and system database:

\Webtrends\storage
\Webtrends\common\database\mysql\data\wtmaster
\Webtrends\common\database\mysql\data\wt_sched

To back up an MS SQL database for 8.5 and above, refer to KB092905.

4. Apply permissions for the Webtrends service account (KB article 052070).

5. Share the storage folder to the network, so that the Webtrends services account can access it and ensure the proper security and permissions are in place (KB article 072596).

6. Restart the Webtrends services in opposite order.

7. Log into the Webtrends user interface and navigate to Administration/Application Settings > System Management > Storage Locations. Change the storage locations to point to the shares, rather than the absolute paths. For example:

C:\Program Files\Webtrends\storage\config

becomes:

\\<server name>\storage\config

8. Save the changes.

After saving, Webtrends will prompt to continue until all jobs have finished, or to cancel all tasks, even if none are in the queue. This option is recommended, as it will take care of the unseen system jobs.
Log out and let the services shut down and restart the machine. If the paths are the same, the system will perform a copy/verify. If Webtrends sees the new directory has no content, or if a new data location is being created, it will copy the data to that location at this time. This may a significant amount of time depending on the amount of data in your storage location. The process must not be interrupted.

9. Run the installer on the new machine and check the desired additional components such as Analysis Engine and input the MySQL or MS SQL details to connect to the existing installation.


When installing additional nodes on other machines, the system database must not be installed on the new machines, only the components services such as analysis engines, user interface servers, and GeoTrends servers. Otherwise the MySQL or MS SQL connection page will be grayed out and unchangeable.

10. Let the installer finish.

11. Log in to the user interface and under Administration > Application Settings > Monitoring >Topology confirm the changes were successful.