Memcache installed. How to get memcache to work with MySQL?

Hey guys,

We currently have a windows server 2008 iis running the below

Current php version 5.3.3
Current memcache version 1.2.6
Current memcache dll 2.2.7

We are having a issues trying to get memcache to work with mysql. Do we require an additional extension to handle queries. Or are there any additional configurations you can point me to making?

thanks
yashy
LVL 1
YashyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ray PaseurCommented:
Please tell us a little more about the issues.  In particular, can you point us to the PHP.net man page that tells the function descriptions for what you're trying to do?
0
YashyAuthor Commented:
Straight to the point. We have been able to install and configure memcache on our windows server.

However the PHP PECL extension mysqlnd_memcache doesnt seem to have a .dll for PHP.

We are looking for an extension for windows to manage translations of sql queries for memcache.

pecl.php.net/package/mysqlnd_memcache is our source.
0
GaryCommented:
Switch to memcached
Then it is a simple process to store in memory your query results against a key

Example tutorial here on how to set the key in memory and use your sql as an identifier to check against for future queries
http://www.kutukupret.com/2011/05/04/memcached-and-php-caching-mysql-query-result/

I assume you do mean caching the results...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.