You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@guacamole.apache.org by Mauricio Silveira <ma...@livreti.com.br.INVALID> on 2023/11/27 20:44:33 UTC

Migrating from PostgreSQL to mySQL and vice-versa

Hi.

Just wondering if there Is any specific instructions I haven't read in 
the DOCs, about migrating between databases?

I currently have my deploy in PostgreSQL, but considering mySQL's 
improved clustering/replication, I'm considering moving all my apps from 
PG to a new mySQL setup.

A quick search didn't return any specific instructions for guacamole.


I intend to use mySQL Workbench Migration Wizard.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@guacamole.apache.org
For additional commands, e-mail: user-help@guacamole.apache.org


Re: Migrating from PostgreSQL to mySQL and vice-versa

Posted by Nick Couchman <vn...@apache.org>.
On Mon, Nov 27, 2023 at 3:44 PM Mauricio Silveira
<ma...@livreti.com.br.invalid> wrote:

> Hi.
>
> Just wondering if there Is any specific instructions I haven't read in
> the DOCs, about migrating between databases?
>
>
No, we don't have any documentation for that.


> I currently have my deploy in PostgreSQL, but considering mySQL's
> improved clustering/replication, I'm considering moving all my apps from
> PG to a new mySQL setup.
>
>
Hmmm...my experience with clustering/replication is the opposite - I've
always thought Postgres did a better job at it and was a bit easier to
configure and maintain. Personal opinion, though :-).


> A quick search didn't return any specific instructions for guacamole.
>
>
> I intend to use mySQL Workbench Migration Wizard.
>
>
The biggest thing is just to make sure that data types get translated as
expected. My advice would be:
* Create the target DB and import the base schema file for it, but *NOT*
the guacadmin SQL file.
* Use the migration tool to copy data from one database to another.
* Handle any exception or data conversion as required. You may have to take
several runs at it to get it just right.

Overall it shouldn't be too terribly complicated - the schema is pretty
small, and most of the data types should match up between the two.

-Nick