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!
OpenSMO now running on MySQL!
-
- 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!
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.
Re: OpenSMO now running on MySQL!
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.
- 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!
I was wondering whether or not a new version of OpenSMO would be released (1.05) that would change to MySQL.
Re: OpenSMO now running on MySQL!
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.

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
developer
- 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!
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

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
-
- 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!
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).
Re: OpenSMO now running on MySQL!
The webchat code? I don't see why that would cause high CPU usage.
- Angelo
developer
developer
Return to “StepMania Online News”
Who is online
Users browsing this forum: No registered users and 1 guest