Hi,
 I'm trying to configure a cluster of two XWiki servers using MySQL on
 a third server.
 I started with a single XWiki server (xwiki-01) on tomcat6 with local
 MySQL instance, search was using Lucene and working as expected.
 Using dump and restore I moved the MySQL database to a different
 server (mysql-1) and adjusted
 /var/lib/tomcat6/webapps/xwiki/WEB-INF/hibernate.cfg.xml
   accordingly. access to the wiki still worked as expected and Lucene
 worked as expected. I was able to do a re-index with no issues.
 I spun up a new vm to be a second XWiki server (xwiki-02) and used
 rsync to copy over all of the relevant files and directories.
 /var/lib/tomcat6/webapps/xwiki
 the tomcat configuration files server.xml and /etc/default/tomcat6
 the private SSL certificate for tomcat6 (I'm using HTTPS) and LDAPs
 (to use port 636 instead of 389 against AD)
 As xwiki.cfg is configured with
 xwiki.plugins.lucene.indexdir=/var/lucene I manually created
 /var/lucene and did a "chown tomcat6:root /var/lucene" to set
 permissions.
 I'm able to access the wiki using xwiki-02 with no issues, but search
 is not working correctly, If I set search to use database it finds 710
 elements, if I set it to use Lucene it only finds 6.
 Search on xwiki-01 still works correctly and both Lucene and database
 search see 710 elements.
 I'm aware that until I follow
 
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/DistributedEventCluster…
 that the two XWiki instances won't be in "sync", but at the moment I'm
 more concerned about search... 
It should work. Did you try a full reindex on the second machine?
--
Sergiu Dumitriu