ComboStrap - Analytics and database replication
Table of Contents
About
The database replication process is the process that creates the analytical data if needed and replicates the data with the database.
Update
Because this is a intensive process, it happens slowly:
- for every page visited
- or for every page that gains or lost backlinks.
And the output is cached.
If you want to update all pages in batch, you can do it with the cli on the server.
Cache
To purge the analytical cache, you can:
- run the cli
- do it manually for one page by adding the following query ?do=export_combo_analytics&purge=true. See the dokuwiki doc
- modifying a configuration forth and back. The update of the configuration file purges the current cache.
Cli
On the server, you can replicate the data to the database with the cli following command
cd $DOKUWIKI_HOME
# optional (for farm)
animal=animal-directory-name
# command
php ./bin/plugin.php combo metadata-to-database
Monitoring
The replication date
The replication date is stored in the date_replication metadata and can be seen via:
- the metadata manager (integration tab)
- the Metadata Viewer.
- or query .
select
path,
date_replication
from
pages
order by date desc
limit 10;
The analytics date
You can see the analytics date on the date field of the JSON object
Example of query .
select
path,
json_extract(analytics, '$.date') as date
from
pages
order by date desc
limit 10;
Replication Request
When backlinks are added or deleted, a replication request of the page is asked to update them.
This request are stored in the table pages_to_replicate. If you query this table, you would get all page that should be replicated in the near future. This table should be empty 99% of the time as this is a temporary table.
select * from pages_to_replicate