OpenSMO now running on MySQL!

News about StepMania Online.
User avatar
Cube
Site Admin
Posts: 353
Joined: Mon Sep 24, 2012 10:18 am

OpenSMO now running on MySQL!

Postby Cube » Fri Nov 09, 2012 6:18 pm

I finished porting over the OpenSMO code to run on MySQL instead of SQlite.

We are currently trying to stress test it to make sure all the changes are working correctly. After we are happy with it we will migrate all database over to the fancy new MySQL Database.

Now running on the main server and site!

Charlo
Posts: 11
Joined: Thu Nov 01, 2012 1:32 pm

Re: OpenSMO now running on MySQL!

Postby Charlo » Sat Nov 10, 2012 5:18 am

Is there a reason why SQLite was chosen in the first place? I've rarely seen it used; MySQL is far and away the most popular DB for open-source stuff.

User avatar
Izzy
Moderator
Posts: 531
Joined: Thu Sep 27, 2012 3:03 pm
Location: Leawood, Kansas
Contact:

Re: OpenSMO now running on MySQL!

Postby Izzy » Sat Nov 10, 2012 10:18 am

Because it is easier to implement and integrate into c#. The issues we were having didn't make a lot of sense in the first place so it is still kind of strange that it was having problems.

User avatar
Cube
Site Admin
Posts: 353
Joined: Mon Sep 24, 2012 10:18 am

Re: OpenSMO now running on MySQL!

Postby Cube » Sat Nov 10, 2012 2:26 pm

Charlo wrote:Is there a reason why SQLite was chosen in the first place? I've rarely seen it used; MySQL is far and away the most popular DB for open-source stuff.


OpenSMO was originally developed as a standalone project. So Sqlite was a better option at the time. I dont think he expected it to get this big :)

User avatar
owenviau1
Posts: 136
Joined: Sat Nov 03, 2012 1:42 pm
Location: East of Canada
Contact:

Re: OpenSMO now running on MySQL!

Postby owenviau1 » Sat Nov 10, 2012 2:26 pm

ok kool :)
Image

User avatar
crimsoncarnage
Posts: 12
Joined: Sat Oct 27, 2012 5:15 pm
Location: Somewhere far away...

Re: OpenSMO now running on MySQL!

Postby crimsoncarnage » Sun Nov 11, 2012 1:31 pm

I was wondering whether or not a new version of OpenSMO would be released (1.05) that would change to MySQL.
Image

User avatar
Angelo
Posts: 72
Joined: Sat Oct 06, 2012 4:31 am
Location: The Netherlands
Contact:

Re: OpenSMO now running on MySQL!

Postby Angelo » Mon Nov 12, 2012 12:48 pm

Sqlite was chosen because indeed it was standalone, and thus much easier to put on any kind of machine. I never thought that a big project like SMO.net would come to exist from it.. :)

I saw a pull request on Github that's apparantly what you're running now. Great, but it has a lot of errors and possible security holes. I recommend you don't run this version until you get the latest.
- Angelo
OpenSMO developer (I do this in my spare time, donations are very much appreciated!)

User avatar
Cube
Site Admin
Posts: 353
Joined: Mon Sep 24, 2012 10:18 am

Re: OpenSMO now running on MySQL!

Postby Cube » Tue Nov 13, 2012 3:01 pm

Thanks for the merge, I fixed the security issues, which I blame on being tired :)

I have a few more updates I have not pushed yet, and right now we are seeing some crazy CPU usage we are trying to debug, I will make a branch of the current codebase if you want to take a look.

Update: https://github.com/concubidated/OpenSMO/tree/smo.net

houkouonchi
Site Admin
Posts: 156
Joined: Sun Sep 16, 2012 1:12 pm

Re: OpenSMO now running on MySQL!

Postby houkouonchi » Tue Nov 13, 2012 7:24 pm

The CPU usage had to do with some of the webchat code that was copied over from a newer commit. Reveriting this and CPU usage is finally back to normal which means the site/server should *finally* be atleast as stable as sqlite was before it was running into the corruption problems (but likely more stable).

User avatar
Angelo
Posts: 72
Joined: Sat Oct 06, 2012 4:31 am
Location: The Netherlands
Contact:

Re: OpenSMO now running on MySQL!

Postby Angelo » Wed Nov 14, 2012 3:52 pm

The webchat code? I don't see why that would cause high CPU usage.
- Angelo
OpenSMO developer (I do this in my spare time, donations are very much appreciated!)


Return to “StepMania Online News”

Who is online

Users browsing this forum: No registered users and 1 guest