1
Help with MySQL
Hi, I recently have started doing research about Mysql and have become lost. I am setting up a couple of servers with bungeecord. Both of the servers are running cauldron 1.7.10 and pixelmon. My goal is to be able to able to share not only some plugin data (ex:permissions, inventory) but also the pokemon data (which is mysql supported) so players on both servers can save keep their pokemon and inventory and permissioms between severs. I want to know how should I go about this without causing lag. Should I put the mysql on the same dedicate machine as a server? Should I rent a vps from the same conpany for the mysql or should I just give up bevausw of lag. Thanks for any help you can provide.
2
MySQL is a special type of program that is meant to host databases and have very efficient data retrieval and storage. Now to answer you questions. Storing the data between two servers does not cause lag due to the fact that the database is almost instant retrieval and storage. Yes it should be on the same server because then you do not have an upload and download factor factored in. Also if the database server crashes, well then you have no way to save data which sucks. Second, do not use a Virtual Private Server. You need a dedicated server. Virtual Private Server lag due to the fact that it is collective RAM and CPU processing rather than a solid single machine processing for RAM and CPU. If you are using a VPS, you should expect lag or dedicated up from 4x to 10x extra the amount of RAM. MySQL as far as I know does not work well on VPS.
Thank you for the response, you have made it way more clear! Appreciate the help
