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 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 65 Next 5 Older Entries

Displaying posts with tag: update (reset)

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...]
    Updating from MySQL 5.0 to 5.1 - what's your experience?
    Employee +0 Vote Up -0Vote Down

    Now that MySQL 5.1 has finally been labeled and released as "GA", we have noticed quite a significant increase in the download numbers for 5.1. I find this quite promising, despite the comments from some people that suggested to stay away from it for now. I performed updates of 5.0 to 5.1 several times already, and did not observe any serious problem so far. But then again, I am by no means a power user, so your mileage may vary...

    I assume that many of the users are already using some older versions of MySQL and will have to perform an upgrade from the previous version to the new one. As many things have been changed and improved between 5.0 and 5.1, an upgrade needs to be planned carefully. The MySQL reference manual has an

      [Read more...]
    Updating from MySQL 5.0 to 5.1 - what's your experience?
    Employee +0 Vote Up -0Vote Down

    Now that MySQL 5.1 has finally been labeled and released as "GA", we have noticed quite a significant increase in the download numbers for 5.1. I find this quite promising, despite the comments from some people that suggested to stay away from it for now. I performed updates of 5.0 to 5.1 several times already, and did not observe any serious problem so far. But then again, I am by no means a power user, so your mileage may vary...

    I assume that many of the users are already using some older versions of MySQL and will have to perform an upgrade from the previous version to the new one. As many things have been changed and improved between 5.0 and 5.1, an upgrade needs to be planned carefully. The MySQL reference manual has an

      [Read more...]
    Performance regression testing results or just statistics?
    Employee_Team +0 Vote Up -0Vote Down

    We’re very excited to see MySQL 5.1.30 make it to GA status and are very proud of the work that the MySQL engineering team has done to get MySQL 5.1 out of the door.

    Maybe you’ve seen some claims by others in the MySQL community that MySQL 5.1 runs slower than MySQL 5.0. Maybe you’ve also seen some claims by others in the MySQL community that MySQL 5.1 runs faster than MySQL 5.0.

    Guess what? They’re both right.

    With database or any other hardware/software performance tests, you’re always going to see different results because there are *so* many variables that go into the equation.

    That being the case, I thought I’d share a little of what we in the MySQL QA group have seen on the 5.1 vs. 5.0 front. Part of our job in MySQL QA is to routinely test





      [Read more...]
    PlanetMySQL now available in Italian as well!
    Employee +0 Vote Up -0Vote Down

    FYI, we've now added an Italian section on Planet MySQL: http://it.planetmysql.org

    If you are a MySQL enthusiast from Italy and would like to start blogging about it in your native language, please consider submitting your feed for inclusion!

    Giuseppe just recently started blogging in Italian as well and has already added his feed there.

    PlanetMySQL now available in Italian as well!
    Employee +0 Vote Up -0Vote Down

    FYI, we've now added an Italian section on Planet MySQL: http://it.planetmysql.org

    If you are a MySQL enthusiast from Italy and would like to start blogging about it in your native language, please consider submitting your feed for inclusion!

    Giuseppe just recently started blogging in Italian as well and has already added his feed there.

    mylvmbackup-0.11 has been released
    Employee +0 Vote Up -0Vote Down

    Some days ago, I released version 0.11 of mylvmbackup a Perl script that performs consistent backups of a MySQL server by using LVM filesystem snapshots. The source archive as well as a generic RPM can be found on the project home page, packages for many Linux distributions are available on the openSUSE Build service.

    This release includes some new functionality as well as numerous bug fixes and improvements, most notably:

    • Added support for using rsnap as a backup backend (Matt Lohier)
    • The documentation is now maintained in POD style instead of asciidoc (Matthew Boehm)
    • Support using non-GNU tar
      [Read more...]
    mylvmbackup-0.11 has been released
    Employee +0 Vote Up -0Vote Down

    Some days ago, I released version 0.11 of mylvmbackup a Perl script that performs consistent backups of a MySQL server by using LVM filesystem snapshots. The source archive as well as a generic RPM can be found on the project home page, packages for many Linux distributions are available on the openSUSE Build service.

    This release includes some new functionality as well as numerous bug fixes and improvements, most notably:

    • Added support for using rsnap as a backup backend (Matt Lohier)
    • The documentation is now maintained in POD style instead of asciidoc (Matthew Boehm)
    • Support using non-GNU tar
      [Read more...]
    mylvmbackup 0.10 has been released
    Employee +0 Vote Up -0Vote Down

    I am happy to announce that mylvmbackup version 0.10 has been released.

    You can download the updated package from the project home page or via the openSUSE Build Service.

    This version fixes some bugs and includes new functionality:

    • Applied patch from Marc Haber: added option --keep_snapshot that will skip the removal of the backup snapshot before terminating the script. Providing the option --backuptype=none will now skip creating a backup using the builtin backup modules. Both options provide more flexibility when using hooks for performing the actual backup tasks or when the snapshot is considered to be the actual backup.
    • Added two new hooks: "backupsuccess" and "backupfailure" which are called respectively upon success of failure of the backup operation (
      [Read more...]
    mylvmbackup 0.10 has been released
    Employee +0 Vote Up -0Vote Down

    I am happy to announce that mylvmbackup version 0.10 has been released.

    You can download the updated package from the project home page or via the openSUSE Build Service.

    This version fixes some bugs and includes new functionality:

    • Applied patch from Marc Haber: added option --keep_snapshot that will skip the removal of the backup snapshot before terminating the script. Providing the option --backuptype=none will now skip creating a backup using the builtin backup modules. Both options provide more flexibility when using hooks for performing the actual backup tasks or when the snapshot is considered to be the actual backup.
    • Added two new hooks: "backupsuccess" and "backupfailure" which are called respectively upon success of failure of the backup operation (
      [Read more...]
    PlanetMySQL Update: Goodbye, MagpieRSS, hello SimplePie!
    Employee +0 Vote Up -0Vote Down

    This is more of an "behind the scenes" update and I hope that you won't see any (negative) changes on the PlanetMySQL front page or the RSS feeds: I just finished and commited the conversion of the backend script that performs the parsing and aggregation of feeds from requiring MagpieRSS to SimplePie.

    This will provide better support for a wider range of feed types and should also fix a few quirks, e.g. that some postings (for example the one from Kevin

      [Read more...]
    PlanetMySQL Update: Goodbye, MagpieRSS, hello SimplePie!
    Employee +0 Vote Up -0Vote Down

    This is more of an "behind the scenes" update and I hope that you won't see any (negative) changes on the PlanetMySQL front page or the RSS feeds: I just finished and commited the conversion of the backend script that performs the parsing and aggregation of feeds from requiring MagpieRSS to SimplePie.

    This will provide better support for a wider range of feed types and should also fix a few quirks, e.g. that some postings (for example the one from Kevin

      [Read more...]
    Recent additions to my openSUSE Build Service repository
    Employee +0 Vote Up -0Vote Down

    I recently added two new packages to my repository on the openSUSE Build Service:

    • Maatkit is a collection of essential command-line utilities for MySQL. Each is completely stand-alone, without dependencies other than core Perl and the DBI drivers needed to connect to MySQL, and doesn't need to be "installed" - you can just execute the scripts. This makes the tools easy to use on systems where you can't install anything extra, such as customer sites or ISPs.
    • protobuf - Protocol Buffers - Google's data interchange format. Protocol Buffers are a way of encoding structured data in an efficient yet extensible format. Google
      [Read more...]
    mylvmbackup 0.9 has been released
    Employee +0 Vote Up -0Vote Down

    I am happy to announce that a new version (0.9) of mylvmbackup has been released. This is the first release since the source code has been moved from Subversion to Bazaar and is now hosted on Launchpad.net. I would like to thank Robin H. Johnson and Patrick Hahn for providing the patches that contributed to this new release!

    mylvmbackup is a tool for quickly creating backups of MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations, while the actual file backup

      [Read more...]
    Gallery updates and new camera
    Employee +0 Vote Up -0Vote Down

    Last weekend I finally found some time to upload pictures that I had taken during various events that I attended in the past few months. So here are my impressions from the following events:

      [Read more...]
    Two small PlanetMySQL modifications
    Employee +0 Vote Up -0Vote Down

    FYI, I changed two parameters on Planet MySQL to accomodate the current flood of postings coming from the MySQL Conference attendees: we now display the last 25 posts (instead of 10) on the front page, the RSS feed now includes the latest 100 posts (instead of 50). This should make sure that posts actually make it to the front page for at least some time, before they fall off again.

    Please keep up the good blogging!

     

    mylvmbackup 0.8 has been released
    Employee +0 Vote Up -0Vote Down

    I am happy to announce the release of mylvmbackup version 0.8. mylvmbackup is a tool for quickly creating backups of a MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again. The snapshot process takes only a small amount of time. When it is done, the server can continue normal operations, while the actual file backup proceeds.

    Below is the list of changes since version 0.6. You may wonder what happened to version 0.7 - it had a rather short life cycle as I was informed about a bug that I fixed quickly before I made a wider release announcement of 0.7.

    • Fixed a bug in the InnoDB
      [Read more...]
    Congratulations to the Drupal 6.0 release!
    Employee +0 Vote Up -0Vote Down

    Yesterday, Drupal 6.0 was officially released - check out this screencast to get a 29-minute tour on the new features in this release.

    We'd like to congratulate the Drupal Developer Team and Community for reaching this milestone and are happy that the MySQL Server continues to serve well as the database backend for this awesome content management platform!

    I had the pleasure of evaluating and reviewing a previous release of Drupal for the Open Source Content Management System Award from Packt Publishing and it has been one of my favourites.

    Keep up the good work!
     

    mylvmbackup 0.6 has been released
    Employee +0 Vote Up -0Vote Down

    Version 0.6 of mylvmbackup, a script to perform backups of a MySQL server using Linux LVM snapshots, has now been released.

    In addition to various code cleanups and documentation improvements, many new features have been added to this version. I'd like to specially thank Robin H. Johnson from the Gentoo project for contributing many of the improvements to this release!

    • Added a new rsync backup type. This is very useful if you want to use mylvmbackup to create the initial state for your slave servers. Instead of creating a .tar.gz archive, the data directory is copied into a timestamped archive directory. (Robin)
    • Added support for a trailing argument to tar, which can be used for excluding files. (Robin)
    • Separated out the suffix of the tarball (Preperation for rsync and users that want to use bzip2 or no compression on the
      [Read more...]
    Gallery updates
    Employee +0 Vote Up -0Vote Down
    This certainly took longer than expected, but here are some pictures that I took during our MySQL Developer Meeting in Heidelberg, Germany last month. Enjoy!
    PlanetMySQL update: Post titles in the RSS feed include the author names now
    Employee +0 Vote Up -0Vote Down
    Just a quick heads-up - I just commited a change to the Planet MySQL code that slightly modifies how the RSS feed is being created: now the author name is put in front of each posting's title, similar to how many other feed aggregators mark the different articles. I hope you find this change useful, let me know if you experience any problems or have any other suggestions for improvements. Thanks!
    Fighting spam: reCAPTCHA installed on the MySQL Forge Wiki
    Employee +0 Vote Up -0Vote Down
    Today, I again spent about an hour to revert changes made by spambots on various MySQL Forge Wiki pages. As I was really sick of this, I now installed a new plugin: reCAPTCHA - this will hopefully raise the bar for spambots to create new user accounts automatically for spamming the Wiki. If you are a registered user already, you will probably not notice the change - by default, CAPTCHAs are only displayed on the following events:
    • New user registration
    • Anonymous edits that contain new external links
    • Brute-force password cracking
    Let's hope it helps! Please let me know if you still experience spam problems on the Wiki.
    Announcing mylvmbackup 0.5
    Employee +0 Vote Up -0Vote Down
    Eric Bergen from Proven Scaling (which I had the pleasure to meet in person during the MySQL Conference & Expo in Santa Clara last month) was kind enough to send me a patch for the mylmbackup tool, which justifies a new release:
    Attached is a patch file for mylvmbackup that adds the ability to use
    lvm version 2 and perform innodb recovery on the snapshot prior to
    creating a tar ball. The option is named --innodb-recover.

    I've also fixed a bug with default value handling for command line
    options. In version 0.4 if a config file was specified default values
    in the script were all changed to blank. This means that the config
    file had to supply values for every variable instead of just the
    values that need








      [Read more...]
    MySQL++ v2.2.0 has been released
    Employee +0 Vote Up -0Vote Down
    Congratulations to Warren Young and the other developers that maintain the MySQL++ C++ wrapper around the MySQL Client libraries: version 2.2.0 has just been announced and boasts a wide range of changes. Here's a description of MySQL++ from the project web site:
    MySQL++ is a C++ wrapper for MySQL (http://mysql.com/)'s C API. It is built around STL principles, to make dealing with the database as easy as dealing with an STL container. MySQL++ relieves the programmer of dealing with cumbersome C data structures, generation of repetitive SQL statements, and manual creation of C++ data structures to mirror the database schema
    New daily MySQL source snapshots available
    Employee +0 Vote Up -0Vote Down
    With great pleasure I today noticed that we finally have daily snapshot builds of all current versions of the MySQL server source trees (4.0-5.1) available on http://snaps.mysql.com/ again. Unfortunately this has not been the case for quite some time - a few issues that caused the 5.0 and 5.1 snapshot builds/tests to fail have now finally been resolved. I also made some changes to the build script that performs the snapshot builds, e.g. to use the Perl-based test suite where available instead of the Shell-based one, which is going to phased out in 5.1 anyway. Let's hope that from now on the snapshot builds will now be available more frequently again, I'll keep a close eye on that.

    Sorry for the long delay, I know that some of you depend on receiving updated source tarball snapshots on a regular basis instead of having to use the free BK client...
    New daily MySQL source snapshots available
    Employee +0 Vote Up -0Vote Down
    With great pleasure I today noticed that we finally have daily snapshot builds of all current versions of the MySQL server source trees (4.0-5.1) available on http://snaps.mysql.com/ again. Unfortunately this has not been the case for quite some time - a few issues that caused the 5.0 and 5.1 snapshot builds/tests to fail have now finally been resolved. I also made some changes to the build script that performs the snapshot builds, e.g. to use the Perl-based test suite where available instead of the Shell-based one, which is going to phased out in 5.1 anyway. Let's hope that from now on the snapshot builds will now be available more frequently again, I'll keep a close eye on that.

    Sorry for the long delay, I know that some of you depend on receiving updated source tarball snapshots on a regular basis instead of having to use the free BK client...
    mylvmbackup 0.3 now released
    Employee +0 Vote Up -0Vote Down

    I am happy to announce version 0.3 of mylvmbackup, a tool that performs consistent backups of a MySQL server's tables using Linux LVM snapshots.

    Special thanks go to Fred Blaise, who contributed the majority of the new features that have been added to this new release:

    • It is now possible to use an external configuration file /etc/mylvmbackup.conf to store the options. This is probably more convenient than having to pass a slew of options on the command line or having to hack the script itself to change the default values. This new feature requires the Config::IniFiles Perl module to be installed, a sample configuration file is included in the package.
    • The logging to the console has
      [Read more...]
    mylvmbackup 0.3 now released
    Employee +0 Vote Up -0Vote Down

    I am happy to announce version 0.3 of mylvmbackup, a tool that performs consistent backups of a MySQL server's tables using Linux LVM snapshots.

    Special thanks go to Fred Blaise, who contributed the majority of the new features that have been added to this new release:

    • It is now possible to use an external configuration file /etc/mylvmbackup.conf to store the options. This is probably more convenient than having to pass a slew of options on the command line or having to hack the script itself to change the default values. This new feature requires the Config::IniFiles Perl module to be installed, a sample configuration file is included in the package.
    • The logging to the console has been
      [Read more...]
    mylvmbackup version 0.2 has been released
    Employee +0 Vote Up -0Vote Down

    I am happy to announce that version 0.2 of the mylvmbackup tool is now available!

    mylvmbackup is a Perl script for quickly performing backups of a MySQL server's databases using the Linux Logical Volume Manager (LVM). It creates a consistent LVM snapshot of the server's data directory which is then backed up without further blocking the server's operation.

    After version 0.1 was published in May this year, I did not really get much feedback about it. I had some ideas for improvements (see the TODO file included in the package), but never got around to actually start working on them.

    Thanks to Robin H. Johnson from the Gentoo project for contributing a number of new options and

      [Read more...]
    mylvmbackup version 0.2 has been released
    Employee +0 Vote Up -0Vote Down

    I am happy to announce that version 0.2 of the mylvmbackup tool is now available!

    mylvmbackup is a Perl script for quickly performing backups of a MySQL server's databases using the Linux Logical Volume Manager (LVM). It creates a consistent LVM snapshot of the server's data directory which is then backed up without further blocking the server's operation.

    After version 0.1 was published in May this year, I did not really get much feedback about it. I had some ideas for improvements (see the TODO file included in the package), but never got around to actually start working on them.

    Thanks to Robin H. Johnson from the Gentoo project for contributing a number of new options and features

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 65 Next 5 Older Entries

    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.