Multiple Instances of BE on same database

Topics: Business Logic Layer
May 8, 2008 at 12:18 PM
Hey All,

Am fairly new to blog engine but its a great piece of kit.

I'm currently implementing it for a client and they want two blogs on the same hosting account using the same sql 2005 database.

They are hosting on fasthosts, with only one sql database.

Can anyone help?

Thanks

Tom
May 8, 2008 at 1:17 PM
This feature is not supported in 1.3. In recent check-ins, there is an XML Multi Blog Provider (XmlMultiBlogProvider.cs) and there are past threads about adding a prefix setting (SqlDatabaseTablePrefix) for the SQL provider (http://www.codeplex.com/blogengine/Thread/List.aspx?SearchText=table%20prefix and http://www.codeplex.com/blogengine/WorkItem/View.aspx?WorkItemId=5226, http://www.codeplex.com/blogengine/Thread/View.aspx?ThreadId=25390 is also relevant), but it seems it hasn't made it into the codebase yet... You could always make the changes yourself in MSSQLBlogProvider.cs (just search for "be_") - and you'd have to modify the SQL script (or create/rename the tables manually).

In madskristensen's laundry list for 1.4 (http://blog.madskristensen.dk/post/New-features-in-the-next-BlogEngineNET.aspx) there is mention that 1.4 might have a Database factory provider, but I haven't seen anything about it in (my few dives into) the source code...
May 22, 2008 at 7:53 PM
i'm having the same problem as tbathgate.
i have two instances of BE, on two load balanced servers. i've got the both setup to use the same DB on a seperate server.
when i post on server 1, i can only see the post from server 1's instance of blog engine. same goes with server 2.
but if i look at the DB i can see all the information for all posts made from both instances.
what gives?
Jul 14, 2008 at 10:08 PM
Hey WestdesertGuy were you able to figure out the issue?? I having the same problem...