Hi,
I can complete the solr connection setup with mysql and will create a doc for you in step by step manner. This will help you in understanding that if you need to do it again.
i have expertise on search and recommendation engine and has implemented search systems on many products. i am working as search expert in a company for more than 4 yrs.