Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For a number of our websites we are using Ubuntu LTS 10.04 with MySQL 5.1. We are looking into consolidating the SQL databases onto a single server and have been testing Percona 5.5 for this purpose.

The MySQL clients (PHP5-MySQL) use libmysqlclient16 (5.1.41-3ubuntu12.10), is it safe for us to use this version with Percona server 5.5?

Optionally I can use the Percona apt repository on our webservers and upgrade libmysqlclient16 to the Percona version (5.1.62-rel13.3-435.lucid).

share|improve this question

In general you should be safe unless the client shows an a warning or error. I have used the same client to different serversvwith no issues. This mysql article also says that the client and the server do not have to match versions, despite the fact that when the difference sometimes could cause problems.

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Related issue: you can generally replicate from a server to a higher version of server as well, but the features are limited by the older version. Client should have even fewer problems because commands are interpreted and executed by the server.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.