WordPress.org

Ready to get started?Download WordPress

Forums

WassUp Real Time Analytics
Offsite DB Storage etc (2 posts)

  1. miketopher
    Member
    Posted 1 year ago #

    Hello, I like using Wassup for live visitor monitor as well as long term data tracking because it passes needed URL parameters that Google Analytics does not that allows me to see more specific where my traffic comes from, mainly from YouTube since the Video ID is a URL parameter

    However Wassup takes a bit of memory and other resources on my server, I wanted to find out if there was some way I could allow another server to handle this so its off loaded somewhere else.

    I looked in the source code to see if I could host some JS files somewhere else that might collect the data on a second install of WP on another server but I can't seem to even find that..

    Any Ideas?

    Thank you

    http://wordpress.org/extend/plugins/wassup/

  2. helened
    Member
    Plugin Contributor

    Posted 1 year ago #

    Thank you for using Wassup. Unfortunately, at this time, WassUp doesn't support offsite hosting of wassup data. We are exploring this option in the next generation of Wassup, but that is a long way off.

    Currently the only way to get Wassup data into a second install of WP on another server is to manually export and import the data. You can use a tool like "phpMyAdmin" or any WordPress backup utility that lets you export (and import) in SQL format. This import/export method isn't hard, but can be time-consuming because you may have to break up the export data into smaller subsets, if your wassup data is very large. Once done, though, you can look at historic wassup data on the second server without worrying about it impacting your website performance and you can speed up the original Wassup by deleting the old data that was exported.

    There are some extra steps to be aware of with this kind of duplicate Wassup setup on a second WordPress server:

    • Wassup "recording" must be disabled on the duplicate;
    • The table to export from and import to is "wp_wassup" (or customprefix_wassup).
      NO need to export from or import to "wp_wassup_tmp" or "wp_wassup_meta".
    • The duplicate wassup table (wp_wassup) must be empty prior to the first import of wassup data;
    • You should write down the record ID of the last exported wassup record to avoid "duplicate record" errors in the next import;
    • To view "Wassup Top Stats" on the second server, you need to add your website hostname to the list of excluded referrers;
    • To view "Top stats: Top article", you need to import "wp_posts" and "wp_post_meta" data from your website into the second WordPress;
    • To view WassUp chart, SPY map, and all Wassup-Options items, the second server must be connected to the internet to access Google APIs.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic