Hi.
We have a app that is not logging what the users do, is a ERP but we
cannot know who change, delete or insert data to the db.
The good thing is that we can access the database, we start moving the
system screen to web, because with php we can access the db.
Now, we want to log what the users are doing, we have a idea, let me
explain and see if u understand and let me know if elasticsearch can
help me.
suppose that user1 access the screen number 2(screen2) this is for
adding a new Purchase Order, he change some data and save to the db,
the screen have for example 15 input fields.
Our app, will save the data to the db and after this will log all the
input fields, we concatenated the whole 15 inputs fields we don't care
about validation is what the user want and send it to a log file like
syslog for example that send all in text.
The log will have this format:
UserIP, Username, date+time,
screenX,input1,input2,input3,input4,input5,input6,input7,input8...input15
I don't care for indexes, data types validation, all I want to know is
what data the screen have went the user decide to save it.
Now if u see the log after couple of inputs we will have:
UserIP, User1, date+time,
screenX,input1,input2,input3,input4,input5,input6,input7,input8...input15
UserIP, User2, date+time,
screenX,input1,input2,input3,input4,input5,input6,input7,input8...input15
UserIP, User1, date+time,
screenX,input1,input2,input3,input4,input5,input6,input7,input8...input15
We continue using our ERP with the RDBMS but now we have logs of what
the users are doing, if something happen we go to our log system and
generate a query and search for all the changes in screenX->Input8
Because we know the meaning of that input8.
This is a idea we have, now I can use MySQL for this, create a db,
table with some fields and one that could hold the whole string for my
log, but I think is a waste of resources if we use MySQL.
I was reading articles about no-sql systems and my head ask: do a no-
sql system could help with this?
Do MySQL can do it?
Which one will be better?
Latter I read about elasticsearch and here I am searching for what
system could help us with this logging thing and not affect the
performance of a our current ERP system.
Thanks for your time!!!
no