We've just moved to using a separate server for MySQL and this has finally let me rebuild my search index without killing our site.
We have apprx 2.5M posts and the MySQL server is a VPS with 1 CPU and 2GB of ram and is running smoothly.
Since rebuilding the search index, search results are very slow 5-10 seconds to return so I was considering ES but as the VPS only has 2GB of ram and half of this is set aside for the innodb buffer, I wonder whether ES would be any use...?
We have apprx 2.5M posts and the MySQL server is a VPS with 1 CPU and 2GB of ram and is running smoothly.
Since rebuilding the search index, search results are very slow 5-10 seconds to return so I was considering ES but as the VPS only has 2GB of ram and half of this is set aside for the innodb buffer, I wonder whether ES would be any use...?