Maintaining Dev & Production Sites
Does anyone out there have experience with maintaining a Drupal production site on a hosted Linux platform, but your internal development site is on WAMP? I'm trying to use the Backup and Migrate module (backup_migrate) to do backups from the production site (1&1 Hosting on Linux) to my local server (XAMPP on Windows 2003 Server). What I've run into is that if you are using images within a node using TinyMCE editor and WYSIWYG, are different paths on the different platforms. The XAMPP side has an extra path in it probably because of the way that the htocs folder is setup under Apache on Windows. When I upload to production (Linux), no nodes with images appear, and I have to go in and remove that path and then the image appears.
I'm hoping there's another workaround or setting I can do so that these will be in sync. I know I could set up a local Linux server and solve it that way, but I just don't have the time now to do all that installing. Hope there's an easier way....
Set up vhosts on WAMP
I assume the path difference is because your WAMP sites are hosted under localhost? (eg. http://localhost/site1/, http://localhost/site2/, etc)
You can fix this by setting up virtual hosts for each site, so you can use http://site1.local/, http://site2.local/, etc to access your sites instead. This should fix the path issue.
You'll need to:
I'm using this workflow myself so let me know if you need any more assistance to get it set up.
Edit: Adding example
<VirtualHost *:80> DocumentRoot "C:\Clients\GarethSPrice.com\htdocs" ServerName garethsprice.local # Keep the logs neat and tidy (optional) ErrorLog "C:\Clients\GarethSPrice.com\htlogs\error.log" CustomLog "C:\Clients\GarethSPrice.com\htlogs\access.log" common </VirtualHost>--
Orlando, FL Web Developer | http://www.garethsprice.com/
Thanks!
I'm sure this is exactly what I was looking for. I just need a little time to sit down and do this reconfiguration. So I'll be in touch I have any issues.
Thanks again,
JCL
Xampp Performance
May I ask how your performance is on your Xampp setup? Mine is starting to crawl with some heavy Drupal development. Every time I save a View, it takes minutes, and then even my browser (Firefox) is delayed in responding for my next click. I've tried on a faster machine with more RAM, and it's even worse! I don't know whether it's my internal network, Windows domain, or Xampp itself. Just wondering if you have any pointers.
JCL
I'm using Zend Server
I'm using Zend Server (Zend's version of the *AMP stack for Windows) and the performance is also terrible for Drupal sites. Just about good enough where it's not killing my productivity for development, hence not looking into it yet.
I assumed it was just my creaky old IBM T42, interesting to know that it's not. Drupal does a ton of include/requires in addition to heavy use of MySQL - perhaps all that filesystem thrashing is the choke point.
I will hook up xdebug and do a bit of profiling to see where the performance bottleneck is.
--
Orlando, FL Web Developer | http://www.garethsprice.com/
Initial profiling results
My initial profiling with xdebug/WinCacheGrind seem to indicate that the PHP process which runs the Drupal instance isn't the problem here - output is generated in an acceptable range (2ms for a static Page node, 300ms for a large un-cached user profile with captcha).
Still, the latter page takes at least 2-3 seconds to show up. Figured it might be the theme rendering, but a "wget" of the page still takes around 3 seconds to generate the page.
Odd. Will investigate more. Maybe there's something we can do in the php.ini, MySQL configuration or Windows' disk caching to speed things up.
Any other ideas, anyone?
--
Orlando, FL Web Developer | http://www.garethsprice.com/
myISAM vs. InnoDB
Done some research and apparently myISAM is the default storage engine for mySQL. At least it is on my installation of Xammp. More digging around I found some references to tweaking the mySQL.ini settings but nothing specific for Windows. I'm more convinced now that the issue is either my Fire Fox or my XP setup. I've noticed similar "hiccups" with other sites. I even tried Google's Chrome but didn't go far because it was not rendering Lightbox windows correctly.
Time for a Mac and Linux server :-)
JCL
just a wild guess
if you are using vista this "may" help
Start > Control Panel > View Network Status and tasks (under Network and Internet)
Chose Manage Network Connections on the left side menu
Right click Local Area Connection and choose Properties
In the pop-up box, uncheck the following:
Internt Protocol Version 6 (TCP/IPv6)
Click OK and then RESTART your computer..
Joe Moraca
http://moraca.org
Performance