store | blogs | forums | twitter | facebook | wiki | mailing lists | downloads | support portal
Atomic Secure Linux
It is currently Thu Apr 24, 2014 8:08 am

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: mysqlnd on php 5.3.6 / plesk 9.5.4 / centos 5.6
Unread postPosted: Fri Jun 17, 2011 10:36 am 
Offline
New Forum User
New Forum User

Joined: Fri Jun 17, 2011 10:23 am
Posts: 4
Location: Netherlands
I'm setting up a new server. It came with Plesk 9.5.3 on CentOS 5.6 and I have successfully upgraded as follows:

- Plesk 9.5.4 (through Plesk itself )
- PHP 5.3.6 ( through http://www.atomicorp.com/wiki/index.php/PHP )
- MySQL 5.1 ( through http://www.atomicorp.com/wiki/index.php/Mysql )

It took some additional steps to get it all working (like dumping / reloading psa database) but I thought it was operational.

I had hoped to be able to use the mysqlnd driver, as a work-in-progress site pretty much requires it. Unfortunately it seems like Atomic's PHP 5.3.6 build does not include it, while I thought it would. phpinfo does not list the mysqlnd driver, and a php code test says the mysqlnd specific functions are not available.

Does Atomic have a PHP build with the mysqlnd driver enabled ? Is it planned ? Or is there someway I can enable this myself ? Do I need to rebuild from source ( that's a bit scary on a Plesk system ) ?

Any help / advice is much appreciated !


Top
 Profile  
 
 Post subject: Re: mysqlnd on php 5.3.6 / plesk 9.5.4 / centos 5.6
Unread postPosted: Fri Jun 17, 2011 12:19 pm 
Offline
New Forum User
New Forum User

Joined: Fri Jun 17, 2011 10:23 am
Posts: 4
Location: Netherlands
For clarification: the mysqlnd driver is a replacement for libmysql. While it offers some speed and efficiency improvements, the major thing is that it supports async queries, which is a must-have with multi-db-server setups. Not many frameworks support it yet, but the one we use does. I do believe mysqlnd is the future :)


Top
 Profile  
 
 Post subject: Re: mysqlnd on php 5.3.6 / plesk 9.5.4 / centos 5.6
Unread postPosted: Fri Jun 17, 2011 12:27 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7780
Location: earth
I see it listed in the .spec:

http://www4.atomicorp.com/channels/source/php/php.spec

If theres something missing in the implementation there shoot me a patch, and I can update the package.


Top
 Profile  
 
 Post subject: Re: mysqlnd on php 5.3.6 / plesk 9.5.4 / centos 5.6
Unread postPosted: Fri Jun 17, 2011 12:46 pm 
Offline
New Forum User
New Forum User

Joined: Fri Jun 17, 2011 10:23 am
Posts: 4
Location: Netherlands
Interesting. Unfortunately, I don't know if I'm reading that spec correctly.

I did however install from the "normal" atomic repo today, and "php -m | grep mysql" gives me:

mysql
mysqli
pdo_mysql

Apparently, this should include mysqlnd in the output as well. Furthermore, "php -i | grep mysql" gives me:

--with-mysql=shared,/usr
--with-mysqli=shared,/usr/lib64/mysql/mysql_config
--with-pdo-mysql=shared,/usr/lib64/mysql/mysql_config

This should be:

--with-mysql=mysqlnd
--with-mysqli=mysqlnd
--with-pdo-mysql=mysqlnd

Have I installed from the wrong repo perhaps (test or bleeding needed) ?


Top
 Profile  
 
 Post subject: Re: mysqlnd on php 5.3.6 / plesk 9.5.4 / centos 5.6
Unread postPosted: Sun Jun 19, 2011 5:52 pm 
Offline
New Forum User
New Forum User

Joined: Fri Jun 17, 2011 10:23 am
Posts: 4
Location: Netherlands
After some further reading, it appears it is the zts version of PHP being built with the spec that uses mysqlnd, and the normal version does not.

I could install the zts version, but that would significantly reduce the modules that can be used, and is not needed with Apache in prefork mode.

After some further thinking however, I do not think the "default" php module should be built with mysqlnd, it may cause problems with some sites. Would it be considered to build a separate PHP5 module with mysqlnd instead of libmysql and name it php-mysqlnd ? See the zts build in the spec on the mysqlnd options. The rest of the configuration can remain exactly the same.

I'm not well versed enough in RPM building to make it myself yet, but if it is not something you guys are willing to do, I guess I'll just have to build PHP from source normally.


Top
 Profile  
 
 Post subject: Re: mysqlnd on php 5.3.6 / plesk 9.5.4 / centos 5.6
Unread postPosted: Sun Jun 19, 2011 9:27 pm 
Offline
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin

Joined: Wed Dec 31, 1969 8:00 pm
Posts: 7780
Location: earth
Do we know for a fact that it would cause some kind of conflict? I'm not in a position to test this myself, so I'm kind of operating in the dark on it too.


Top
 Profile  
 
 Post subject: Re: mysqlnd on php 5.3.6 / plesk 9.5.4 / centos 5.6
Unread postPosted: Tue Jul 12, 2011 8:00 am 
Offline
New Forum User
New Forum User

Joined: Tue Jul 12, 2011 7:44 am
Posts: 1
Location: Poland
I have the same problem

I install php-zts and configure apache in worker mode. Then i could use mysqlnd but php-pecl extension are not available.

Quote:
Would it be considered to build a separate PHP5 module with mysqlnd instead of libmysql and name it php-mysqlnd ? See the zts build in the spec on the mysqlnd options. The rest of the configuration can remain exactly the same.


This will be perfect solution for me...


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

» Feed - Atomicorp

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group