SQL connections

Discussion in 'Systems Administration' started by KilltoLiveTR, Jun 29, 2019.

  1. I open a server first time. Normally i am doing this for a hobby on localhost. Everyone looks good on server but i have a question. Some plugins have SQL settings. Which plugins should i connect to SQL? SQL is important for performance? For example i know i must connect AuthMe to SQL for my website bla bla but SkinRestorer, NameTagEdit, IslandBorder? P.S: SQL and server in same server.
     
  2. If you want to setup a server network, means multiple servers, it might be good to use MySQL to allow data sharing between these servers. It depends some plugins offer SQL database support to share data between servers and be able to use the data on multiple servers.

    MySQL can be quite good for performance. However it can really depend on how the developer implemented it. It can be horrible too, like most other things. I used plugins back in the days, which had horrible database management combined with SQL.

    Generally I recommend using SQL rather than file based data storage.