Navigation

    FusionAuth
    • Login
    • Search
    • Home
    • Categories
    • Recent
    • Popular
    • Pricing
    • Contact us
    • Docs
    1. Home
    2. Tags
    3. database
    Log in to post
    • All categories
    • J

      Facing duplicate key errors on high load
      Q&A • database connectors • • jm.oliver

      4
      0
      Votes
      4
      Posts
      258
      Views

      joshua

      Internal Note: tracking via https://github.com/FusionAuth/fusionauth-issues/issues/1231

    • dan

      Too many connections error with mysql
      Q&A • mysql database connections error • • dan

      3
      0
      Votes
      3
      Posts
      2868
      Views

      dan

      And now it works fine with 152 threads connected, so unable to reproduce this.

      I'll keep an eye out for this behavior and file an issue if it pops up again.

      For the record:

      FusionAuth 1.27
      installed via zip file
      Mysql 8.0.23 installed/managed via homebrew on the mac.

    • dan

      Are the post and get forms of the user search API equivalent?
      Q&A • database user search java client • • dan

      2
      0
      Votes
      2
      Posts
      125
      Views

      dan

      Yes, they are equivalent. Building this JSON:

      { "search": { "queryString": "fusionauth.io" } }

      and posting it is equivalent to a GET with queryString=fusionauth.io.

    • dan

      Can you use the database search engine with millions of users?
      Q&A • search engine search user search database elasticsearch • • dan

      2
      1
      Votes
      2
      Posts
      161
      Views

      dan

      I don't know of any issues. You’re mainly just giving up the ability to perform rich queries. The db search is a few LIKE statements.

      I don't think we've tested millions running db search - but the only issue I can think of for normal usage would be the User page in the UI since we’ll be paginating over lots of users.

      This should work ok - but pagination tends to slow way down as you get into higher pages,.

      One can always flip on Elastic and run an index, so not much harm in trying it.

    • dan

      Upgrade issue from 1.21 -> 1.22
      Q&A • database upgrade • • dan

      3
      0
      Votes
      3
      Posts
      148
      Views

      robotdan

      Added missing db migration notices for 1.21.0 and 1.22.0.

    • S

      how to get fresh installation?
      General Discussion • kubernetes database • • shaunladd

      4
      0
      Votes
      4
      Posts
      222
      Views

      dan

      Sorry, no kub expert here. I'm not sure how to teardown just the database, but I assume you could write a script to connect to the backing database and drop the tables/schema, etc. That might be quicker than dropping the entire cluster.

      If you figure out a better way, please share!

    • dan

      Retrieving ids from FusionAuth database tables
      Q&A • analytics database query sql • • dan

      2
      0
      Votes
      2
      Posts
      178
      Views

      dan

      Hiya,

      We don't guarantee any database level compatibility (which is why we recommend doing everything through the API, which does have those guarantees).

      But here's an option. I'm assuming you are using MySQL. FusionAuth uses UUIDs for unique Ids, and in MySQL we store these as BINARY(16).

      If you want to select this value in a human readable form, you can perform a select such as SELECT HEX(id) FROM table_name.

      If you want to select this column and deserialize it into a Java UUID type, you can use code similar to the following:

      public UUID fromByteArray(byte[] ba) { long msb = 0; long lsb = 0; for (int i = 0; i < 8; i++) { msb = (msb << 8) | (ba[i] & 0xff); } for (int i = 8; i < 16; i++) { lsb = (lsb << 8) | (ba[i] & 0xff); } return new UUID(msb, lsb); }

      Another option, depending on your data size, would be to export all the data using the relevant APIs, and import it into your analytics database.

    • dan

      maximum pool size configuration
      Q&A • configuration database settings • • dan

      2
      0
      Votes
      2
      Posts
      160
      Views

      dan

      You can use the database.maximum-pool-size value in the fusionauth.properties file prior to 1.19.x ( it was just not documented) , but if you want to use the environment variable version is not available until 1.19.x.

    • dan

      what is the default connection pool size for the app?
      Q&A • database connection pool • • dan

      3
      0
      Votes
      3
      Posts
      256
      Views

      robotdan

      Also, see database.maximum-pool-size here https://fusionauth.io/docs/v1/tech/reference/configuration

    • dan

      Where is the configuration stored in the database?
      Q&A • database configuration • • dan

      2
      0
      Votes
      2
      Posts
      137
      Views

      dan

      There isn’t a single table in the db really. Configuration exists there, and in tenants, applications, etc.

    • dan

      SOLVED How large can the data field be for any of the FusionAuth resources?
      Q&A • user-data database limits • • dan

      2
      0
      Votes
      2
      Posts
      190
      Views

      dan

      If you're using PostgreSQL the size is essentially unlimited. With MySQL it is 16 MB.

      There are few exceptions to this rule where we may be using a 64 KB column if you're on MySQL.

      I wouldn't recommend storing that much data however. If you're using Elasticsearch, the custom data on the User will be indexed, and Elasticsearch will eventually hit a limit as well.

    • dan

      SOLVED Does FusionAuth require that you migrate your userstore into the product?
      Q&A • user database external • • dan

      5
      0
      Votes
      5
      Posts
      243
      Views

      B

      @dan no problem at all. Completely understand it's tough offering support without reviewing how we have things setup.

      Appreciate you shooting that link over and will do some investigation on our end to see what might work best for us.

      Thanks!

    • dan

      Does FusionAuth support high availability database configurations?
      Q&A • database availability faq • • dan

      7
      0
      Votes
      7
      Posts
      633
      Views

      K

      @dan 160ms

    • dan

      Is it possible to set up DB replication using MySQL for FusionAuth db?
      Q&A • mysql database faq • • dan

      2
      0
      Votes
      2
      Posts
      203
      Views

      dan

      As long as your meet our minimum database requirements in theory it should work. I do know that MySQL Group Replication is not supported.