Is there a way to migrate single-server data to a a Bungee setup?

[straboti2]

Hi! I have over a year of data on my server. I have recently installed bungeecord and an additional server. Is there a way to migrate the data from the old install to the new one?

[AuroraLS3]

Not yet but it's almost ready, I'm trying to work out the kinks on the feature

[straboti2]

How bad are the kinks? 😅 I'd like to migrate ASAP.

[AuroraLS3]

If you have the data in MySQL you can just connect the other servers to that one.

If you have the data in SQLite, current 5.6 version /plan db move sqlite mysql might work, or it might not. The problem with the existing system is that it fetches everything in memory before insert which can crash server if memory runs out. - New system tries to sort it out by batching the data inserts

I don't know how long it'll take to fix it, there's something wrong with the batching logic that it tries to insert duplicate rows in some cases and fails entirely

[straboti2]

thx

[straboti2]

DBInitException-6c5663d042.txt
So I tried that, it didn't work. It didn't run out of memory (or at least I don't think so), it gave me this:

[19:02:51] [Server thread/INFO]: StraboCraft issued server command: /plan db move SQLite MySQL
[19:02:55] [Server thread/INFO]: StraboCraft issued server command: /plan accept
[19:02:55] [Craft Scheduler Thread - 63 - Plan/INFO]: [Plan] Transaction queue closed.
[19:02:55] [Plan SQLiteDB-transaction-thread-1/INFO]: [Plan] Database: Making sure schema is up to date..
[19:02:55] [Craft Scheduler Thread - 63 - Plan/INFO]: [Plan] Transaction queue closed.
[19:02:55] [Plan SQLiteDB-transaction-thread-1/INFO]: [Plan] All database patches applied successfully.
[19:02:56] [Craft Scheduler Thread - 63 - Plan/ERROR]: [Plan] Ran into DBInitException - logged to plugins/Plan/logs/DBInitException-6c5663d042.txt
[19:02:56] [Craft Scheduler Thread - 63 - Plan/ERROR]: [Plan] (INCLUDE CONTENTS OF THE FILE IN ANY REPORTS)
[19:02:56] [Craft Scheduler Thread - 63 - Plan/ERROR]: [Plan] Error msg: "Failed to set-up HikariCP Datasource: Failed to initialize pool: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server."

[AuroraLS3]

Mysql connection settings needs to be set in the config first

[straboti2]

Oh okay I forgot that 😅

[AuroraLS3]

Experimental build is available here: https://github.com/plan-player-analytics/Plan/actions/runs/20750442760

I recommend doing a mysqldump before trying it out just in case something goes wrong.

I haven't fully tested all functionality, but the /plan db move sqlite mysql should function properly (I tested backup and restore which use the same code)

There is also now /plan db merge sqlite mysql which merges the existing data. (This is untested)