Navigation

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

    When to use mysql for user records

    Captive Portal
    1
    1
    1003
    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