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.
- If the BA 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 BA or Mondrian server. If you aren't sure, verify now that the following JARs are present in the /WEB-INF/lib/ directory inside of your deployed pentaho.war or Mondrian engine:
- Edit the pentaho-analysis-config.xml in the /WEB-INF/classes/ directory inside the deployed pentaho.war or Mondrian engine, and change the value of SEGMENT_CACHE_IMPL to match the class name referenced below:
- Edit the memcached-config.xml in the /WEB-INF/classes/ directory inside the deployed pentaho.war or Mondrian engine, and change the values of SALT, SERVERS, and WEIGHT to 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>