CraftConomy

154k Downloads

Sql -> h2

Bennyboy1695 opened this issue ยท 5 comments

commented

hi i was wondering if there was any easy ways that you knew of converting the sql data for your plugin over to h2 data instead. i know theres documentation out there but as your the plugin developer i thought you would be bound to know of an easy and simple conversion tool

commented

You want Mysql => H2 ?

commented

Yeah thats correct and was wondering if you knew of any ways that will make us not lose any data and have minimal downtime while the data is changed over :P

commented

Porting it is rather easy, H2 is simply a SQL database engine very similar to MySQL in terms of SQL commands support. There's nothing in cc3 atm doing the MySQL => H2 conversion since nobody asked for it. People usually do the other way around.

commented

we have been having sql issues with cc3 lately and another plugin and was going to try moving it to a h2 database to see if it solves the issue or at least temporarily fixes them otherwise we wouldn't be moving over

commented

What kind of issues? Probably just a question of configuration / optimization.