You are here: Foswiki>Main Web>OpenXDistributedStatistics (19 Nov 2011, AvishaiIshShalom)EditAttach
OpenX docs are lacking on this topic. Here are the missing pieces:
  • MySQL user on the master database needs the SUPER privilege because it uses set sql_log_bin=0
  • openx-2.8.7 needs to be patched:
    --- openx-2.8.7/maintenance/maintenance-distributed.php   2010-09-14 23:25:55.000000000 +0200
+++ maintenance-distributed.php   2011-10-05 23:50:00.393104582 +0200
@@ -33,7 +33,8 @@
 ob_start();
 
 // Run maintenance
-require '../scripts/maintenance/maintenance-distributed.php';
+$path = dirname(__FILE__);
+require $path . '/../scripts/maintenance/maintenance-distributed.php';
 
 // Get and clean output buffer
 $buffer = ob_get_clean();
@@ -41,4 +42,4 @@
 // Flush output buffer, stripping the
 echo preg_replace('/^#!.*\n/', '', $buffer);

-?>
\ No newline at end of file
+?>
  • delivery nodes should be configured as follows: the database section should refer the local slave, lb section is the main database
  • Time synchronization is crucial. Make sure ntp is running, and /etc/localtime is the same.
  • on 2.8.x raw logging tables are %_data_bkt_% NOT %_data_raw_%
  • Set distributed-maintenance crontjob on the delivery boxes to run off the round hour, e.g. at 1,15,30,45. The admin node maintenance job must run after the delivery nodes distributed-maintenance, so run it at 5 minutes past the hour. Reference

-- AvishaiIshShalom - 05 Oct 2011
Edit | Attach | Print version | History: r3 < r2 < r1 | Backlinks | View wiki text | Edit wiki text | More topic actions
Topic revision: r3 - 19 Nov 2011 - 12:39:17 - AvishaiIshShalom
 

This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Foswiki? Send feedback