Les articles publiés sur le site
-
Piwik analytics database : migrating from MySQL to MariaDB
11 novembre 2015, par Piwik Core Team — MetaThis short blog post is an announcement regarding the Piwik technology stack.
Piwik compatible with MySQL and MariaDB
Since our first public release Piwik uses the open source database server MySQL to store the analytics data.
Piwik is also compatible with MariaDB. MariaDB is an enhanced, drop-in replacement for MySQL.
Upgrading to MariaDB
Many users from our community as well as Piwik PRO have confirmed that using MariaDB for Piwik has several advantages. MariaDB has in some cases significantly improved query performance and reliability of Piwik. Because MariaDB 5.5 is a complete drop-in-replacement for MySQL 5.5, upgrading can be as easy as running
apt-get install mariadb-server(or equivalent for your platform). Existing third party techologies such as TokuDB (FAQ) and Galera are fully compatible with MariaDB.Learn more about upgrading to MariaDB: Upgrading from MySQL to MariaDB
In the future, Piwik will stay compatible with both MySQL and MariaDB.
-
Piwik analytics database : migrating from MySQL to MariaDB
11 novembre 2015, par Piwik Core Team — MetaThis short blog post is an announcement regarding the Piwik technology stack.
Piwik compatible with MySQL and MariaDB
Since our first public release Piwik uses the open source database server MySQL to store the analytics data.
Piwik is also compatible with MariaDB. MariaDB is an enhanced, drop-in replacement for MySQL.
Upgrading to MariaDB
Many users from our community as well as Piwik Scalability Experts have confirmed that using MariaDB for Piwik has several advantages. MariaDB has in some cases significantly improved query performance and reliability of Piwik. Because MariaDB 5.5 is a complete drop-in-replacement for MySQL 5.5, upgrading can be as easy as running
apt-get install mariadb-server(or equivalent for your platform). Existing third party techologies such as TokuDB (FAQ) and Galera are fully compatible with MariaDB.Learn more about upgrading to MariaDB: Upgrading from MySQL to MariaDB
In the future, Piwik will stay compatible with both MySQL and MariaDB.
-
Help us to improve Piwik by sending anonymous usage data (and get usage data yourself)
At Piwik we have developed a new plugin named AnonymousPiwikUsageMeasurement. The opt-in and anonymised usage tracking information will be used by us to build a better product and a great user experience. The plugin can be installed via the Piwik Marketplace with just a few clicks in your Piwik installation. As a Super User simply go to the Administration and select Marketplace in the left menu. There you will find the plugin and can install it with just one click.
The plugin allows you to track usage data into up to three Piwik installations:
- demo-anonymous.piwik.org (enabled by default, can be disabled).
- your own Piwik (can be configured optionally)
- a custom Piwik (can be configured optionally)
The usage data that is sent to Piwik can be publicly viewed by anyone under demo-anonymous.piwik.org.
What are the advantages by tracking the data into my own installation?
You can see how your Piwik installation is used and how well your Piwik performs by checking the average generation time of pages and API calls. Use the Row Evolution feature to see how your Piwik is performing over time.
What is Piwik doing to make sure the data is anonymized?
We are very careful in what we track and we make sure to anonymize data that could contain user data.
- We overwrite the page title as the title could contain the name of the viewed website
- We remove any referrer information
- We replace URL paramaters with a predefined value apart from a few whitelisted ones to make sure no actual
token_auth,CSRF tokenor user defined value will be tracked - On demo-anonymous.piwik.org 3 bytes of the IP are anonymised (eg when IP is 192.168.1.1 we track only 192.0.0.0). We do not track nor collect your location and provider information.
- We do not track clicks on outlinks or downloads
When should I not install this plugin?
If you have developed a custom Piwik plugin that contains for example the name of your business in any of the following names we recommend to not install this plugin as it might be tracked:
- name of a plugin
- name of a controller action
- name of a report
- name of a widget
- name of an API method
Plugins that are installed via the Marketplace should not pose a problem as their names don't contain any user specific information such as the name of your business.
The data is tracked as efficiently as possible as to not slow down your Piwik server. If you already have some performance challenges with your Piwik, we recommend not to install this plugin.
Which data is tracked?
When the plugin is activated, the following data will be tracked:
- The pages and reports that are viewed
- The visitors' software and devices data like the used browser and the resolution
- Some clicks or interactions with certain selectors or buttons. For example we track an event when a segment is selected (but we do not track the actual segment name or value).
- In a daily task we track the following data:
- Piwik version
- PHP version
- Number of websites
- Number of users
- Number of segments
- How often which API method was called (only plugin name and method name but no parameters) and how long the API calls took on average.
Are there any prerequisites?
- If sending usage data to Piwik is enabled, the Piwik installation must be connected to the internet
- If tracking to a custom Piwik installation is enabled, your Piwik installation and your Piwik users must be able to connect to this instance
Where can I report any issues with the plugin?
If you experience any issues with the plugin please create a new issue. The source code is available under GPL v3+ on GitHub. We always appreciate pull requests and suggestions to improve this plugin.
-
Help us to improve Piwik by sending anonymous usage data (and get usage data yourself)
At Piwik we have developed a new plugin named AnonymousPiwikUsageMeasurement. The opt-in and anonymised usage tracking information will be used by us to build a better product and a great user experience. The plugin can be installed via the Piwik Marketplace with just a few clicks in your Piwik installation. As a Super User simply go to the Administration and select Marketplace in the left menu. There you will find the plugin and can install it with just one click.
The plugin allows you to track usage data into up to three Piwik installations:
- demo-anonymous.piwik.org (enabled by default, can be disabled).
- your own Piwik (can be configured optionally)
- a custom Piwik (can be configured optionally)
The usage data that is sent to Piwik can be publicly viewed by anyone under demo-anonymous.piwik.org.
What are the advantages by tracking the data into my own installation?
You can see how your Piwik installation is used and how well your Piwik performs by checking the average generation time of pages and API calls. Use the Row Evolution feature to see how your Piwik is performing over time.
What is Piwik doing to make sure the data is anonymized?
We are very careful in what we track and we make sure to anonymize data that could contain user data.
- We overwrite the page title as the title could contain the name of the viewed website
- We remove any referrer information
- We replace URL paramaters with a predefined value apart from a few whitelisted ones to make sure no actual
token_auth,CSRF tokenor user defined value will be tracked - On demo-anonymous.piwik.org 3 bytes of the IP are anonymised (eg when IP is 192.168.1.1 we track only 192.0.0.0). We do not track nor collect your location and provider information.
- We do not track clicks on outlinks or downloads
When should I not install this plugin?
If you have developed a custom Piwik plugin that contains for example the name of your business in any of the following names we recommend to not install this plugin as it might be tracked:
- name of a plugin
- name of a controller action
- name of a report
- name of a widget
- name of an API method
Plugins that are installed via the Marketplace should not pose a problem as their names don't contain any user specific information such as the name of your business.
The data is tracked as efficiently as possible as to not slow down your Piwik server. If you already have some performance challenges with your Piwik, we recommend not to install this plugin.
Which data is tracked?
When the plugin is activated, the following data will be tracked:
- The pages and reports that are viewed
- The visitors' software and devices data like the used browser and the resolution
- Some clicks or interactions with certain selectors or buttons. For example we track an event when a segment is selected (but we do not track the actual segment name or value).
- In a daily task we track the following data:
- Piwik version
- PHP version
- Number of websites
- Number of users
- Number of segments
- How often which API method was called (only plugin name and method name but no parameters) and how long the API calls took on average.
Are there any prerequisites?
- If sending usage data to Piwik is enabled, the Piwik installation must be connected to the internet
- If tracking to a custom Piwik installation is enabled, your Piwik installation and your Piwik users must be able to connect to this instance
Where can I report any issues with the plugin?
If you experience any issues with the plugin please create a new issue. The source code is available under GPL v3+ on GitHub. We always appreciate pull requests and suggestions to improve this plugin.
-
How to get your Piwik plugin translated in many languages ?
About a year ago we introduced the Piwik Marketplace to make it easy for developers to share their plugins with all Piwik users.
As Piwik is currently available in 54 languages we would love to have as many plugins as possible available in at least a few of those languages.
Currently most plugins on the Marketplace are only available in English and sometimes some other languages. To improve this situation, we offer plugin developers the possibility to use the power of our translators community to get their plugins translated.
Some plugin developers are already using this service and some very popular plugins like BotTracker or CustomOptOut have already been translated in more than 10 languages!
Getting translations for your plugin
As long as you are developing an open source plugin hosted on Github, you may get in touch with us (translations@piwik.org) in order to get your plugin translated by the Piwik translators community.
You will need an account on Transifex.com. If you use Transifex with a social login, please ensure to set a password in your account settings. This will be required for fetching new translations into your plugin repository.
Importing your plugin’s strings in the translation platform
While doing the initial setup for your plugin, we will import your english translation file (
en.json) in your Github plugin repository and we will configure an auto-update for this file. Source strings on Transifex will automatically synchronise with your plugin repository. When you change any string in youren.jsontranslation file, the updated English strings will automatically be imported in Transifex.How to fetch your plugins translations into your repository
As soon as we have set up your plugin within our Piwik project on Transifex and there are new translations available, you will be able to update your plugin translations using the Piwik console. You will need a locally installed Piwik with development mode enabled, and your plugin installed. To update the translations go to the Piwik directory on your development box and execute the following command:
./console translations:update -u {YourTransifexUserName} -p {YourTransifexPassword} -P {YourPluginName}We are looking forward to seeing your Piwik plugins available in more languages! For more information, check out our Translations plugin developer guide.
Happy hacking,
