maria-discuss team mailing list archive
Mailing list archive
Re: What is the right way to update based on a DB change?
Benoit Plessis <benoit+one@xxxxxxxxxxxx>
Fri, 30 Sep 2022 09:26:10 +0200
My Own Corp
Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.3.0
Why not simply having a timestamp on your client list table with the
automatic timestamp update of mysql/mariadb
And having your external client filter on this automatically maintained
update date ?
I don't know the use-case but a stronger auth than MAC/IP is also often
a good solution ^
On 30/09/2022 09:02, ngtech1ltd@xxxxxxxxx wrote:
I have the next scenario which I am not sure about the right way for a
I have a radius server that authenticate clients from multiple WIFI
I have couple systems and they need to know the current client login
identifier (MAC or IP Address).
It is stored in the DB and the DB is being updated on every login.
I can try to give a static IP for every user and it will resolve this
issue but there is an overhead for this.
Sowhat I was thinking instead is to either run a query that will fetch
the latest changes or use a trigger to update another table
which in turn will be read by an external software every 1-5 seconds.
I believe that the right solution is to use a trigger that will update
another table with the details and on the other table I will have a
Processed column that will be updated when the software finished
processing the row.
Then in turn every 24 hours I will run a DB cleanup cron.
I will try later on to share the schema.
Any advice is more than welcome.
NgTech, Tech Support
Email: ngtech1ltd@xxxxxxxxx <mailto:ngtech1ltd@xxxxxxxxx>
Web: https://ngtech.co.il/ <https://ngtech.co.il/>
My-Tube: https://tube.ngtech.co.il/ <https://tube.ngtech.co.il/>
Post to :maria-discuss@xxxxxxxxxxxxxxxxxxx
More help :https://help.launchpad.net/ListHelp