-Ubuntu 12.04 LTS
-Apparmor
-nginx with SPDY and Forced-SSL enabled
-PHP-FPM
-MySQL (Tried Maria, Quit Life, Went Back to MySQL)
-Memcached and memcache
-SphinxSearch (Bane of my Existence)
-PHPMyAdmin
-Postfix
-LXC/LXD for everything.
I thought SPDY was getting shelved. I tried to install it back when they first announced it, but generally didn't bother with it after that.
Also I hear you with Sphinx. When it comes to building product searches, you can never make everyone happy. They want X, but not Y. Then someone wants X+Y but not Z. First person chucks a fit because Y is showing up but not Z. I just gave up and went, you know what, what you have is good enough. Search properly if you want results to be right.
Might be just me, but I've found that I need to put waits in some time to allow Sphinx to actually return a proper result set. The API comes back with results, but not all of them. If I do a search, wait 1 second, then do the search again, I get the full result set. Probably just the version of the API I'm running.
Oh I highly recommend SQLYog as a MySQL client. Connect to your database via a SSH tunnel (built into the program) to remove the need to have PHPMyAdmin installed on the server. That is i'm guessing you'd have MySQL bound to a local address and not externally accessible.
Yea, SPDY is going the way of the buffalo, making way for HTTP/2 but I still have it enabled on my prod and dev, it's easy to kill just really haven't got around to doing it. I still think that HTTP/2 is using SPDY in some sense though, I haven't really looked into it lately though, been mostly focused on FrontEnd instead of BackEnd stuff.
As for Sphinxit took me ages to get it working just right, I think it honestly works on borderline black magic and I'll always forget about indexer on the first time I setup a server and I'll wonder why I've got no results. Helps if you index everything first.
I always joke with people at work when they want me to reindex stuff... Knowing that --rotate allows for searchd to not go down, I joke with them "If people can't search properly because I'm indexing 3 million odd products" points at them... "your fault". Generally happens when a product is added to the system and they want it searchable straight away.
What they don't realise is that everything runs like clockwork, and stuff happens when stuff can happen. As soon as you start demanding things to run at the drop of a hat, that's when things start to conflict and cause slowdowns.
Black Magic... yes. How it works, I don't know. I get results, I'm happy.
Stack:
-Ubuntu 12.04 LTS -Apparmor
-nginx with SPDY and Forced-SSL enabled
-PHP-FPM
-MySQL (Tried Maria, Quit Life, Went Back to MySQL)
-Memcached and memcache
-SphinxSearch (Bane of my Existence)
-PHPMyAdmin
-Postfix
-LXC/LXD for everything.
I thought SPDY was getting shelved. I tried to install it back when they first announced it, but generally didn't bother with it after that.
Also I hear you with Sphinx. When it comes to building product searches, you can never make everyone happy. They want X, but not Y. Then someone wants X+Y but not Z. First person chucks a fit because Y is showing up but not Z. I just gave up and went, you know what, what you have is good enough. Search properly if you want results to be right.
Might be just me, but I've found that I need to put waits in some time to allow Sphinx to actually return a proper result set. The API comes back with results, but not all of them. If I do a search, wait 1 second, then do the search again, I get the full result set. Probably just the version of the API I'm running.
Oh I highly recommend SQLYog as a MySQL client. Connect to your database via a SSH tunnel (built into the program) to remove the need to have PHPMyAdmin installed on the server. That is i'm guessing you'd have MySQL bound to a local address and not externally accessible.
Yea, SPDY is going the way of the buffalo, making way for HTTP/2 but I still have it enabled on my prod and dev, it's easy to kill just really haven't got around to doing it. I still think that HTTP/2 is using SPDY in some sense though, I haven't really looked into it lately though, been mostly focused on FrontEnd instead of BackEnd stuff.
As for Sphinxit took me ages to get it working just right, I think it honestly works on borderline black magic and I'll always forget about indexer on the first time I setup a server and I'll wonder why I've got no results. Helps if you index everything first.
I always joke with people at work when they want me to reindex stuff... Knowing that --rotate allows for searchd to not go down, I joke with them "If people can't search properly because I'm indexing 3 million odd products" points at them... "your fault". Generally happens when a product is added to the system and they want it searchable straight away.
What they don't realise is that everything runs like clockwork, and stuff happens when stuff can happen. As soon as you start demanding things to run at the drop of a hat, that's when things start to conflict and cause slowdowns.
Black Magic... yes. How it works, I don't know. I get results, I'm happy.