Hi, I am newbie for solr and I hope to check my idea is good or terrible if someone can help.
# background * I have mysql as my primary data storage. * I want to import data from mysql to solr (solrcloud). * I have domain logics to make solr document - (means I can't make solr document with plain sql query) # my idea * In mysql I make table for solr document, and insert/update whenever any changes made for solr document. * run data import handler (mostly delta query) from [solr document table] to solr with cron scheduler frequently with soft-commit. * hard-commit less frequently. Is it good or terrible idea? for any advice, I will be happy. Regards, Hangu