Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    When to use mysql for user records

    Scheduled Pinned Locked Moved Captive Portal
    1 Posts 1 Posters 1.1k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • V
      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?

      Thanks

      1 Reply Last reply Reply Quote 0
      • First post
        Last post
      Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.