Comments (12)
I'm kind of split on whether to fix this or just try to jump out to something else like Elasticsearch. ES is overkill in a way but I think we could do the free tier on AWS and thus kill the insanely over-priced Thinking Sphinx monthly charge.
from transbucket_rails.
I am pretty far along now, and have an ES domain on AWS set up which I can hit as well as a local instance working. I think what I will do is try to get this up on staging tonight or tomorrow. If it works there I will roll it out and cancel Thinking Sphinx.
from transbucket_rails.
Hmm, the instance seems stuck/dead.
from transbucket_rails.
I tried changing EBS amount to force it to BG but still stuck.
from transbucket_rails.
Trying to up it to 2 nodes. If it has to be on 2 just to run we're pretty much back to square one wrt the budget.
from transbucket_rails.
That brought it back up. (Or it finally just recovered...) I put it back down to 1 node, watching to see if it goes out of Processing.
I am wondering if I should kill this experiment though and just do postgres full text search...
from transbucket_rails.
Went down overnight at some point, which doesn't scare me as it came back up. But! The index was deleted, too!
We also need better client handling by the service to deal with getting a 404.
I've never used the burstable instances. It must've dropped the node and without a replica not been able to restore the index. This suggests we'll need to carefully monitor it to keep it up or add another node.
from transbucket_rails.
Again a node went down, and despite going to 2 nodes still in Processing. I think it's worth trying postgres instead.
https://www.postgresql.org/docs/9.5/textsearch-tables.html
https://stackoverflow.com/questions/10875674/any-reason-not-use-postgresqls-built-in-full-text-search-on-heroku
from transbucket_rails.
I think I will merge this and leave it up on 2 nodes, hoping that that can stay up "mostly" until replaced. I would like to at least implement better error handling on 400/500 codes from ES though.
Support post: https://forums.aws.amazon.com/thread.jspa?threadID=335962
from transbucket_rails.
Things to try:
https://github.com/Casecommons/pg_search
https://github.com/textacular/textacular
https://github.com/sunspot/sunspot
Is used by websolr which is $20 a month on heroku.
https://elements.heroku.com/addons/bonsai has a free tier which is plenty big enough for us I think. This might be the best starting option?
I think I will try the Bonsai free tier for now. If it can stay up under load, that might work for now. Gives us a bit of room to try pg search as well.
https://docs.bonsai.io/article/97-ruby-on-rails
from transbucket_rails.
Bonsai is up now, we'll see.
from transbucket_rails.
I'm calling this all set now. There's more improvements to do, but Bonsai has held up with no issue at all.
from transbucket_rails.
Related Issues (20)
- Search indexing failing after Heroku's DB maintenance HOT 2
- POST to /pins can time out
- move to heroku-20 before may
- rspec tests don't all pass HOT 4
- search results page displays wrong HOT 5
- contact page doesn't work HOT 8
- is_sensitive or is_graphic flag HOT 1
- Setup Issue: mysql2 installation fails on bundle install HOT 1
- logged out ads block some other ui elements HOT 1
- style ui to prioritize mobile experience
- tune ad experience HOT 3
- normalize procedure names HOT 2
- surgeons index (like procedures index) HOT 2
- filter query doesn't stay populated through navigation HOT 3
- i18n of user flow HOT 11
- cost reduction HOT 7
- fix all n+1 queries HOT 2
- surface complications stats
- results beyond page 20 won't load HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from transbucket_rails.