Migration scenarios, when installing on an existing community/ domain.?

[Queth (Q)]

hello,

I have fallen in love with discourse as my new community solution.

Before installing, and getting ahead of myself, I need to know what is possible concerning migration.

current situation:

I have an existing community, i have a 3 instances of PHPBB 2 (french, dutch, english users). 3 databases, biggest is 800mb. 30k users.

current forum is set up under forum.mysite.com and mysite.com/forum

my site also has some static HTML content.

hosted on VPS (apache, cpanel and such)

to be situation:

• 1 instance of discourse serving all languages. all current language forums imported in discourse in separate archives.

• keeping the same domain.

How can I do this with as little downtime as possible and keeping the same URL for the forum? Is it possible to import 3 databases into 1 forum?

what are possible scenarios?

I will host discourse myself as I have no budget for the hosted version. and that means i will probably need to move to digitalocean as well?

basically i need to know what the smartest way is to approach this.

thank you in advance for any help !

[itsbhanusharma (Bhanu Sharma)]

@Queth

1 instance of discourse serving all languages. all current language forums imported in discourse in separate archives.

I’ve never seen multilingual forums but there is no reason for it not to work albeit the core language can be only one for the menus/buttons etc.

@Queth

keeping the same domain.

Totally possible in multiple ways:

1. Configure on a separate subdomain and import everything there, test it then if all is good, move to the preferred (sub)domain.

2. Dump all data from existing forum(s), set up your discourse at your subdomain of choice and import the data using the existing importers.

There are problems though. I have not done an import myself and have no idea as to how they handle redundancies in terms of users, content and media.

@Queth

Is it possible to import 3 databases into 1 forum?

Only someone from team can answer that.

Any ideas @pfaffman??

@Queth

that means i will probably need to move to digitalocean as well?

Not really, You are good to go with any hosting provider as long as they offer you relatively modern specs and root access.

I don’t know about how to merge 3 forums together but for all the other questions, I’ve tried to answer to the best of my knowledge.

[Cameron_D]

@Queth

Is it possible to import 3 databases into 1 forum?

It should be with some changes to the importer script so it can differentiate between the different forums, otherwise when you start the second import all the posts from topic ID X will end up in the topic with the same ID from the first one imported.

@itsbhanusharma

albeit the core language can be only one for the menus/buttons etc.

There is an option somewhere that will set the interface language to whatever the user’s browser locale is set to, which would probably be useful in this scenario.

[pfaffman (Jay Pfaffman)]

@itsbhanusharma

Only someone from team can answer that. Any ideas @pfaffman??

Well, I’m not team, but I do make much of my living from imports.

As @Cameron_D said, yes, you can import multiple databases to a single import. You need to do some work to see that each forum has unique user/post/etc IDs and some additional work if there are any users that are members of multiple fora.

[itsbhanusharma (Bhanu Sharma)]

@Cameron_D

There is an option somewhere that will set the interface language to whatever the user’s browser locale is set

I remember that is still in beta and highly unreliable that’s why I’m a bit shy to recommend it.
There is one thing though! Can the locale for all the users in an import be set or is it just a discourse thing?

[pfaffman (Jay Pfaffman)]

Since each database is a single language it shouldn’t be difficult to add the language user setting to the import.

[Queth (Q)]

thank you for all the help and explanation regarding the languages!

i am still hesitant about keeping the same domain.

lets say i want 2 instances of discourse, one to test, and one for production. that way i can keep a testing board next to the live board.

how would I go setting up that? is that possible?

edit: also, my VPS has apache, is it still possible to get discourse on that?
edit 2: with searching found that it should be possible, however still my question stands about 2 discourse instances

thank you once again!

[pfaffman (Jay Pfaffman)]

@Queth

my VPS has apache, is it still possible to get discourse on that?

Set up Discourse on a server with existing Apache sites

It’s not as daunting as it sounds! While this may sound a bit intimidating at first, it’s really not all that bad. You basically need to do two things: Install HAProxy (or an alternative) which will take over port 80 and then divert your Discourse traffic to your docker container, and all your other sites to your usual Apache set-up. Let Apache know which port to listen for. While this is only a rough guide, it should do a good job of pointing you in the right direction. Let’s get star…

@Queth

lets say i want 2 instances of discourse, one to test, and one for production

It’s easiest to just set up another server, but you could use the same principle in the above link to have multiple Discourse instances on a single server with Apache reverse proxying both.