I can only talk about Solr, as this is what we use.
I deployed the Solr stack to EC2 and we process several million records in each database. I currently have a master / slave setup and a very good circuit.
Beyond the obvious benefits of Solr and the awesome queries you can do, one thing that is often overlooked is how easy it is to set up and learn! It took me a day to read the Solr 1.4 Enterprise Search Server, and a week later I built a fairly robust Master and Slave AMI on Amazon EC2, performed load testing and configured Map Reduce jobs to continuously pump data into Solr Master.
My two cents.
Jason palmer
source share