Can one instance of Mojo Portal run across multiple databases?

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
12/8/2010 7:41:42 AM
Gravatar
Total Posts 139
"All that is gold does not glitter, not all those who wander are lost;" --J.R.R. Tolkien

Can one instance of Mojo Portal run across multiple databases?

Hi folks,

I just had a quick question.  I might end up using MySQL when the time comes, but I was just curious, since Mojo portal is more commonly run with SQL Server as the back end, and I most certainly can't afford anything greater than the express version right now, but I know that the R2 version supports up to 10 GB of storage per database.  How does this effect Mojo portal?  Can I create another database to use when one fills up without ruining any sites?  Thanks folks. 

Katherine

12/8/2010 9:51:27 AM
Gravatar
Total Posts 18439

Re: Can one instance of Mojo Portal run across multiple databases?

no. It uses one database per installation and there is no easy way to migrate from one db platform to another.

12/8/2010 10:13:45 AM
Gravatar
Total Posts 139
"All that is gold does not glitter, not all those who wander are lost;" --J.R.R. Tolkien

Re: Can one instance of Mojo Portal run across multiple databases?

Then in terms of pros/cons, what are the pros and cons in Mojo portal terms for running either database for your site on Windows?  Well, besides the obvious thing that MySQL's free?  And considering you work with the different versions of SQL Server 2008 R2, does the express version have any value to it in a live environment?  Thanks for any filling in. 

12/8/2010 10:25:12 AM
Gravatar
Total Posts 18439

Re: Can one instance of Mojo Portal run across multiple databases?

SQLExpress supports databases up to 4GB which is much larger than most web sites will ever need.

Most hosts provide full MS SQL not SQLExpress so typically you have no limit anyway in a hosted environment, other than limits the host may put on storage limits.

12/8/2010 10:41:48 AM
Gravatar
Total Posts 1204
Proud member of the mojoPortal team

Help support mojoPortal!
Add-on modules

Re: Can one instance of Mojo Portal run across multiple databases?

Hi Katherine, we went through a selection process for the database back end. Our situation is a bit unique, because we have an Oracle site license, so buying a separate license of SQL Server just for our web database didn't make much sense, although we did look into pricing.

We ultimately chose to use MySQL for our mojoPortal production database. SQL Server Express 2008 R2 has expanded the maximum disk space available to the database from 4 GB to 10 GB (which is WAY more than we needed), but it's also limited to 1 CPU, and 1 GB of RAM, and we didn't want to be constrained in that way.

I don't think there are any cons to mojoPortal running on MySQL. It's working great for us, and Joe has said that he uses it as well. If you go with MySQL, I'd also recommend you get HeidiSQL for database management. It's an excellent Windows open source solution.

Jamie

12/8/2010 12:29:06 PM
Gravatar
Total Posts 2202

Re: Can one instance of Mojo Portal run across multiple databases?

Hello all,

I run a mix of mySQL and MSSQL mojoPortal sites and I haven't noticed any difference in performance of those sites. 

Also, HeidiSQL is awesome! I used to use SQLyog but haven't since the first time I opened HeidiSQL

-Joe D.

12/8/2010 12:35:49 PM
Gravatar
Total Posts 139
"All that is gold does not glitter, not all those who wander are lost;" --J.R.R. Tolkien

Re: Can one instance of Mojo Portal run across multiple databases?

Thanks guys.  I'll probably end up going the mySQl route then.  But just as a curiosity, two things actually, one is why, if Mojo Portal doesn't even have support for Oracle, do you have a license for something you can't use?  and the other is just say hypothetically, if I am running everything off of a Dell T110 tower server which had 8 gigs of ram in it with SQL Server express, SQL Server Express R2 can only use one of those CPUs, and one gig of ram, would that kill the site?  oh, oops.  Correction.  Three things.  LOL.  I'd also like to know, when installing Mojo from Microsoft's web app gallery, does it recognize the presence of MySQL?  Thanks and sorry for the never-ending bombardment of questions. 

12/8/2010 12:41:35 PM
Gravatar
Total Posts 2202

Re: Can one instance of Mojo Portal run across multiple databases?

Hi Katherine,

As far as your server goes, the site would run just fine, SQL Server just wouldn't use the additional resources.

The version of mojoPortal installed by the Web App Gallery is for SQL Server only, not mySQL so you'll have to download the mySQL mojoPortal release package and the mySQL mojoPortal Data Layer from codeplex. You can still use web deploy options available in IIS 7+ with the packages downloaded directly from codeplex.

HTH,
Joe D.

12/8/2010 12:47:44 PM
Gravatar
Total Posts 1204
Proud member of the mojoPortal team

Help support mojoPortal!
Add-on modules

Re: Can one instance of Mojo Portal run across multiple databases?

Well, we got our site license for Oracle back around 1995, long before mojoPortal was even a gleam in Joe's eye. We use it for our enterprise HRMS, Financials, Utility Billing, and other miscellaneous database needs. We would have definitely used Oracle for mojoPortal if it were supported, but Joe has his hands full with all of the data layers he's already juggling.

And like Joe said, using MySQL with mojoPortal requires a little bit of extra work to get the data layer in place. Once you're used to doing it, though, it's really not a big deal.

Jamie

12/8/2010 12:51:14 PM
Gravatar
Total Posts 139
"All that is gold does not glitter, not all those who wander are lost;" --J.R.R. Tolkien

Re: Can one instance of Mojo Portal run across multiple databases?

 Thanks for helping me decide my future.  @Joe D, how did the link fixing go?  Were you able to get in there?  Was the editor just being stupid?

12/8/2010 4:16:52 PM
Gravatar
Total Posts 139
"All that is gold does not glitter, not all those who wander are lost;" --J.R.R. Tolkien

Re: Can one instance of Mojo Portal run across multiple databases?

oops.  One more thing though.  You said that you use MySQL so that you don't have to deal with CPU or ram constraints.  How is the best way to calculate it since SQL Server is ultimately easier to deal with, and since it's integrated right in, if I have a small site and a small community, does the one CPU and one gig Ram really matter in the end?  You tell me that it would run fine, and that SQl Server wouldn't use the other resources.  And not to mention, in the context of Mojo Portal, what is stored in the database?  Is it just the user names and passwords of the users, or is it like everything on the site, or what?  Thanks. 

12/8/2010 4:31:49 PM
Gravatar
Total Posts 2202

Re: Can one instance of Mojo Portal run across multiple databases?

Hi Katherine,

Honestly, until your site grows to thousands of users and visitors, the limits of SQL Server Express will not even be noticed.

mojoPortal stores pretty much everything except images and other BLOBs in the database. All content, pages, settings, users, passwords are in the database. One module that may cause some confusion is the Shared Files Module, the files you upload using that module are stored in the filesystem but all of the metadata (version history, description, downloads, etc...) for the files are stored in database.

HTH,
Joe D.

12/8/2010 6:38:56 PM
Gravatar
Total Posts 139
"All that is gold does not glitter, not all those who wander are lost;" --J.R.R. Tolkien

Re: Can one instance of Mojo Portal run across multiple databases?

Great information and education!  Forgive me for being so curious. 

You must sign in to post in the forums. This thread is closed to new posts.