Posted by lsiden on September 13, 2010 at 4:43pm
I am preparing to migrate a site with over 19 million nodes and a 2500 term taxonomy vocabulaty from Drupal 5 to 6. While reading up, I have discovered Pressflow and want to consider it. How do I proceed with the upgrade? Can I use the same strategy that I and others have used to migrate sites from Drupal 5 to 6, copying the database, then replacing the Drupal core files with Pressflow's core files? Or will that create a hopelessly broken site to pick up pieces for?

Comments
upgrade to d6 then to
upgrade to d6 then to pressflow?
A couple of ideas.
do a quick Diff of pressflow and vanilla and you'll see what the differences are. From what i remember there are very few schema changes, so you very well might be ok converting from d5 to d6 pressflow without issue, doing the diff will give a quick reference of what is changed and will help you overall grok problems and be able to isolate them as pressflow or drupal problems.
I would imagine the most difficult part of the transition will be CCK if the upgrade paths don't work for you consider using http://drupal.org/project/migrate It might be simpler to treat the d5 site as something totally foreign instead of troubleshooting the upgrade.
Drupal and Pressflow are API
Drupal and Pressflow are API equivalent (as long as you are not calling private functions - the ones prepended with an underscore). They are also schema equivalent. But as @mizru notes doing a diff between them can teach you a lot.
--
Dave Hansen-Lange
Director of Technical Strategy, Advomatic.com
Pronouns: he/him/his
Thanks to @mizru and @dalin
Thanks to @mizru and @dalin for your input. I've already gone ahead with the upgrade. It's been a bear, mostly because of (a) the length of time it takes to reload the database, and (b) the time it takes to drop and create each index - done by mySQL as inefficiently as possible (http://lists.mysql.com/mysql/202489).
I didn't create this app; I inherited it. I noticed that while most of the tables are myISAM, a handful are innoDB. This suggests to me that the previous developers (or their database admin) was aware of the differences between myISAM and innoDB and consciously chose to use a mixed strategy that he or she considered optimal. Since this is the first time in my long career as a developer that I've had to dabble in database optimization and performance, I'm giving them the benefit of a doubt.
So with the exception of all the "cache_" tables, which I've converted to innoDB to allow concurrent reads and writes, I'm leaving everything else as my predecessors set it up - at least until I have compelling evidence that it will pay to do otherwise.
Since PressFlow is optimized for innoDB, that pretty much precludes PressFlow for now. I'm betting that there will still be oportunities for database and PHP optimization.
Test It
Set up a cloned environment. Switch the code base from Drupal to Pressflow. After D5 -> D6 of course. I've done this a few times and it was a drop-in setup. There's a few tweaks you can do to get the most out of it but none of it is essential.
Michael Lustfield
Ubuntu Member, Nginx Hacker
Views stops working after Pressflow drop in
Hi: I have been trying to upgrade a site from Acquia Drupal 6.20 to Pressflow 6.20. My first approach was to just delete and replace the core Drupal modules with those from the Pressflow distribution 6.20.97.
The site comes up but then when I run an update I get an odd looking update screen with a bunch of select variables rather than the normal screen. It appears to be running an update successfully however. When finished, I can load my site BUT all my Views have vanished.
So, I flushed caches and checked permissions after rebuilding them and it does not appear to be that. I can see the Views UI and all my Views are listed there. But when I run a preview of any of them nothing is returned by the preview. And no View appears in the various blocks and pages where they are supposed to occur.
I have repeated all this several times and get the same result. I cant find any helpful tips in the Drupal sites.
My server is an Acquia dev cloud instance. It says it is running MySql 5.0.51a and PHP 5.2.4-2ubuntu5.14
In case it is relevant I have kept the folder called Acquia in the modules folder, where it contains various contributed modules from the Acquia distribution that are in use. In theory that would be better in the sites/all/modules location but I am not sure how to move it without screwing up the database.
I would really welcome any ideas or suggestions.
Create own thread
Generally when you have a new question, it is considered best practice to create your own thread rather than piggy-backing on an existing one about a different topic.
That said, pressflow is a drop-in replacement for Drupal. What that means is that if you have two folders named pressflow-6 and drupal-6, all you need to do is move the "sites" subfolder from drupal-6 in to (and overwriting the one in) pressflow-6 and you will be good to go. Only copying the modules directory doesn't cover all of the changes pressflow requires to run.
Thank you
Sorry about posting in the wrong place, but thanks for the reply. I am a newbie.
I think I did what you said in essence. My Drupal installation was in my home folder. I replaced all the other files in there too (from the Pressflow distribution) eg cron.php, index.php etc.
Have I missed something do you think? My reason for posting is that it did not seem to quite work as a drop in and I cannot figure out how to troubleshoot.
There's a chance that
There's a chance that Pressflow is not compatible with a module that you are using. When I switched last week, my site threw fits because Pressflow isn't compatible with Spamicide. Once I disabled that module, everything was ok.
You may be able to find the culprit by looking at your logs under reports.
While pressflow seems to be comptible with 99 percent of the modules out there you may have some trouble with customized modules that are poorly coded.
Since Pressflow doesn't really have any database scheme changes I can't really see how switching to Pressflow would cause a problem in running updates. Are you sure this problem didn't already exist?
Pressflow module incompatibility
Thanks for the above. For anyone who finds this problem, I found that the modules Scribe SEO, and userpoints_reset and user_points_retroactive all caused major problems with my Pressflow upgrade. Balance_tracker seemed possibly suspect too.
Problematic PressFlow modules
This would be an awesome wiki page.
Shadink:
Shadink: https://wiki.fourkitchens.com/display/PF/Modules+that+break+caching,+and...
It's hidden away a little on the fourkitchens wiki, but it exists :)
knaddison blog | Morris Animal Foundation