Support

Home Forums Event Espresso Premium EE3 to EE4 migrate issue

EE3 to EE4 migrate issue

Posted: May 22, 2016 at 3:53 pm

Viewing 12 reply threads


Elizabeth

May 22, 2016 at 3:53 pm

See below. Does this look normal? It keeps saying its updating a ton of shortcodes.

1% (4804/261691)

Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes
Migrated 50 records successfully during Shortcodes


Elizabeth

May 22, 2016 at 3:55 pm

It is moving soooooo slow. I need to have everything back up tonight.


Elizabeth

May 22, 2016 at 3:58 pm

It’s on a ton of these:

Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events
Migrated 1 records successfully during Events


Elizabeth

May 22, 2016 at 4:22 pm

After 30 minutes 2% (6292/261691)


Tony

  • Support Staff

May 23, 2016 at 4:04 am

Hi there,

Each site is different as people setup their events differently, so in terms of ‘normal’ the above may well be. It depends on the amount of events, registration etc that need to be migrated and how much your server can cope with.

The default ‘step size’ for each migration is 50, this is the amount of rows that are updated within the database within each step, however EE will also attempt to throttle the steps if the queries start to take longer amount of time than expected (to prevent timeouts)

We recommend testing the migration on a development copy of the site to see how long it will take on your site before running it live as it gives you an idea of much downtime you will have on the live site. You then run the migration on the live site at a convenient time or migrate the dev site to live (although it depends on the use case if you can do this)

Did you finish the migration and EE4 is now up and running?


Elizabeth

May 23, 2016 at 5:36 am

I had to stop it, it would not have finished in time for today at the rate it was going. It was doing 1 update per second and there were over 200,000. I don’t know what to do now.


Elizabeth

May 23, 2016 at 7:04 am

The database for the entire site is only 12MB. They only do like 35 events per month.


Elizabeth

May 23, 2016 at 1:06 pm

At that rate it would take 74 hours.


Tony

  • Support Staff

May 24, 2016 at 4:39 am

What kind of server is the site running on?

Check how much memory is available on the site, you’ll want at least 96MB but more if available.

As mentioned if EE detects that the queries are taking longer than expected it will drop down the step size to prevent timeouts. If your server is under load or does not have enough resources then the migration is going to take longer.

Do you have a development server you can copy the site to?

You could use something like Duplicator to copy the site over to the other server and run the migration there.


Elizabeth

May 24, 2016 at 5:22 am

The problem with that is people are still registering for classes. How can I do the upgrade on a dev server and also merge over the new people registering after it is has updated?


Tony

  • Support Staff

May 24, 2016 at 6:24 am

You can’t, not easily.

You would need to put the live site into maintenance mode to prevent further registrations, migrate the site, run the EE4 migrations and then migrate the data back to live.

The reason for testing on a dev server (which should be different) before attempting this is to see if the migration runs quicker on that server. If so then the above will likely be your best method to migrate the site.

Note before making any changes, make sure you have a good working backup of the current site.


Elizabeth

May 24, 2016 at 6:28 am

They cannot be in maintenance mode for 3 days.


Tony

  • Support Staff

May 24, 2016 at 7:22 am

Yes, I understand that which is why I said test on another server and see if it migrates quicker.

The steps would be.

Create a clone of the site as it is now (for example using Duplicator) and install that on another server, run the migrations there. You leaving the site active for now as your testing to make sure you can run the migrations within a reasonable time frame on another server.

Monitor how long it takes on the dev server and confirm if the migration works as expected, so your testing the migration away from the live site, using all of the live data, to confirm that it works, and does so within a reasonable amount of time.

The dev site should NOT be the same server the live site is on and should have enough resources available to be able to run the migrations. As mentioned before I’d recommend at least 96MB.

If the migration runs fine on the dev site and you’ve tested and confirmed all works well, you have an idea of how long the migration will take.

Then when ready to migrate the live site, put the live site into maintenance mode.

Copy the live site to another instance on the dev server (you will need to migrate the database to run on the dev site).

Run the migrations (you now know roughly how long they will take because you’ve tested this already) and once complete migrate the site back to the live server.

—–

If you prefer to just run the migrations on the live site you can check you have enough memory available on the live site first and retry.

Make sure you backup the site before running the migrations.

—–

Whichever step you chose you can not take live registrations whilst migrating the data as it is not easily transferred from EE3 to EE4 once the migrations have been ran.

Viewing 12 reply threads

The support post ‘EE3 to EE4 migrate issue’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso