Am 29.10.2013 um 22:56 schrieb Reindl Harald h.reindl@thelounge.net:
php-mysql is linked against mysql-5.0-libs and talking to a mysql-5.5 server. Should this cause an unpredictable behavior?
no - how do you come to this idea?
In the last decade i saw very strange results while updating or doing similar things. the question above is more a theoretical thought despite the rational knowledge that in this example (communication-layer) the compatibility is preserved.
-- LF
On Wed, 2013-10-30 at 11:22 +0100, Leon Fauster wrote:
Am 29.10.2013 um 22:56 schrieb Reindl Harald h.reindl@thelounge.net:
php-mysql is linked against mysql-5.0-libs and talking to a mysql-5.5 server. Should this cause an unpredictable behavior?
no - how do you come to this idea?
In the last decade i saw very strange results while updating or doing similar things. the question above is more a theoretical thought despite the rational knowledge that in this example (communication-layer) the compatibility is preserved.
I have always tried to keep the client libraries in sync with the database in my own code. I was surprised that the upstream builders had mixed the 5.0 client with the 5.5 data base. I know of cases where library developers will provide for compatibility with various versions of protocols. It looks to me like this is one of those cases.
We are using Perl and PHP with MySQL, and both seem to work with the 5.0 client library on the 5.5 database.
Besides the usual tests like create a new web page, delete a web page, edit a page, etc, we pointed a spider that is part of burp suite at the web site on a development system. The web site is several thousand pages, some are PHP with parts that are pulled from an upgraded mysql 5.5 data base and others are flat files. Burp suite has been running for several hours and every thing looks good so far.
I think this weekend, we will start moving production servers from CentOS 5.9 to 5.10 and from MySQL 5.0 to 5.5.
Matt
Am 30.10.2013 um 17:31 schrieb Matthew B. Brookover mbrookov@mines.edu:
On Wed, 2013-10-30 at 11:22 +0100, Leon Fauster wrote:
Am 29.10.2013 um 22:56 schrieb Reindl Harald h.reindl@thelounge.net:
no - how do you come to this idea?
In the last decade i saw very strange results while updating or doing similar things. the question above is more a theoretical thought despite the rational knowledge that in this example (communication-layer) the compatibility is preserved.
I have always tried to keep the client libraries in sync with the database in my own code. I was surprised that the upstream builders had mixed the 5.0 client with the 5.5 data base. I know of cases where library developers will provide for compatibility with various versions of protocols. It looks to me like this is one of those cases.
We are using Perl and PHP with MySQL, and both seem to work with the 5.0 client library on the 5.5 database.
Besides the usual tests like create a new web page, delete a web page, edit a page, etc, we pointed a spider that is part of burp suite at the web site on a development system. The web site is several thousand pages, some are PHP with parts that are pulled from an upgraded mysql 5.5 data base and others are flat files. Burp suite has been running for several hours and every thing looks good so far.
interesting, thanks for sharing.
I think this weekend, we will start moving production servers from CentOS 5.9 to 5.10 and from MySQL 5.0 to 5.5.
-- LF
On 10/30/2013 05:22 AM, Leon Fauster wrote:
Am 29.10.2013 um 22:56 schrieb Reindl Harald h.reindl@thelounge.net:
php-mysql is linked against mysql-5.0-libs and talking to a mysql-5.5 server. Should this cause an unpredictable behavior?
no - how do you come to this idea?
In the last decade i saw very strange results while updating or doing similar things. the question above is more a theoretical thought despite the rational knowledge that in this example (communication-layer) the compatibility is preserved.
If you look at the Software collections info for EL6, they specifically discuss that issue:
http://dev.centos.org/centos/6/SCL/docs/#sect-Installation_and_Usage-Migrati...
(see section 2.6.3)
So, Red Hat has specifically tested using the 5.1 (for EL6 and 5.0 for EL5) client library with the 5.5 database and has certified it as working enough that they support it.
Does that mean it is flawless ... likely not. But it is as intended.
-
Johnny Hughes -
Leon Fauster -
Matthew B. Brookover