• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Forums under 500K post: Did you already use Elastic Search?

RoldanLT

Well-known member
#1
Right now I have:
Discussions: 41,322
Messages: 406,292
But still using the default mysql search.

I'm planning of purchasing Elastic Search addon, but is it worth it?
Maybe I should wait 1M post before using it.
 

RoldanLT

Well-known member
#4
Ok then, I have to raise funds first :)
Maybe Next Month I'll be installing it on my server.

Server Specs:
CPU: Intel i5 (4 cores / 4 Threads)
Frequency: 3.1GHz (3.8GHz Turbo Boost)
RAM: 8 GB DDR3
CentOS 6.5 Server

All my forum applications are run on this server (mysql, php, memcache, etc.)
Can it still handle Elastic Search?

Or I have to setup it other server?
 

TheBigK

Well-known member
#19
In what sense not coping up? Have you tried Percona?
Frankly speaking, my knowledge of databases is very very limited. In all the similar situations a few months ago; it was HTTP that'd crash. We moved over to LiteSpeed and life's been wonderful since then.

It was only until a few hours ago that the traffic spiked like anything and we got mySQL crashed. Note that the 'load' on the server, as indicated in our server control panel was still about 1.5 and LiteSpeed handeled it all well.

The problem was with MySQL. It crashed every time our online user count crossed 6k. Analytics would report about 800 real-time visitors and restarting MySQL was only option. The server admins (host) said they didn't see anything unusual in the logs.

I'm reading all the nice things about Percona. But I feel comfortable with phpMyadmin. I'll also have to check whether my web hosting folks would support it.