Switch to Memcached
To switch to Memcached, you must have your own pre-configured Memcached instance. You should have also installed the Analysis Enterprise Edition package to your Pentaho Server or standalone Mondrian engine.
If you already use the Memcached cache framework in your organization and would like to hook it up to the Pentaho Analysis OLAP engine, follow the directions below to switch from the default Infinispan cache framework configuration:
Pentaho and Mondrian developers recommend against using Memcached. You are almost certain to have better performance with Infinispan.
- If the Pentaho Server or standalone Mondrian engine are running, shut them down now.
- If you performed a default install of the Pentaho Analysis Enterprise Edition package, then you should have all of the required JARs installed to the Pentaho or Mondrian server. If you are not sure, verify now that the following JARs are present in the /WEB-INF/lib/ folder inside of your deployed
pentaho.waror Mondrian engine:
pentaho-analysis-config.xmlin the /WEB-INF/classes/ folder inside the deployed
pentaho.waror Mondrian engine, and change the value of
SEGMENT_CACHE_IMPLto match the class name referenced below:
memcached-config.xmlin the /WEB-INF/classes/ folder inside the deployed
pentaho.waror Mondrian engine, and change the values of
WEIGHTto match your preference:
<entry key="SALT">YOUR SECRET SALT VALUE HERE</entry> <entry key="SERVERS">192.168.0.1:1642,192.168.0.2:1642</entry> <entry key="WEIGHTS">1,1</entry>
Your Pentaho Analysis Enterprise Edition instance is now configured to use Memcached for OLAP segment caching.