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 61 to 90 of 16140 Next 30 Older Entries

Displaying posts with tag: mysql (reset)

ClusterControl Module for Puppet
+0 Vote Up -0Vote Down
July 7, 2014 By Severalnines

If you are automating your infrastructure using Puppet, then this blog is for you. We are glad to announce the availability of a Puppet module for ClusterControl. For those using Chef, we already published Chef cookbooks for Galera Cluster and ClusterControl some time back.  

 

 

ClusterControl on Puppet Forge

 

The ClusterControl module initial release is available on Puppet Forge, installing the

  [Read more...]
Looking out for max values in integer-based columns in MySQL
+0 Vote Up -0Vote Down

Yay! My first blog post! As long as at least 1 person finds it useful, I’ve done my job. Recently, one of my long-term clients was noticing that while their INSERTs were succeeding, a particular column counter was not incrementing. A quick investigation determined the column was of type int(11) and they had reached the maximum value of 2147483647. We fixed this by using pt-online-schema-change to change the column to int(10) unsigned, thus allowing values up to 4294967295.

My client was now concerned about all his other integer-based columns and wanted me to check them all. So I wrote a

  [Read more...]
MySQL Cluster High Availability Through Data Replicas
Employee_Team +0 Vote Up -0Vote Down

MySQL Cluster enables high availability by storing data replicas on multiple hosts. MySQL Cluster maintains connections between data nodes by using high-speed interconnects over TCP/IP - standard or direct connections - or SCI (Scalable Coherent Interface) sockets.

To learn more about MySQL Cluster, take the MySQL Cluster training course.

This course is currently scheduled for the following locations:

 Location

 Date

 Delivery Language

 Sao

  [Read more...]
The MySQL 6.0 goodybag
+1 Vote Up -0Vote Down
After MySQL 5.1 was released work started on MySQL 5.2, but then this was renamed to MySQL 6.0. There were many new features introduced in 6.0. But then stabilizing this branch became as huge task. Eventually the decision was made to start of with a stable branch and backport the new features from 6.0. This is how many of the 6.0 features landed in 5.5 and 5.6.

So let's see which features 6.0 brought and were they landed. I'll use the What Is New in MySQL 6.0 section of the MySQL 6.0 Reference Manual for this.

  • The Falcon storage engine. This never landed anywhere as far as I know. It's not even included in the




  [Read more...]
db4free.net Relaunch
Employee +0 Vote Up -0Vote Down

Finally! The new db4free.net Website has launched and along with it comes a new (slightly stronger) server and some simplifications with the service itself.

So what is new? Of course the new website which now is up to modern standards again, using a responsive design. While the old site was only designed for desktop (no surprise if you consider it was created in 2005 and remained more or less unchanged since), the new site adopts to small screen devices like mobile phones and tablets as well. Also the look is totally different:

db4free.net old

  [Read more...]
Failover with the MySQL Utilities: Part 2 – mysqlfailover
+1 Vote Up -0Vote Down

In the previous post of this series we saw how you could use mysqlrpladmin to perform manual failover/switchover when GTID replication is enabled in MySQL 5.6. Now we will review mysqlfailover (version 1.4.3), another tool from the MySQL Utilities that can be used for automatic failover.

Summary

  • mysqlfailover can perform automatic failover if MySQL 5.6′s GTID-replication is enabled.
  • All slaves must use --master-info-repository=TABLE.
  • The monitoring node
  [Read more...]
HowTo: Integrating MySQL for Visual Studio with Connector/Net
Employee +0 Vote Up -0Vote Down

One of the most frequent questions in our forums is about how to get the graphical integration when using Visual Studio with MySQL databases.

When developing applications with MySQL databases there are two basics products: a .net driver for MySQL, which is MySQL Connector/Net, and a tool to integrate all of the Visual Studio database oriented tools such as the Server Explorer window. These tools are designed to make a lot easier the creation and edition of MySQL databases when using an IDE like Visual Studio.

Single database backup and restore with MEB
+3 Vote Up -0Vote Down
I was recently asked about if MySQL Enterprise Backup would be able to restore single databases.

My initial answer was that this was complicated, but might be doable with the Transportable Table Space (TTS) option.

But first let's go back to the basics. A common way of working with mysqldump is to get a list of databases and then loop through the databases and dump the data and schema to a SQL file. But both backups and restores will take a lot of time if the size of the database grows. And it's a luke-warm backup at best instead of a hot backup. So that's why we have MySQL Enterprise Backup.

MySQL Enterprise Backup allows you to make a hot backup of InnoDB tables by copying the datafiles while watching the InnoDB redo log files.

On disk the data from the InnoDB storage engine consists of a system tablespace (one of more







  [Read more...]
MySQL for Visual Studio 1.2.1 beta has been released
Employee +0 Vote Up -0Vote Down
MySQL for Visual Studio is a product including all of the Visual Studio integration previously available as part of Connector/Net. The 1.2.1 version is a beta release of this product which is feature complete but still can contain minor bugs and is not suitable for production environments.
MySQL for Excel 1.3.1 RC has been released
Employee +0 Vote Up -0Vote Down

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.1.  This is a RC release for 1.3.x.

As this is a Release Candidate version the MySQL for Excel product can be downloaded only by using the product standalone installer at this link: http://dev.mysql.com/downloads/windows/excel/

Your feedback on this release candidate version is very well appreciated, you can raise bugs on the MySQL bugs page or give us your comments on the MySQL for Excel forum.

Percona Server 5.5.38-35.2 is now available
+2 Vote Up -0Vote Down

Percona is glad to announce the release of Percona Server 5.5.38-35.2 on July 2, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.38, including all the bug fixes in it, Percona Server 5.5.38-35.2 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the

  [Read more...]
Externally Stored Fields in InnoDB
Employee_Team +1 Vote Up -0Vote Down

This article discusses the storage (inline and external) of field data in the InnoDB storage engine. All fields of variable length types like VARCHAR, VARBINARY, BLOB and TEXT can be stored inline within the clustered index record, or stored externally in separate BLOB pages outside of the index record (but within the same tablespace). All of these fields can be classified as large objects. These large objects are either binary large objects or character large objects. The binary large objects do not have an associated character set, whereas the character large objects do.

Within the InnoDB storage engine there is no difference between

  [Read more...]
Using MySQL triggers and views in Amazon RDS
+1 Vote Up -0Vote Down

I recently had an opportunity to migrate a customer from a physical server into Amazon’s RDS environment. In this particular case the customers’ platform makes extensive use of MySQL triggers and views.  I came across two significant issues that prevented me from following Amazon’s documentation, which basically states “use mysqldump” but doesn’t call out a specific method of dealing with MySQL triggers and views.

Amazon Relational Database Service (Amazon RDS) is a great platform if you’re looking for complete hands-off management of your MySQL environment, but comes at a cost in the area of flexibility, i.e. you don’t have SUPER privilege and this brings up additional challenges.

  • You need to ensure you set log_bin_trust_function_creators=1 ( by default this is off, 0).
  • You need to
  •   [Read more...]
    Percona Server 5.6.19-67.0 with TokuDB (GA) now available
    +1 Vote Up -0Vote Down

    Percona is glad to announce the release of Percona Server 5.6.19-67.0 on July 1, 2014. Download the latest version from the Percona web site or from the Percona Software Repositories.

    Based on MySQL 5.6.19, including all the bug fixes in it, Percona Server

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

    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 various teammates in MySQL Engineering by





      [Read more...]
    Time to get some 128-bit types into MySQL?
    +1 Vote Up -0Vote Down

    I think that getting 128-bit types into MySQL would be good. There are a few use cases for this and right now we have to work around them. That should not be necessary.  While not essential they would make things easier.

    The headline is easy to understand, but is this really needed?

    First we need to look to see where this might be used. I can think of three different 128-bit types which are missing at the moment:

    • IPv6 addresses
    • uuid values
    • a bigger value than (signed) bigint [64-bit numbers]

    IPv6 Addresses

    IPv6 addresses are 128-bit numbers, and having a native way to store them would be really helpful. Given this also includes an IPv4 representation then for those people who store IP addresses (client connections and other things) such a native type would be much better than the typical unsigned int or

      [Read more...]
    Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 5: "Profiling in Eclipse with OProfile"
    +1 Vote Up -0Vote Down

    Section 6: "Profile a real case"

    6.1 INTRODUCTION

    Profiling & Debugging is an argument that would require an entire book, the aim of this(and the others) posts of this series is to give you the basic knowledge on how to work with these tools and techniques withing Eclipse. For instance if you want to learn to profile with OProfile you should study on the abundant and separate resources, you may start from: http://OProfile.sourceforge.net

    6.2 ABOUT NAMING THE PROJECT

    read more

    New feature in MariaDB 10.1: ANALYZE statement
    +5 Vote Up -1Vote Down

    Last week, yours truly has pushed a new feature into MariaDB 10.1 tree: ANALYZE statement.

    The idea of this feature is to make it easy to compare query plan with query execution. ANALYZE statement will run the statement, and produce EXPLAIN-like output, where optimizer’s estimates are followed by numbers that were observed when running the query. The output looks like this:

    Here,

    • Next to rows there is r_rows column which shows how many records were read from the table.
    • Next to filtered there is r_filtered column which shows which fraction of records was left after the part of the WHERE condition attached to the table was checked.

    I think this should explain the feature. If

      [Read more...]
    How to avoid even more of the common (but deadly) MySQL development mistakes
    +1 Vote Up -0Vote Down

    On July 16 I’ll be presenting my next webinar focusing on common mistakes committed by MySQL users.

    How to Avoid Even More of the Common (but Deadly) MySQL Development Mistakes

    “Why can’t I just save my data to a file?”

    Using an SQL database seems so complex to get right, and for good reason. The variety of data-driven applications is practically limitless, and as project requirements change, we find ourselves taking shortcuts and adopting bad habits. But there are proven methods to understanding how to develop and manage data in a scalable and reliable way. This talk shows you some of these methods, including:

    • How to optimize a

      [Read more...]
    Optimizations for derived tables in MySQL 5.6 and MariaDB 5.5+
    +5 Vote Up -1Vote Down

    I had been involved with subquery optimizations fairly closely, but last week I was surprised to find out that MySQL 5.6 does not support derived table merging. This feature was among the subquery features in the abandoned MySQL 6.0. In MariaDB, it was finished and released as part of MariaDB 5.3/5.5. As for MySQL, neither MySQL 5.6, nor MySQL 5.7 has this feature.

    So what is this “derived merge”? It’s simple to understand. When one writes complex queries, it is common to use FROM-clause subqueries as a way to structure the query:

    select
      sum(o_totalprice)
    from
      (select * from orders where o_orderpriority=’1-URGENT’) as high_prio_orders
    where
      o_orderdate between ‘1995-01-01′ and
      [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...]
    Failover with the MySQL Utilities – Part 1: mysqlrpladmin
    +2 Vote Up -0Vote Down

    MySQL Utilities are a set of tools provided by Oracle to perform many kinds of administrative tasks. When GTID-replication is enabled, 2 tools can be used for slave promotion: mysqlrpladmin and mysqlfailover. We will review mysqlrpladmin (version 1.4.3) in this post.

    Summary

    • mysqlrpladmin can perform manual failover/switchover when GTID-replication is enabled.
    • You need to have your servers configured with --master-info-repository = TABLE or to add the --rpl-user option for the
      [Read more...]
    Optimistic updates for Edit Data operations in MySQL for Excel
    Employee +0 Vote Up -0Vote Down

    In this blog post regarding MySQL for Excel features included since version 1.2.0, we are going to talk about a new option that is used along with Edit MySQLData operations; very useful when editing data in a multi-user environment. If you are not familiar with editing MySQL data it is very advisable that you visit our thorough blog post about that topic: How To - Guide to editing MySQL data within Excel.

    Remember you can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone.  

    Getting Started with Sphinx?
    +0 Vote Up -0Vote Down
    Here are a few videos those of you who are just getting started with Sphinx may find useful. The first video demonstrates a very simple implementation with Ubuntu, PHP, and MySQL. The second video is also about installing on Ubuntu. And, the last video discusses fulltext query syntax. Check ‘em out. Quick Start with Ubuntu [...]
    Percona Server with TokuDB (beta): Installation, configuration
    +1 Vote Up -0Vote Down

    My previous post was an introduction to the TokuDB storage engine and aimed at explaining the basics of its design and how it differentiates from InnoDB/XtraDB. This post is all about motivating you to give it a try and have a look for yourself. Percona Server is not officially supporting TokuDB as of today, though the guys in the development team are working hard on this and the first GA release of Percona Server with TokuDB is looming on the horizon. However, there’s a beta version available now. For the installation tests in this post I’ve used the latest version of

      [Read more...]
    Report on MySQL User Camp, Bangalore on 20th June, 2014
    Employee_Team +1 Vote Up -0Vote Down

    MySQL User Camp Bangalore organized on 20th June, 2014 started as per plan. It was a good gathering. We got many users from different companies like Flipkart, CTS, CGI, Yahoo, Onze Technologies, Webyog and few other startups. Apart from this we also got 2 Mysql customers this time from UID Aadhar project managed by HCL.

    Event started on its scheduled time with a welcome speech by Srinivasarao Ravuri, (Senior Manager, Software Development at MySQL India) . He thanked all the attendees for coming followed by a brief agenda and handed over the mic to the speakers for presentation.

    It was followed by a talk on ” MySQL 5.7 New

      [Read more...]
    Sharding & HA – MySQL Fabric Webinar Replay + Q&A
    Employee +2 Vote Up -0Vote Down

    On 19th June 2014, Mats Kindahl and I presented a free webinar on why and how you should be using MySQL Fabric to add Sharding (scaling out reads & writes) and High Availability to MySQL. The webinar replay is available here (http://www.mysql.com/news-and-events/web-seminars/mysql-fabric-high-availability-automated-sharding-for-mysql/" target="_blank). This blog post includes a transcript of the questions raised during the live webinar together with the responses given – if you’re questions aren’t answered already then please feel free to post them

      [Read more...]
    Webinar – Monitoring MySQL and MariaDB databases with MONyog. Register now
    +0 Vote Up -0Vote Down

    Monitoring MySQL and MariaDB databases without a powerful tool like MONyog can be challenging. However, if you already use MONyog you might not be using it to it’s full potential. In this webinar, we will introduce you to the entire feature set of MONyog followed by a Q&A session.

    You’ll also be delighted to know that one lucky winner gets MONyog Ultimate worth $399 for free. So, make sure you book your spot.

    Date: Tuesday, July 8, 2014
    Time: 10:00 am PT
    Presenter: Rohit Nadhani (CEO, Webyog)
    Register your spot for free




      [Read more...]
    Mountain Moodle Moot and MySQL in Montana
    Employee +1 Vote Up -0Vote Down

    MySQL is a proud sponsor of the Mountain Moodle Moot, July 9-11, 2014 – Helena, Montana. There will be sessions back-to-back covering query tuning, system tuning, and little known tricks using MySQL Workbench. This years Moot is already SOLD OUT.

    Moodle is a learning management system and very popular with many schools across the world.

    There are 3 three amazing social events planned for Friday afternoon – sponsored by Oracle/MySQL. Lunch, a tour train ride and a great social at the Blackfoot Brewery complete with tour and brews.

    If you have your ticket and want me to cover anything specific in my sessions, please let me know!



      [Read more...]
    Free seminar in Tallinn, Estonia: "Developing modern applications using MySQL" with Ronald Bradford
    +2 Vote Up -0Vote Down

    Fre MySQL seminar on 27. august 2014 @ 13:00. Announcement by Oracle User Group Estonia:

    Developing modern applications using MySQL.

    In this seminar series learn how to best use MySQL for your existing and new development requirements with leading MySQL expert and Oracle Ace Director Ronald Bradford.

    These presentations provide a detailed review of the essential lifecycle components for developing a successful software application and offer a checklist for your company to review the design, development, deployment and support of your business applications with MySQL.

    The presentations include:

    • Effective MySQL Architecture and Design Practices
    • Effective Software Development with MySQL
    • Effective Web Site Operations
    • Upcoming MySQL
      [Read more...]
    Previous 30 Newer Entries Showing entries 61 to 90 of 16140 Next 30 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.