1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

[atomic] Mysql 5.1 for Plesk

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by atomicturtle, Jun 23, 2010.

  1. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    The Atomic repo has now standardized on mysql 5.1; Current release is 5.1.48

    The upgrade procedure is documented here:
    http://www.atomicorp.com/wiki/index.php/Mysql


    Please note that if you are upgrading from mysql 4, 4.1, or 5.0 to 5.1 you will need to make some additional changes to your configuration that are documented in the url above.
     
  2. thewolf

    thewolf Regular Pleskian

    25
    57%
    Joined:
    Mar 11, 2004
    Messages:
    231
    Likes Received:
    0
    If one wants to stay with MySQL 5.0 for some time, how do you do that still using the Atomic repo?

    Thanks.
     
  3. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    The package is still available in the repo, you can try specifying the exact version when you invoke yum. I dont know how much longer it will stick around in the repo though.
     
  4. thewolf

    thewolf Regular Pleskian

    25
    57%
    Joined:
    Mar 11, 2004
    Messages:
    231
    Likes Received:
    0
    Thanks, it would be great if you could keep the MySQL 5.0 packages in the repo for a few months, I think other users may need them too.
     
  5. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    Sure they'll stick around for another month or two
     
  6. shall

    shall Regular Pleskian

    26
    57%
    Joined:
    Apr 2, 2007
    Messages:
    226
    Likes Received:
    0
    I installed MySQL thru Atomic, and `mysql --version` now returns:
    Code:
    mysql  Ver 14.14 Distrib 5.1.48, for redhat-linux-gnu (i686) using readline 5.1
    Plesk (9.5.2) reports 'mysql 5.1.48-1.el4.art' within the 'Server Components' page.

    However, phpinfo() still returns:
    Code:
    mysql
    MySQL Support enabled 
    Active Persistent Links  0  
    Active Links  0  
    Client API version  4.1.22  
    MYSQL_MODULE_TYPE  external  
    MYSQL_SOCKET  /var/lib/mysql/mysql.sock  
    MYSQL_INCLUDE  -I/usr/include/mysql  
    MYSQL_LIBS  -L/usr/lib/mysql -lmysqlclient  
    
    MySQL as returned by mysql_get_server_info() returns the correct version.

    What do I need to do to ensure that this is all operating correctly? I'm afraid that the client API might cause problems.

    If it matters, I'm running RHEL4.
     
  7. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
  8. Dan Mikkelsen

    Dan Mikkelsen Basic Pleskian

    21
     
    Joined:
    Oct 13, 2010
    Messages:
    50
    Likes Received:
    0
    Are these for CentOs only, or would it be possible to use this on Debian Lenny also?
     
  9. danliker

    danliker Silver Pleskian Plesk Certified Professional

    33
    43%
    Joined:
    Feb 15, 2006
    Messages:
    575
    Likes Received:
    0
    Location:
    Switzerland
    for debian you can use dotdeb.org
     
  10. Dan Mikkelsen

    Dan Mikkelsen Basic Pleskian

    21
     
    Joined:
    Oct 13, 2010
    Messages:
    50
    Likes Received:
    0
    Ok thanks!

    Have you all had succes with the update to 5.1, without PLESK breaking down or something?
     
  11. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    Latest release is now 5.1.51, available for centos 4/5, rhel 4/5, and fedora 6-13
     
  12. lvalics

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    965
    Likes Received:
    32
    Location:
    Romania
    On a few server I have updated, where I know that is no unicode characters, that was in the past an issue. Where I have updated, all is OK. Now I prepapre the rest of the server to upgrade, hope all will be OK.
     
Loading...