News → Database migration completed

Database migration completed

Our server has two hard drives. A 100GB SSD and a 150GB HDD.
Until today, the latter was used for backups only and everything else was stored on the SSD. However, this wasn't possible anymore as our worlds are growing (currently ~23GB) and our database (containing website, plotme data, logblock, etc) is also continuously growing (currently ~40GB).

The SSD was filling up more and more up the the point where the server automatically shut down itself to prevent damage caused by no free space on the disk:

redstoner_stopped

We moved and deleted some files that weren't needed so the server could run again, but it was clear that we needed a solution very quick.
It was then decided to move the MySQL database to our HDD. Luckily the HDD isn't that slow and it took only 10 minutes to move it and the whole process including tests and what not did take no longer than 20 minutes.

Everything's fine now, both disks are used about 50% and our status tool is mostly happy as well:

rs status


Edit: For those who missed it, we had a temporary server during the migration. It didn't take one minute until the whole area around the spawn point was completely griefed and fucked up by TNT. Good job everyone!


Sorry for the short downtime, but this was necessary to prevent this type of problem for at least one year to go.

Happy redstoning!

10 comments.

I have no idea what this all means, but, yay!

Yay, hopefully it'll live for a while longer now :D

For those who missed it, we had a temporary server during the migration. It didn't take one minute until the whole area around the spawn point was completely griefed and fucked up by TNT. Good job everyone

Really guys? LOL

Everything's fine now, both disks are used about 50%

4th line of code:

CPU usage: ||||||||||| 11.025/9.82 %

Is everything really used about 50%?

CPU is not a disk.

"For those who missed it, we had a temporary server during the migration. It didn't take one minute until the whole area around the spawn point was completely griefed and fucked up by TNT. Good job everyone"

So i missed the tnt and fun :( Stupid shopping >.<

CPU usage: ||||||||||| 11.025/9.82 %

...I think your CPU is broken...

@ScienceRedstone Sorry for the late reply (I was just randomly browsing and found your post) the first number is what spigot is using (basically the minecraft server) and the second one is how much the actual system is using (notice the colours)

I think he's wondering how it can be 11/9. I think this is because we use different tools to get spigot's and the overall system's CPU usage.
The server has 2 cores, and to some tools the maximum CPU usage is 200%.

Please Log in to post a reply.