xampp mysqli crashes apache

November 18th, 2009 • apache, mysql, php, windows, xampp

Is your XAMPP installation crashing apache when using the mysqli PHP functions on windows? The apache logs are not telling anything even when you have debug mode enabled? Are you getting something like “Faulting application apache.exe, version 2.2.11.0, faulting module ntdll.dll” or “Faulting application apache.exe, version 2.2.11.0, faulting module MSVCR71.dll.” ?

Really? Sure? Well here’s your solution…

Download the most recent version of php_mysqli.dll and place it in <yourxampdir>\php\ext directory.You might want to take a backup of the file you’re replacing in case it doesn’t work…

You can download the php_mysqli.dll righ here or you’ll have to find a recent version for your PHP version yourself.

Multiple memcache instances/servers on windows

May 11th, 2009 • 2 comments memcache, memcached, php, windows

Setting up memcache on windows is like taking candy from a baby. You can find all the information and the binaries for memcache at http://jehiah.cz/projects/memcached-win32/ . Note that these binaries will also work for x64 based windows.

A little trickier is to set up multiple instances of memcached on your windows machine. Basically you have to install the same memcache executable as many times as you want servers.

Installing memcache from the command line is simple:

sc create  "Memcached11211" binPath= "E:\webserver\memcached.exe -d runservice -p 11211 -m 128"  DisplayName= "Memcached11211" start= auto

Thus, for multiple instances this will be:

sc create  "Memcached11211" binPath= "E:\webserver\memcached.exe -d runservice -p 11211 -m 15"  DisplayName= "Memcached11211" start= auto
sc create  "Memcached11212" binPath= "E:\webserver\memcached.exe -d runservice -p 11212 -m 15"  DisplayName= "Memcached11212" start= auto
sc create  "Memcached11213" binPath= "E:\webserver\memcached.exe -d runservice -p 11213 -m 15"  DisplayName= "Memcached11213" start= auto
sc create  "Memcached11214" binPath= "E:\webserver\memcached.exe -d runservice -p 11214 -m 15"  DisplayName= "Memcached11214" start= auto
sc create  "Memcached11215" binPath= "E:\webserver\memcached.exe -d runservice -p 11215 -m 15"  DisplayName= "Memcached11215" start= auto
sc create  "Memcached11216" binPath= "E:\webserver\memcached.exe -d runservice -p 11216 -m 15"  DisplayName= "Memcached11216" start= auto
sc create  "Memcached11217" binPath= "E:\webserver\memcached.exe -d runservice -p 11217 -m 15"  DisplayName= "Memcached11217" start= auto
sc create  "Memcached11218" binPath= "E:\webserver\memcached.exe -d runservice -p 11218 -m 15"  DisplayName= "Memcached11218" start= auto
sc create  "Memcached11219" binPath= "E:\webserver\memcached.exe -d runservice -p 11219 -m 15"  DisplayName= "Memcached11219" start= auto
sc create  "Memcached11220" binPath= "E:\webserver\memcached.exe -d runservice -p 11220 -m 15"  DisplayName= "Memcached11220" start= auto
sc create  "Memcached11221" binPath= "E:\webserver\memcached.exe -d runservice -p 11221 -m 15"  DisplayName= "Memcached11221" start= auto
sc create  "Memcached11222" binPath= "E:\webserver\memcached.exe -d runservice -p 11222 -m 15"  DisplayName= "Memcached11222" start= auto

As you can see from the example above, you have to choose a different port for each memcache instance you are running.