Databases V2 Migration

2 years ago

Hey all,

We're improving how databases work on Railway, and a migration to the new version will be required by 31st Jan, 2024.

Here's what you need to know:

  • Databases in its current form will become a legacy feature on 31st Jan, 2024. All databases will become regular Railway services with a volume attached.

  • You are required to migrate if you see a "Migrate your plugin to a V2 database" message when you click on your database in your project.

  • Migration is a one-click process. When you start the migration, we'll temporarily freeze your database and copy your data over to the new service.

  • There is an expected downtime of under 10 minutes, longer if your database is larger (>10GB in size).

  • We do not destroy data under any circumstances: even if the migration fails for any reason, all your data is intact.

Please follow the Migration Guide to get started. To learn more, refer to our blog post "The Future of Databases is Services".

We'll be in here if you have any questions!

Solved

18 Replies

shashank2000
TRIAL

2 years ago

Hi! I get this error when trying to migrate:

Could not load the default credentials. Browse to https://cloud.google.com/docs/authentication/getting-started for more information.

Do you know what the issue might be?


shashank2000
TRIAL

2 years ago

sorry seems like it didn't render properly above! Here's the error message, on the first step
Could not load the default credentials. Browse to https://cloud.google.com/docs/authentication/getting-started for more information.


2 years ago

sorry seems like it didn't render properly above! Here's the error message, on the first step
Could not load the default credentials. Browse to https://cloud.google.com/docs/authentication/getting-started for more information.

Sorry about this! We're looking into it


jitterted
HOBBY

2 years ago

I only have 1 database and I thought I had already migrated it. Did I miss something? Can Railway tell me which specific database needs to be migrated?


2 years ago

I only have 1 database and I thought I had already migrated it. Did I miss something? Can Railway tell me which specific database needs to be migrated?

If you've migrated, you can ignore this.

Out of curiosity did you migrate using the one-click button?


jitterted
HOBBY

2 years ago

OK, because I got two emails about needing to migrate database, so was concerned.

And yes, I used the one-click and it worked just fine.


alejandrotorresdominguez
TRIAL

2 years ago

I migrated my postgreSQL database using the migrate button, everything worked fine, but now my strapi dervice don't build. The DB url is correct and is the only change made.


prdispatch
HOBBY

2 years ago

Hi there, just wanted to double check we will be fine as long as we do this by Jan 31? Will be away on holiday and will have time to do this only in mid-Jan.


geepytechnologies
TRIAL

2 years ago

I migrated my MySQL database to MySQL legacy, but when I click on connect so as to reveal my connection details, I get an Application error: client-side exception has occurred


Hello folks, apologies for the late response here - this thread was accidentally buried under some latest forum changes. Sorry!

I migrated my postgreSQL database using the migrate button, everything worked fine, but now my strapi dervice don't build. The DB url is correct and is the only change made.

@alejandrotorresdominguez Can you start a new thread in Questions and include your build logs please? This sounds unrelated to the migration itself, and likely a Strapi error from an outdated template from what other users are reporting.

Hi there, just wanted to double check we will be fine as long as we do this by Jan 31? Will be away on holiday and will have time to do this only in mid-Jan.

@cleanpower Yep! Do it as soon as you can.

I migrated my MySQL database to MySQL legacy, but when I click on connect so as to reveal my connection details, I get an Application error: client-side exception has occurred

@geepytechnologies Is this still happening for you? Seems like a momentary error on our end - we don't have additional reports of this at the moment.


kobbya
HOBBY

a year ago

I've been prompted to migrate the MongoDB plugin for a project to a V2 database. In the service settings, I see a button to "Learn more", but not to start the one-click migration process.

In the information modal it says "Admin access is required to migrate". Must I be the project owner to perform this action (I am an editor)?


a year ago

That's correct, only the creator or an admin can perform the migration


kobbya
HOBBY

a year ago

Is an admin different from an editor? When adding a member to a project I can see options to assign “Can edit” or “Can view”. Is “admin” scope only available for pro/enterprise?


a year ago

That's also correct, on the hobby project the max permissions you can give to a user would be edit

Pro and above can give their members admin permissions for the projects in the team account


jpbongiovanni
HOBBY

a year ago

Hello,
two things,

  1. I migrated my db but still got an email notifying me that one or more of my projects still needs to be migrated. Is this a generic email sent to everyone? or is it only sent to those the system sees haven't migrated?

  2. After the migration is complete does the freeze effect any further pushes to the database? I can't seem to update any of my tables. Do I need to change some of the settings in my project?

Thanks!


a year ago

  1. It should be a targeted email, maybe you still have some migrated databases kicking around that you haven't deleted yet?

  2. I'm not sure what you mean by "freeze", nothing is "froze" until after January 31st. Try using a database client like dbgate instead of the data tab.


cromos92
PRO

a year ago

hello I already performed the database migration and completed the process but the new database appears without a database
how i can get back up i really need it


Closing this out as the database migration period is over. Please create a new thread if you have further questions!


Status changed to Solved railway[bot] over 1 year ago


Databases V2 Migration - Railway Help Station