Plugin Help MySQL offline

Hello all, I've made a custom plugin that looks for data from the server and sends it to a MySQL database. Some of these data types are related to player events. Because of this, I noticed if the MySQL database crashes or goes offline, the server crashes too since it can no longer complete the player's function.

What my question is, how can I add some code to check if the database is offline, to close the connection and continue logging what's needed to a file instead?

Thanks for the help!

 

@timtower
I already have one. But in the console, it says "last packet sent blablabla" and since I'm sending player chat related things to the database, it stops the whole chat and crashes players.

Any other way around this?

 

@timtower

I already had it like that. Maybe I should surround this with a try and catch and close the connection in a finally {} ?

Code:

    public void content(final Player player, final String text, final Integer type, final String xyz)
    {
        Bukkit.getScheduler().runTaskAsynchronously(this, new Runnable() {
            @Override
            public void run() {
                mysqlMethod(player, text, type, xyz);
            }
        });
    }

 

@timtower

So just create a list, add the content to it, make a delayed task inside the async thread task and call it every x minutes?
What happens if the database is still offline and it tries connecting to it 5 minutes later? Would that not timeout the server again?

 

@timtower
Hmmm. Fair enough. Is there a way I could check if it's back online though so I can dump the saved and delayed data from the list once it finds a connection again?