Q.Is it possible to crawl data from MySQL within an EC site and register it as documents in KandaSearch?

Yes, you can index data from MySQL. You can data from MySQL and register documents to KandaSearch using the Apache Solr API.