TurnKey Linux Virtual Appliance Library

MySQL 5.1

Is there going to be an update to the MySQL stack so that it can run 5.1 or is it safe to update the MySQL to 5.1 in this appliance?  Any gotchas I need to look out for?

Jeremy's picture

Devs currently working on appliance updates

The next TKL release will be based on Ubuntu Lucid/10.04 which includes MySQL Server 5.1 in the repositories (see full package details here). I suggest that you hold out for now if you can, especially as TKLBAM will make migration a snap. There is no clear timeframe for release though (just as soon as they can) so if you urgently need 5.1 then you may need consider installing via an alternative method.

Off the top of my head, choices you have are (in the order I'd possibly consider them):

  1. Build your own appliance based on TKL-Core-Lucid beta (beta of Core for new TKL release). IMO this is probably the best option if you need to upgrade. Will require some Linux knowledge (or willingness to aquire it).
  2. Use Basil's LAMP TKLPatch (which as the name suggests, also includes Apache & php). The easiest method while avoiding some of the pitfalls of method 3. Although is possibly overkill (unless of course you want a full LAMP stack). May also require some tweaking (as it is set up as a LAMP stack rather than MySQL only).
  3. Find an alternative repository such as a PPA or somewhere else - easy but not recommended as it may raise security and/or stability issues (do you know what backdoors and/or unsuitable optimisations the compiler may have added to the code?). Also it may also raise issues down the track if/when you want to migate to the new offical TKL MySQL release (due to mismatched MySQL versions or other issues).
  4. Install tarball, rpm or build from source (downloaded direct from MySQL site) - Not for the faint of heart, can be quite technical and/or problematic. Quite possible you will encounter issues. May also lead to issues down the track if/when you want to migate to the new offical TKL MySQL release (as in 3). Would be preferable to option 3 if you can find a good tutorial online.

If you can't wait and wish to press ahead with one of these methods then I can probably give you a few more pointers.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)