MySQL Sync icon

MySQL Sync -----

Sync the data of your Players between several servers with MySQL Sync.




Hello there,

thanks to some people over at PaperMC, we could resolve the issue today. One final note here: Folia is still not capable of running large scale servers/networks. Also this fix may take some memory or cpu power from your server, but I won't go into much technical details. If you are interested, you can message me.

This fix solves that players needed to rejoin the server after dying when the server used Folia.

~ Leo
----------, May 31, 2024

Hello there,

another bug was fixed today, regarding the generation of the player profile. When the profile of a player is being generated, the player would never be taken out of the list, which cancels every action of him on the server. This is now fixed.

~ Leo
----------, May 4, 2024

Hello there,

today I fixed the last known bug in MySQL Sync. There was a problem, that origined in the 1.4.10 Performance and Bugfix update, which executed many tasks as asynchronously. One of these tasks was loading the player data, this was a problem, because setting gamemode and potion effects cannot run async in Spigot AND Folia. This was fixed by running these tasks in sync mode again, like before.

If you still find any bugs, join our Discord and feel free report them there.

~ Leo
----------, May 2, 2024

Hello there,

here is another Bugfix Update, but not only that. MySQL Sync has finally support for Folia Servers in the newest Minecraft Versions (1.20.x). Also we have a new Language again, this time Japanese from RedCatKnights and kosan_1014 big shoutout to them for translating the plugin.

Bugfixes:
  • When a player executed /sync reload and didn't have the correct permission, there was an error printed into the console.
  • When a player executed /sync and didn't have the correct permission, there was an error printed into the console.
(Both bugs were reported by こうさん thank you for reporting them to us.)

Also we are working on bringing our maven repository for the Developer API back up and running. It is online as a unsafe website as of yet, and with an older version of the MySQL Sync API.

~ Leo
----------, Apr 11, 2024

Hello there,

the 1.4.10 Bugfix and Performance update is finally out. We have a lot of new stuff packed into this.

Bugfixes:
- A Problem was fixed, where non Latin Font corrupted the Database, thanks to 阿橘 for reporting this to me.
- My own stupidity was fixed, because the &n character is already reserved by Minecraft to underline text. Now the Plugin correctly says, that \n is the character for a new line. Thanks to こうさん for bringing my attention to this.
- Implemented the Bugfix from Version 1.4.3 correctly into MySQL-Sync (it was not registered in the right way before).

API-Changes:
- The GeneartingPlayerProfileEvent now also knows, if the Playerdata is imported from the active Minecraft World or not.

Performance:
- Removed no longer needed implementations of APIs.
- Removed old HandleData file, this was used before the 1.4 Update, to save and load data out of the MySQL. Since the partial rewrite of this System in the 1.4 Update, this was no longer needed.
- Updated APIs to their newest Version, so MySQL-Sync is up to date.
- General update for Java Conventions from meik99 thanks to him. (He can be found on Github)
- MySQL-Sync also now runs everything in async mode, that can be run in it. This will boost the performance of your servers alot, thanks to Sabbelsock1 for reporting this performance issue to me.

Languages:
- Chinese (Simplified) is now a supported Translation, thanks to ifloppy.
- Swedish is also now a supported Translation, thanks to DLMass.
(Both translators can be found on Github)

Again, thank you for all users helping me keep MySQL Sync up to date, and alive, by reporting bugs, writing new translations or simply helping me with some aspects of the coding side.

~ Leo
----------, Apr 8, 2024

Hello there,

I know, there may be more bugs and also more bugfixes for version 1.4 but I wanted to fix this one first.

The queuing system had the issue, that commands were executing twice in
a row. This should be fixed now.

~ Leo
----------, Aug 7, 2023

Hello there again,

so there are another few bugfixes, that I wanted to release before the version 1.5, these include:
- Fixed update message not being send since version some of the last bugfix versions.
- Fixed data loss on stopping server with specific server software.
- Now queuing command for players that are not fully loaded in, to make the plugin more safe.

That's all for now! More informations about the 1.5 version will be released soon.

~ Leo
----------, Aug 6, 2023

Good Evening,

I have another bugfix for y'all!
There was a bug, which rolled back the inventory of the player to the latest backup on server restart. It should now be fixed.

The next version will probably be 1.5.0!
However, the new features which will be implemented are way more complex and will take much ore time than any update before. If I would guess, it would take around 2 to 3 months. But there will be still support and bugfixes if necessary on the 1.4 gen of the plugin.

~ Leo
----------, Jul 21, 2023

Good evening,

I made some mistakes with the update earlier today, everything should be fixed now. Please don't run the 1.4.5 version, it will not backup the data like it should backup it. Please use this version for data backups while the server is running.

~ Leo
----------, Jul 4, 2023

Hello there,

I am back again with another Bugfix Update. But first of all I have to apologize that it took so long to fix this bug, but sometimes, real life is way more important than something you are doing online.

Now to the bugfix, as many of you know, the plugin couldn't save data when the server crashed. That was because of the limitations of spigot on server crash. I added a way to store player data before the server is crashing.

So you now can enable backups! You can configure how often the data should be backed up and also select which data should be backed up. For performance and traffic reasons, the plugin will check if data has changed since the last backup, if not it will not perform a backup of that specific data.


If you update from any 1.4.x version you will have to add the following lines under the "settings:" section in the config. Or you can just backup the old config file and delete the old one.

Thanks again for everyone that reported this bug. And again, sorry for the long wait.

~ Leo
----------, Jul 4, 2023

Good evening,

there was another bug we were able to fix. It was possible to open storage objects before the player data was fully loaded in. But thats fixed now.

There are also Updates for the language system.
- The German translation is now fully translated.
- no_NO (Norwegian) was added. Thanks to Theo for translating.
- ru_RU (Russian) was added. Thanks to Erik__Chapmann for translating.
Huge thank you for the contributions to this Plugin.

~ Leo
----------, Jun 15, 2023

Hello there,

another bugfix for MySQL-Sync is here!

There was a bug that corrupted player data on server restart. It should be fixed now. Also special thanks to the Discord User Xitrine for reporting the bugs fixed in the last few versions and also helping me fix them.

~ Leo
----------, Jun 11, 2023

Bugfix Update 1.4.2

Bugfixes:
- Random Item loss was fixed.
- Item loss when having Item on Cursor was fixed. (Fix in 1.4.1 didn't work out right)
- Item Dupe Bug that was fixed in 1.4.1 still existed in some rare cases. Which was fixed too.

~Leo
----------, Jun 9, 2023

Hello there,

I have a Bugfix here, that everyone should install. This Update fixes 1 major bug and two small ones.

- The major bug let Players dupe Items, by dying and then not respawning but disconnecting from the Server.
- The first small bug deleted the Item the Player had on his curser while his inventory was open, if he got disconnected.
- The second small bug deleted Items the Player picked up before his Inventory was loaded in.

Also another small change was added, you can now set it in the config that the Plugin only Syncs the data of Players if they have the Permission "sync.sync"

If you Update from 1.4.0 please add the following line under "settings:" in your config. Or just backup the old Config file and delete the old one.

Code (YAML):
onlySyncPermission : false # Only Sync the Players Data with the permission "sync.sync"

As always, feel free to report Bugs and send me new Ideas for the Plugin.

~ Leo
----------, Jun 1, 2023

Hello there,
so I have been working on the Plugin a lot lately and have a mega update for it now.

Here's the Changelog of the 1.4.0 Update:

- Added Support for MongoDB.
- For future versions, notice if you need to Update the Plugin.
- Made Developer Message customizable.
- Added TabComplete on Command.
- For more accessibility, some config entry names were changed:
-> lacking-permission to lackingPermission
-> use-permission to usePermission
- Completely reworked PlayerData Storage System.
- New Error Messages instead of just exceptions for better and faster Support.
- Changed some internal variable and function names.
- Fixed a Bug where some Data was mixed up.
- Added an API for Developers.
- Added ability to use existing Player Data to create a Player Data Profile.
- Added multi language System.

A few notes:
- The Update may be unstable because it is not possible to test for every single situation that could occure. Because of that please contact me if you found any Bugs or major Issues via Discord or Github.
- There may be a Bug where the Config is not updating correctly, I am working on it to fix this potential bug, but I do not have a lot of Information about it. Because of that potential Bug please make a Backup of your Config before updating the Plugin. If you encounter this bug, please feel free to contact me.
- The Plugin page will get it's update soon, I still got a lot of things to do.
- And last but not least, the sourcecode will be updated in a couple of days. It will take this long because of some technical difficulties.

~ Leo
----------, May 30, 2023

Hello there,
so I have been working on the Plugin a lot lately and have a mega update for it now.

Here's the Changelog of the 1.4.0 Update:

- Added Support for MongoDB.
- For future versions, notice if you need to Update the Plugin.
- Made Developer Message customizable.
- Added TabComplete on Command.
- For more accessibility, some config entry names were changed:
-> lacking-permission to lackingPermission
-> use-permission to usePermission
- Completely reworked PlayerData Storage System.
- New Error Messages instead of just exceptions for better and faster Support.
- Changed some internal variable and function names.
- Fixed a Bug where some Data was mixed up.
- Added an API for Developers.
- Added ability to use existing Player Data to create a Player Data Profile.
- Added multi language System.

A few notes:
- The Update may be unstable because it is not possible to test for every single situation that could occure. Because of that please contact me if you found any Bugs or major Issues via Discord or Github.
- There may be a Bug where the Config is not updating correctly, I am working on it to fix this potential bug, but I do not have a lot of Information about it. Because of that potential Bug please make a Backup of your Config before updating the Plugin. If you encounter this bug, please feel free to contact me.
- The Plugin page will get it's update soon, I still got a lot of things to do.
- And last but not least, the sourcecode will be updated in a couple of days. It will take this long because of some technical difficulties.

~ Leo
----------, May 30, 2023

- The ability to sync statistics between servers was added.
- Spigot ToDo list was Updatet.

This Update adds a big new feature, because of this it may be unstable in the next few weeks, before every bug (if existing) was found and patched.

Also I am in staying in Italy right now, because I am on holiday. And the Internet here is not fast enough to upload big files, so I will upload the changes in the code onto GitHub, when I am back in Germany.
----------, Apr 9, 2023

There was a chance that the plugin would try to add the player two times to the database. This bug was fixed with the 1.2.4 Update.
----------, Mar 19, 2023

- We now officially Support the 1.19 Versions.
- Also the invalidedata bug was fixed, it showed it's effect, through not loading everything out of the database into the player.
----------, Feb 23, 2023

There was a bug, that cleared some or all inventorys of the player, when the player quickly joined and quit the server.

It has been fixed with this update.
----------, Feb 21, 2023

Fixing the Consol Spamming, when using Achivements, it was accidentally left over from development and testing.
----------, Jun 7, 2022

These are the new Features in the 1.2.0 Update:
- Auto Updater for 1.0.0 to 1.2.0 and 1.1.0 to 1.2.0 for both MySQL and Config
- Renamed the ConfigUpdater.java to Updater.java
- Adding Snyc for:
- Effects
- Advancements (Only recommended if you have a lot of disc space)
- Also fixing up Issue#1
----------, Jun 7, 2022

These are the new features in the 1.1.0 Update:
- Settings for what should be synced
- Settings for some messages, if they should be send
- Version String in Config for internal ConfigUpdater
- Sync Command:
- Reload Config
- Show Version of Plugin
- Show Developer of Plugin
- Show help to this Command
----------, Jun 5, 2022

bStats didn't build right into the Plugin, because of that I made a hotfix and now everything works just fine.
----------, Apr 21, 2022

Resource Information
Author:
----------
Total Downloads: 1,451
First Release: Apr 21, 2022
Last Update: May 31, 2024
Category: ---------------
All-Time Rating:
11 ratings
Find more info at discord.gg...
Version -----
Released: --------------------
Downloads: ------
Version Rating:
----------------------
-- ratings