OpenSMO now running on MySQL!

News about StepMania Online.
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable
User avatar
Cube
Site Admin
Posts: 354
Joined: Mon Sep 24, 2012 10:18 am
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

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
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

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: 354
Joined: Mon Sep 24, 2012 10:18 am
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

Re: OpenSMO now running on MySQL!

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


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...
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

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.

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
developer

User avatar
Cube
Site Admin
Posts: 354
Joined: Mon Sep 24, 2012 10:18 am
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

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
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

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
developer


[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

Return to “StepMania Online News”

Who is online

Users browsing this forum: No registered users and 6 guests