Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 863 Next 10 Older Entries

Displaying posts with tag: Uncategorized (reset)

Tracing down a problem, finding sloppy code
+0 Vote Up -0Vote Down

Daniel was tracking down what appeared to be a networking problem….

  • server reported 113 (No route to host)
  • However, an strace did not reveal the networking stack ever returning that.
  • On the other side, IP packets were actually received.
  • When confronted with mysteries like this, I get suspicious – mainly of (fellow) programmers.
  • I suggested a grep through the source code, which revealed  return -EHOSTUNREACH;
  • Mystery solved, which allowed us to find what was actually going on.

Lessons:

  • Don’t just believe or presume the supposed origin of an error.
  • Programmers often take shortcuts that cause grief later. I fully appreciate how the above code came about, but I still think it was wrong. Mapping a
  •   [Read more...]
    MySQL Workbench 6.2.1 BETA has been released
    Employee_Team +1 Vote Up -0Vote Down

    Dear MySQL Users,

    The MySQL Workbench team is announcing availability of the first beta
    release of its upcoming major product update, MySQL Workbench 6.2.

    MySQL Workbench 6.2 focuses on support for innovations released in MySQL
    5.6 and MySQL 5.7 DMR (Development Release) as well as MySQL Fabric 1.5,
    with features such as:

    * A new spatial data viewer, allowing graphical views of result sets
    containing GEOMETRY data and taking advantage of the new GIS
    capabilities in MySQL 5.7.
    * Support for new MySQL 5.7.4 SQL syntax and configuration options.
    * Metadata Locks View shows the locks connections are blocked or waiting
    on.
    * MySQL Fabric cluster connectivity – Browsing, view status, and connect
    to any MySQL instance in a Fabric Cluster.
    * MS Access migration Wizard – easily










      [Read more...]
    Upgrade MySQL to a new version with a fresh installation & use shell scripts and mysqldump to reload your data
    +0 Vote Up -0Vote Down

    There are several ways to upgrade MySQL (http://mysql.com). In this post, we will use a combination of shell scripts and the mysqldump application to export our MySQL (http://mysql.com) data, and then re-import it back into the upgraded version of MySQL (http://mysql.com).

    In this example, we will be doing a minor version upgrade. We will be going from 5.6.17 to 5.6.19. This method may not work if you are upgrading from one major release to another – from 5.1 to 5.5, or 5.5 to 5.6. You will want to check each version and review the new features/functions and also what features/functions have been deprecated. We are also assuming that no one will be using the database during the time it takes

      [Read more...]
    New! MySQL Utilities release-1.4.4 GA
    Employee_Team +0 Vote Up -0Vote Down

    The MySQL Utilities Team is pleased to announce the latest GA release of MySQL Utilities, release-1.4.4. This release includes improvements in terms of usability, stability, security and an overall improvement regarding the comprehensibility of the provided error messages.

    Improvements

    The following highlights a few of the more significant improvements.

    • mysqlrpladmin errant transactions for switchover have been improved. Note : The errant transactions check requires all servers in the topology to have GTID’s enabled.
    • Failed MySQL server connection error messages now display the actual error returned from the failed connection.
    • Error messages that occur during automatic slave discovery (–discover-slaves-login) have been improved. Now the –verbose option generates specific information for each slave, including their
      [Read more...]
    New! MySQL Utilities Now Supports SSL and Configuration Files
    Employee_Team +0 Vote Up -0Vote Down

    The MySQL Utilities Team is pleased to announce a new release that contains our newest features – SSL and configuration file support. These were added to release-1.5.0-alpha.

    How can I make a secure connection to my server via Utilities?

    Use the new SSL command-line options that are available for all utilities:

    –ssl-ca : The path to a file that contains a list of trusted SSL certificate authorities.
    –ssl-cert : The name of the SSL certificate file to use for establishing a secure connection.
    –ssl-key : The name of the SSL key file to use for establishing a secure connection.

    Then just specify the appropriate values on the command-line with any other parameters.

    How can I use configuration files?

    If typing all of those SSL options seems tedious, you can specify this



      [Read more...]
    MySQL Workbench 6.1.7 GA has been released
    Employee_Team +2 Vote Up -0Vote Down

    Dear MySQL users,

    The MySQL Workbench team announces availability of version 6.1.7 of its
    flagship product. MySQL Workbench 6.1.7 is a periodic maintenance release
    including 17 bug fixes. Additionally, the supported Linux distribution list has been
    refreshed. Users of the product are recommended to upgrade to this version.

    MySQL Workbench 6.1

    With over 30 new features, this version has many significant
    enhancements focusing on real-time performance assessment and analysis
    from the SQL statement level to server internals and file IO. You can
    see this from additions to the SQL Editor as well as new dashboard
    visualization and reporting that take advantage of MySQL Server 5.6
    and 5.7 Performance Schema, and enhancements to the MySQL Explain Plans.

    Additionally Workbench 6.1 is leveraging work from









      [Read more...]
    MySQL backup and cleanup bash scripts with mydumper
    +1 Vote Up -0Vote Down

    1. Backup script

    #!/bin/sh
    # Fri Jun 27 10:44:49 2014
    # done by dragkh
    # usage: 
    # cat /etc/cron.d/backupmysql 
    # 0  3  *  *  *       root    /root/bin/clean.backup.hyperion.mysql.mydumper.daily.sh >>  /var/log/clean.backup.${HOSTNAME}.mysql.mydumper.daily.log 2>&1
    # 35  3  *  *  *       root    /root/bin/backup.hyperion.mysql.mydumper.daily.sh >> /var/log/backup.${HOSTNAME}.mysql.mydumper.daily.log 2>&1
    
    ROOT_BACKUP_DIR="/home/mydumper"
    
    seik_date () {
    if [ -z $1 ]
    then
    # cdate=`date +%Y-%m-%d\ %H:%M:%S\ %Z`; export cdate; echo $cdate
    cdate=`date -R`; export cdate; echo $cdate
    else
    
    if [ -z ${2} ]
    then
    cdate=`date +%Y-%m-%d.%H.%M.%S`; export cdate; echo $cdate
    else
    cdate=`date "+%Y-%m-%d %H:%M:%S"`; export cdate; echo $cdate
    fi
    
    fi
    }
    
    
    function check_dir {
     test ! -d
      [Read more...]
    On PostgreSQL. Interview with Bruce Momjian.
    +0 Vote Up -0Vote Down

    “There are four things that motivate open source development teams:
    1. The challenge/puzzle of programming, 2. Need for the software, 3. Personal advancement, 4. Belief in open source”
    — Bruce Momjian.

    On PostgreSQL and the challenges of motivating and managing open source teams, I have interviewed Bruce Momjian, Senior Database Architect at EnterpriseDB, and Co-founder of the PostgreSQL Global Development Group and Core Contributor.

    RVZ

    Q1. How did you manage to transform PostgreSQL from an abandoned academic project into a commercially viable, now enterprise relational database?


      [Read more...]
    Fabric Webinar with Andrew Morgan June 19th.
    Employee +2 Vote Up -1Vote Down

    MySQL Fabric – High Availability & Automated Sharding for MySQL

    MySQL Fabric is built around an extensible and open source framework for managing farms of MySQL Servers. Currently two features have been implemented – High Availability (built on top of MySQL Replication) and scaling out using data sharding. These features can be used in isolation or in combination. MySQL Fabric aware connectors allow transactions and queries to be routed to the correct servers without the need for a proxy node, so operations run as quickly as ever. In this webinar you will learn what MySQL Fabric is, what it can achieve and how it is used – by DBAs, Dev-Ops and developers. You’ll also be exposed to what is happening under the covers.

      [Read more...]
    A New Home for Tungsten in the UK
    +0 Vote Up -0Vote Down

    I was suitably heartened to hear about the new mine opening up in the Devon here in the UK to mine the element Tungsten.

    I comment on this to my associates at Continuent, where comments were made by Csaba as to the appropriate quotes in the article:

    “Tungsten is an extraordinary metal.”

    “It’s almost as hard as a diamond and has one of the highest melting points of any mineral.”

    “Adding a small amount to steel makes it far harder, far more resistant to stress and heat. The benefits to industry are obvious.”

    Leading to him to suggest Adding a small amount of Tungsten to MySQL makes it far harder, far more resistant to stress and failures. The benefits to industry are obvious.

    I

      [Read more...]
    Showing entries 1 to 10 of 863 Next 10 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.