Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 27

Displaying posts with tag: upgrade (reset)

Doing a rolling upgrade of Percona XtraDB Cluster from 5.5 to 5.6
+0 Vote Up -0Vote Down

Overview

Percona XtraDB Cluster 5.6 has been GA for several months now and people are thinking more and more about moving from 5.5 to 5.6. Most people don’t want to upgrade all at once, but would prefer a rolling upgrade to avoid downtime and ensure 5.6 is behaving in a stable fashion before putting all of production on it. The official guide to a rolling upgrade can be found in the PXC 5.6 manual. This blog post will attempt to summarize the basic process.

However, there are a few caveats to trying to do a rolling 5.6 upgrade from 5.5:

  • If you mix Galera 2 and Galera 3 nodes, you must set
  •   [Read more...]
    Password expiration policy in MySQL Server 5.7
    Employee +1 Vote Up -0Vote Down

    I’ve previously noted my wish to have a comprehensive password policy in MySQL Server.  MySQL Server 5.7.4 takes a significant step towards this goal by adding native support for enforcing password lifetime policy.  This complements the validate_password plugin introduced in MySQL Server 5.6, which helps ensure adequate password complexity, and builds on the password expiration mechanism also introduced in MySQL Server 5.6.  This new feature has a

      [Read more...]
    SF MySQL Meetup Presentation: Changes in MySQL 5.7
    Employee +4 Vote Up -0Vote Down

    Last Wednesday, I spoke at the San Francisco MySQL Meetup on the topic of changes coming in MySQL 5.7 (and later).  We actually went through two different slide decks; the first on features being considered for deprecation in MySQL 5.7 (or later), and the second set providing a brief overview of the new features and benefits already introduced in MySQL 5.7 via the development milestone releases (DMRs) published to date.  A big thanks to the entire SF Meetup group, and in particular the organizers (Erin, Mike and Darren), for having me.  The event was streamed and recorded, and you can view the full presentation on YouTube.  The slide deck can be found here.

    The discussion around proposed

      [Read more...]
    Upgrading from MySQL 5.1 to MariaDB 5.5
    +2 Vote Up -0Vote Down

    In my last post, a tale of two MySQL upgrades, a few folks asked if I would outline the process we used to upgrade, and what kind of downtime we had.

    Well, the processes were different for each upgrade, so I will tackle them in separate blog posts. The first step was to upgrade all our MySQL 5.1 machines to MariaDB 5.5. As mentioned in the previous post, MariaDB’s superior performance for subqueries is why we switched – and we switched back to MySQL for 5.6 to take full advantage of the performance_schema.

    It is not difficult to blog about our procedure, as we have documentation on each process. My first tip would be to do that in your own environment. This also enables other folks to help, even if they are sysadmins and not normally DBAs. You may notice the steps

      [Read more...]
    Welcome Tungsten Replicator 2.1.0!
    +3 Vote Up -0Vote Down

    Overview


    First off, the important news. Tungsten Replicator 2.1.0 was released today.
    You can download it and give it a try right now.


    Second, I would say that I am quite surprised at how much we have done in this release. The previous release (2.0.7) was in February, which is just a few months ago, and yet it looks like ages when I see the list of improvements, new features and bug fixes in the Release Notes. I did not realized it until I ran my last batch of checks to test the upgrade from the previous release, which I hadn’t run for quite a long





      [Read more...]
    Summertime Percona MySQL training update
    +1 Vote Up -0Vote Down

    Now that June has arrived it is time to plan what you will do over the summer months. In addition to your summer vacation plans, give thought to MySQL training for you and your team.

    Summer is the time to brush up on those critical skills needed to ensure all systems are ready for the holiday shopping season.

    In addition to our revised courses, that I talked about in a previous post, we are also running our new Moving to MySQL 5.6 class. This class covers new features in MySQL 5.6, migration planning, and application

      [Read more...]
    mysql_upgrade is now version-specific by default
    Employee +1 Vote Up -0Vote Down

    You’ve just completed an upgrade from MySQL 5.5 to 5.6.  You followed the upgrade instructions in the manual, and ran mysql_upgrade.  But when you start MySQL 5.6, you still see the following error messages like the following in the server error log:

    2013-03-26 16:45:51 5040 [ERROR] Column count of mysql.events_waits_current is w
    rong. Expected 19, found 16. Created with MySQL 50520, now running 50610. Please
    use mysql_upgrade to fix this error.
    2013-03-26 16:45:51 5040 [ERROR] Column count of mysql.events_waits_history is w
    rong. Expected 19, found 16. Created with MySQL 50520, now running 50610. Please
    use mysql_upgrade to fix this error.

    What went wrong?

    Well, because mysql_upgrade is a client






      [Read more...]
    Do we need a MySQL Cookbook?
    +2 Vote Up -2Vote Down

    The blog title says it all: Do we need a MySQL Cookbook? I tend to think so.

    This seems to be something that is missing with current MySQL documentation. There is lots of information available but finding the appropriate bit can be quite tedious and it often requires looking in multiple places.

    A lot of other software has such books, but for some reason MySQL seems to be missing one.

    A recent example comes from a “documentation feature request” I posted today: http://bugs.mysql.com/bug.php?id=68171. MySQL 5.6 provides a way to “move InnoDB tables” from one server to another. There are many reasons why you may want to do it, but the documentation is currently rather sparse. A simple “example recipe” for this would be good, as would an equivalent recipe for other

      [Read more...]
    Upgrading to MySQL 5.5 on Ubuntu 10.04 LTS
    +4 Vote Up -0Vote Down

    Ubuntu does not provide an apt-get repository package for MySQL 5.5 on this older OS, however this is still a widely used long term support version. The following steps will upgrade an existing MySQL 5.1 apt-get version to a standard MySQL 5.5 binary.

    Step 1. Remove existing MySQL 5.1 retaining data and configuration

    sudo su -
    service mysql stop
    cp -r /etc/mysql /etc/mysql.51
    cp -r /var/lib/mysql /var/lib/mysql.51
    which mysqld
    dpkg -P mysql-server mysql-server-5.1 mysql-server-core-5.1
    which mysqld
    which mysql
    dpkg -P mysql-client-5.1 mysql-client-core-5.1
    which mysql
    dpkg -P libdbd-mysql-perl libmysqlclient16 mysql-common
    # This will not remove /etc/mysql if any other files are in the directory
    dpkg -l | grep mysql
    [ -d /etc/mysql ] && mv /etc/mysql /etc/mysql.uninstall
    cp -r /etc/mysql.51 /etc/mysql
    

    2. Prepare configuration  [Read more...]

    Upgrading to Code Based Migrations EF 4.3.1 with Connector/Net 6.6
    Employee +0 Vote Up -0Vote Down
    This walk through is based on the approach of code first and it assumes you have a basic understanding of code first Entity Framework, so please make sure to check this subject before going further with Entity Framework Code Based Migrations. The purpose of this post is to show you how you can upgrade your existing database and use the Code First Migrations to keep track of the changes done in your model and replicate them to your database.
    The most important MySQL Reference Manual page
    +5 Vote Up -0Vote Down

    In my opinion, The Server Option and Variable Reference at http://dev.mysql.com/doc/refman/5.5/en/mysqld-option-tables.html rates as my most important page. This is a consolidated index that enables a drill down to the Server Command Options, System Variables, Startup and replication specifics, as well as important information on default values and differences between versions including point releases.

    However, there is another page not in the actual manual, but at http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-optvar.html which is an Options/Variables reference akin to the Reference Manual, but includes a 5.x version matrix.

    Recently

      [Read more...]
    Testing new builds with MySQL-Sandbox 3.0.24
    +3 Vote Up -0Vote Down
    MySQL::Sandbox 3.0.24 was released yesterday, with many new features.

    More than vanilla MySQL

    If you have missed my previous announcement, here's the gist of it. MySQL Sandbox can now deal with tarballs from either Percona Server or MariaDB. The main difference after this change is that you can now create a directory called <PREFIX>5.5.16 and make_sandbox will recognize it as well as the plain 5.5.16.
    $ make_sandbox --export_binaries --add_prefix=ps \
    Percona-Server-5.5.11-rel20.2-114.Darwin.i386.tar.gz \
    -- --sandbox_directory=msb_ps5_5_11

    unpacking Percona-Server-5.5.11-rel20.2-114.Darwin.i386.tar.gz
    […]



      [Read more...]
    Upgrading Tungsten Replicator: as easy as ...
    +3 Vote Up -0Vote Down
    When I talked about the usability improvements of Tungsten Replicator, I did not mention the procedure for upgrading. I was reminded about it by a question in the TR mailing list, and since the question was very relevant, I updated the Tungsten Cookbook with some quick upgrading instructions. A quick upgrading procedure is as important as the installer. Since we release software quite often, either because we have scheduled features to release or because of bug fixes, users want to apply a new release to an existing installation without much fuss. You can do the upgrade with a very quick and painless procedure. Let's suppose that you have installed one Tungsten Replicator cluster using this command:

    #
    # using

      [Read more...]
    What’s the recommended MySQL version?
    +0 Vote Up -1Vote Down

    I see this message on our forums, and I think it’s a great question: “Which version of Percona Server is currently recommended?” It’s really the same question as “Which version of MySQL is currently recommended?” I’ll respond here and then post a link in the forum as a reply.

    In my opinion, it’s important to qualify this question by understanding whether we’re talking about an existing MySQL installation, or a new one. The answer is different for each case. (There are other qualifying questions I’d ask too, but this is the biggest distinguisher).

    For an existing MySQL database server, I’d encourage not jumping on a new version immediately when it comes out. Let some early adopters try

      [Read more...]
    Interesting MySQL 5.5 upgrade gotcha
    +10 Vote Up -1Vote Down

    Today I discovered an interesting upgrade problem with a client migrating from MySQL 5.0 to 5.5. The client who is undertaking the upgrade reported that MySQL 5.5 did not support the DECIMAL(18,5) data type. I easily confirmed this not to be the case:

    mysql> drop table if exists x;
    mysql> create table x (col1 DECIMAL(18,5));
    Query OK, 0 rows affected (0.01 sec)
    

    Delving more into the issue in question, I looked at the complete CREATE TABLE statement, recreating the syntax.

    mysql> drop table if exists x;
    mysql> create table x ( MinValue DECIMAL(18,5));
    Query OK, 0 rows affected (0.00 sec)
    

    No problem there.

    mysql> drop table if exists x;
    mysql> create table x (Department INT NOT NULL, MinValue DECIMAL(18,5) NULL, MaxValue DECIMAL(18,5) NULL);
    ERROR 1064 (42000): You have an error in your SQL syntax; check
      [Read more...]
    Vigor2820n 3.3.4 firmware upgrade stops you accessing the “external ip” from inside
    +0 Vote Up -0Vote Down
    I recently upgraded the firmware on my Draytek Vigor 2820n ADSL router to version 3.3.4 from 3.3.3. One thing that surprised me was that the change stopped me being able to access my public IP from behind the router. That is I have an internal LAN with RFC1918 addresses such as 192.168/16 and could access [...]
    Webinar: What you need to know for a MySQL 5.0 -> 5.1 upgrade
    +5 Vote Up -1Vote Down

    IOUG has a free series of three webinars on upgrading MySQL. Each webinar is an hour long, and it starts with a webinar by me tomorrow at 12 noon Central time (GMT-5) on “Why and How to Upgrade to MySQL 5.1″. The webinar assumes you are upgrading from MySQL 5.0 to MySQL 5.1, and talks a little bit about the new features, server variables, and what you need to know when upgrading to MySQL 5.1.

    The software used is GoToWebinar (formerly GoToMeeting), so you will need to install that software. To register, use the links on the IOUG MySQL Upgrade Webinar Series page.

    The complete list of webinars in the MySQL Upgrade Series is:
    * MySQL 5.1: Why and How to Upgrade
    Sheeri Cabral, The Pythian Group
    Tuesday, July 27, 12:00 p.m. – 1:00 p.m. CT (GMT-5)




      [Read more...]
    MySQL 5.1.47 and 5.0.91 released - Two strong reasons to upgrade
    Employee +7 Vote Up -0Vote Down
    MySQL has released security updates for MySQL 5.1.47 and 5.0.91. The most important changes in these releases are fixes of three security bugs. One of them is a problem that had been lurking in the code for many years, and it was found by chance when one of our developers, testing something unrelated, stumbled upon one of the vulnerabilities. Later on, when analyzing the bug, the developers found one more issue, and they fixed it as well.

    MySQL 5.1.47

    In addition to the security update, MySQL 5.1.47 is also very important for an additional reason. The InnoDB plugin that ships with this version has been updated to 1.0.8,

      [Read more...]
    MySQL 5.1.47 and 5.0.91 released - Two strong reasons to upgrade
    Employee +0 Vote Up -0Vote Down
    MySQL has released security updates for MySQL 5.1.47 and 5.0.91. The most important changes in these releases are fixes of three security bugs. One of them is a problem that had been lurking in the code for many years, and it was found by chance when one of our developers, testing something unrelated, stumbled upon one of the vulnerabilities. Later on, when analyzing the bug, the developers found one more issue, and they fixed it as well.

    MySQL 5.1.47

    In addition to the security update, MySQL 5.1.47 is also very important for an additional reason. The InnoDB plugin that ships with this version has been updated to

      [Read more...]
    MySQL 5.1.47 and 5.0.91 released - Two strong reasons to upgrade
    Employee +0 Vote Up -0Vote Down
    MySQL has released security updates for MySQL 5.1.47 and 5.0.91. The most important changes in these releases are fixes of three security bugs. One of them is a problem that had been lurking in the code for many years, and it was found by chance when one of our developers, testing something unrelated, stumbled upon one of the vulnerabilities. Later on, when analyzing the bug, the developers found one more issue, and they fixed it as well.

    MySQL 5.1.47

    In addition to the security update, MySQL 5.1.47 is also very important for an additional reason. The InnoDB plugin that ships with this version has been updated to

      [Read more...]
    Further Thoughts on MySQL Upgrades
    +2 Vote Up -0Vote Down

    I have been upgrading more MySQL database instances recently and have found a few more potential gotchas, which if you are not careful, can potentially be rather nasty. These are not documented explicitly by MySQL, so it may be handy for you to know if you have not come across this type of thing before.

    Most of the issues are those related to upgrading MySQL instances which are replicated, either the master servers or the slaves. Some seem specific to the rpm packages I am using (MySQL enterprise or MySQL advanced rpms), though others are not.

    Take care upgrading a 5.0 master when you have 5.1 slaves

    It is not a good idea to run a mixed major version of mysql in a replicated environment so why would I be doing this? If you work in a replicated environment and have several slaves then it is recommended that you upgrade the slaves first. I work with quite

      [Read more...]
    How to upgrade your Kontrollbase schema
    +1 Vote Up -0Vote Down
    If you have recently downloaded or checked out a new version of Kontrollbase and find that you need to upgrade the schema from a previous version then you will probably find this post useful. If you don’t know if you need to upgrade then you probably do, so read along for a bit just to [...]
    Active support for MySQL 5.0 ends soon
    +6 Vote Up -1Vote Down

    According to the official lifecycle calendar at http://www.mysql.com/about/legal/lifecycle/#calendar (http://www.mysql.com/about/legal/lifecycle/#calendar), active support for MySQL 5.0 (including regular binary updates) will end on December 31st, 2009, which is about 3 weeks away.

    Many folks are still using MySQL 5.0.45, as until October that was the package that came with RedHat. That was released in July 2007, over 2 years ago!

    Upgrading to MySQL 5.1 is not difficult, though it requires more steps than just upgrading the packages.

    There is a list with all the changes made that might affect the upgrade process at http://www.pythian.com/news/1414/new-in-mysql-51-sheeris-presentation/. This includes which variable names have been deprecated and changed, as well as how

      [Read more...]
    Seeking input for a new tool to verify MySQL upgrades
    +3 Vote Up -0Vote Down

    I’ve had several customers in the last week or so who need a way to verify that their application will work well after an upgrade. I’m seeking input on a new tool to help with MySQL upgrades. Please add comments, either here or on the bug report, or on the mailing list topic.

    If someone wants to sponsor this work, that would also be welcomed.

    Upgrading MySQL with minimal downtime through Replication
    Employee +0 Vote Up -0Vote Down

    Problem

    With the release of MySQL 5.1, many DBAs are going to be scheduling downtime to upgrade their MySQL Server. As with all upgrades between major version numbers, it requires one of two upgrade paths:

    • Dump/reload: The safest method of upgrading, but it takes out your server for quite some time, especially if you have a large data set.
    • mysql_upgrade: A much faster method, but it can still be slow for very large data sets.

    I’m here to present a third option. It requires minimal application downtime, and is reasonably simple to prepare for and perform.

    Preparation

    First of all, you’re going to need a second server (which I’ll refer to as S2). It will act as a ’stand-in’, while the main server (which I’ll refer to as S1) is upgraded. Once S2 is ready to go, you can

      [Read more...]
    PHP – Upgrading v5.2.5 to v5.2.8
    +0 Vote Up -0Vote Down

    Background Knowledge


    The following is the process I took to upgrade a web server with PHP v5.2.5 to PHP v5.2.8 running on OpenBSD. PEAR is already installed on this system and up to date. I wasn’t sure if I should exclude PEAR at install or not so therefore did not tell the configurator to exclude PEAR at install.

    Installation Process


  • Download the latest stable PHP release from command prompt # wget http://ca.php.net/get/php-5.2.8.tar.gz/from/a/mirror
  • # tar -zxvf php-5.2.8.tar.gz
  • ./configure –with-mysql=/usr/local –with-mssql=/usr/local –with-apxs –with-zlib-dir=/usr/lib –with-config-file-path=/var/www/conf
  •   [Read more...]
    Upgrade exam or not to have upgrade exam
    Employee +0 Vote Up -0Vote Down

    The MySQL 5.1 DBA exam is in alpha-test right now and some of the reviewers have had questions about upgrade exams. The new exams are no longer multiple choice. They are based on a candidates performance with a real database on a virtual server.
    In the past I have stated that there was not going to be an upgrade exam. This was due to the change in exam format and the history of previous upgrades not being popular. Less than forty folks took the Core to Dev upgrade exam (about 5% with that certification) and the numbers are worse for the Pro to DBA upgrade. Why spend time on something that is not going

      [Read more...]
    Showing entries 1 to 27

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.