When to use mysql for user records
vickikumar last edited by
Hi, I am running a small coffee cafe where I have pfsense setup to offer free wi-fi access. Usually, only 4 -5 users are connected to wi-fi at any moment with addition of daily new users to be around 25 - 30. Since a new user is created with validity of no more than two days, and I am required to keep usage access record of each user for at least two months, is it good to use mysql in this scenario? What is the best way to achieve this in terms of resource usage?