On Mon, Nov 27, 2023 at 3:44 PM Mauricio Silveira <[email protected]> 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
