We have a MySql database (news) which has the following fields - posting_id, date, name, currency, country, expiry ....etc
The database has more than 1200000 entries. Daily around 200000 plus new records are added and around the same number deleted. posting_id is a unique ID for every record. Please can some help write a delta-import script so that the index file is update as per the records in the MySql database (news) everyday. If the posting_id is not found in the database (news) then the same is deleted from the solr indexed file and the records with new posting_id are indexed.
