I am seeking some advice from any one with more database experience than I (which would be almost anyone). ;)
At the moment I have Mango (ver 2.7.2) using its NoSQL database for data storage. Our data loggers feed into a proprietary MySQl database and I have Mango getting the data from those tables on a time interval, i,.e. every 5 minutes.
There are occasions when the data from the data loggers will update faster than every 5 minutes. So I am trying to set a trigger from our initial MySQL database tables that would insert the data into Mango.
You probably see my problem, with Mango using NoSQL. Can you tell me how to write the MySQL statement to go to the proper data location in the NoSQL database or even if that is possible.
For example: I use this trigger to move the latest historical readings in another table:
AFTER INSERT ON 'historical' FOR EACH ROW
insert into historical_copy
select * from historical order by historial_id desc limit 1;
Any advice would be greatly appreciated. Please keep in mind I am an SQL novice.