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 151 to 180 of 32833 Next 30 Older Entries
MySQL Central @ OpenWorld Keynotes
Employee_Team +2 Vote Up -0Vote Down

A few weeks ago we announced the availability of the MySQL Central @ OpenWorld content catalog.

We're now pleased to announce additional keynotes delivered by MySQL power users. They will follow the "State of The Dolphin" keynote address by Oracle's Chief Corporate Architect Edward Screven and VP of MySQL Engineering Tomas Ulin, and include:

High Speed Event Logging at Booking.com
Nicolai Plum, Senior Systems Architect, will provide an

  [Read more...]
Testing MySQL FULLTEXT indexes in InnoDB using pt-upgrade
+0 Vote Up -0Vote Down

As I prepare to convert some MySQL tables with FULLTEXT indexes from MyISAM to InnoDB I want to verify that running a standard production query set against the tables will return the same results with InnoDB that it did with MyISAM. Since I read Matt Lord's blog post about the document relevancy rankings used for InnoDB full-text searches I knew to expect some differences when sorting by relevancy, so I want to focus on getting the same set of rows back, mostly ignoring the order in which the rows are returned.

Percona toolkit has a tool called pt-upgrade that works well for this purpose. I used 2 test servers with a copy of my production database. On one of the servers I left the

  [Read more...]
Munin graphing of MySQL
+0 Vote Up -0Vote Down

While there are many graphing tools out there and we’ve used Munin for a while now.

The MySQL plugin for Munin had fallen out of date and the show engine innodb status output changed in 5.5 making some bits of the plugin simply not work any more. Also the show global status has some extra variables so there was a need to create new graphs.

All of these are now in the 2.1.8+ development releases of Munin.

Here are samples of the new/updated graphs.


  [Read more...]
#DBHangOps 07/10/14 -- MySQL Index Types and more!
+0 Vote Up -0Vote Down
#DBHangOps 07/10/14 -- MySQL Index Types and More!

Check out the recording below!

Hello everybody!

Join in #DBHangOps this Thursday, July, 10, 2014 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

  • Indexes in MySQL
    • Geo-spatial
    • Hash indexes
    • Fractal Indexes (TokuDB)

Be sure to check out the #DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the google hangout on Thursday!

See all of you on Thursday!

Show notes


Spatial index resources

  [Read more...]
MaxScale 1.0-beta is out - Happy Birthday MaxScale!
+2 Vote Up -0Vote Down
It was a year ago, on a nice Sunday night of the English Summer (apologies for the oxymoron), that Mark Riddoch came to see me and together we headed to the Vansittart Arms, our local family pub round the corner. A pint of London Pride on one side and a Honey Dew on the other were the perfect add-on to Mark’s MacBook Pro, on which Mark was showing me the 0.1 version of MaxScale. It was the result of the joint efforts of Mark’s team, Massimiliano and Vilho, who had worked hard to bring to life the first version of something that I believe will be a natural addition to clusters of  [Read more...]
Sphinx in Docker. The basics.
+0 Vote Up -0Vote Down
With an ear to the interwebs, you’ll hear a few things about Docker. Docker is an open platform for developers and sysadmins to build, ship, and run distributed applications. In this blog post, I’m going to outline a very basic example of how to use Sphinx from within a Docker container. What is Docker? This [...]
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:



 Delivery Language


  [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...]
Setting up authentication en masse
+0 Vote Up -0Vote Down

Managing many hosts is quite challenging task. There are many tools to solve the problem. My favorite is pdsh.

Running a command across a set of hosts is as simple as following:

# pdsh -w 192.168.177.[201-208] -R ssh reboot

Together with dshbak (which is a part of pdsh package) you can do even cooler things. Like, check which systems have yum:

# pdsh -w 192.168.177.[201-208] -R ssh "which yum" | dshbak -c

Or which systems run older version of MySQL

# pdsh -w 192.168.177.[201-208] -R ssh "mysql -e \"SHOW VARIABLES LIKE 'version'\""  | dshbak -c
  [Read more...]
Percona XtraDB Cluster 5.6 Setup
+0 Vote Up -0Vote Down

Percona XtraDB Cluster (PXC) is a high availability and high scalability, solution for MySQL clustering. Percona Server, Percona Xtrabackup and Galera library for high availability integrated together as PXC. It provides synchronous, multi-master, and parallel replication. All the nodes of this cluster are ready to serve read/write request simultaneously.


VMs used for illustration. Here, I've used 1 centos node and 2 ubuntu nodes. In real world don't mix different OS. This is just for testing purpose. All nodes should be of the same configuration hardware/software.

1 Centos12           node1
2 Ubuntu13           node2
3 Ubuntu14
  [Read more...]
Abdel-Mawla Gharieb: Replication Troubleshooting - Classic VS GTID
+6 Vote Up -0Vote Down

In previous posts, I was talking about how to set up MySQL replication, Classic Replication (based on binary logs information) and Transaction-based Replication (based on GTID). In this article I'll summarize how to troubleshoot MySQL replication for the most common issues we might face with a simple comparison how can we get them solved in the different replication methods (Classic VS GTID).

There are two main operations we might need to do in a replication setup:

  • Skip or ignore a statement that causes the replication to stop.
  • Re-initialize a slave when the Replication is broke and could not be started anymore.

Skip or Ignore statement

Basically, the slave should be

  [Read more...]
Percona XtraDB Cluster 5.6 Setup
+0 Vote Up -0Vote Down

Percona XtraDB Cluster (PXC) is a high availability and high scalability, solution for MySQL clustering. Percona Server, Percona Xtrabackup and Galera library for high availability integrated together as PXC. It provides synchronous, multi-master, and parallel replication. All the nodes of this cluster are ready to serve read/write request simultaneously.

VMs used for illustration. Here, I've used 1 centos node and 2 ubuntu nodes. In real world don't mix different OS. This is just for testing purpose. All nodes should be of the same configuration hardware/software.

1 Centos12           node1
2 Ubuntu13           node2
3 Ubuntu14           node3

Adding repo's to the requisite

  [Read more...]
[Tuto] A real life Multi-Master use case with MariaDB
+1 Vote Up -0Vote Down

The goal of this tutorial is to show you how to use Multi-Master and aggregate databases with the same name but with different data from different masters.


  • master1 => a French subsidiary
  • master2 => a British subsidiary

Both have the same database (PRODUCTION) but the data are totally different:

We will start with 3 servers (2 masters and 1 slave), you can add more master if needed.

  • first master (aka ”’master1”’) => a French subsidiary
  • second master (aka ”’master2”’) => a British subsidiary
  • slave (multi-master) (aka
  [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...]
YAML code in Markdown
+0 Vote Up -0Vote Down

My friend Brian Aker noticed my post from the other day on Ansible and image building had some things in the YAML Ansible playbooks that looked broken. Sure enough, I didn't notice when proofreading that double {{ and }}

curly braces weren't showing up! That was definite breakage but upon verification of the playbook in my repo, it was not broken and I realized that my markdown in my Jekyll-based github pages website/blog had manged the YAML I inteded to talk about.

  [Read more...]
Installing Vagrant and Virtual box on Ubuntu 14.04 LTS
+0 Vote Up -0Vote Down

Vagrant is an open source tool for building complete virtual development environment. Very often, test environment is required for testing latest release and new tools. Also, reduces the time spent in re-building OS. By default, it uses virtualbox for managing the Virtualization. Vagrant act as a central place configuration for managing/deploying multiple reproducible virtual environment with the same configuration.

Installing Virtualbox:

$ sudo apt-get install virtualbox

Installing Vagrant:

$ sudo apt-get install vagrant

Install the dkms package to ensure that the VirtualBox host kernel modules (vboxdrv, vboxnetflt and vboxnetadp) are properly updated if the

  [Read more...]
MariaDB Galera Cluster 10 is now stable (GA)
+5 Vote Up -1Vote Down

A much awaited release from the MariaDB project is now stable (GA) – MariaDB Galera Cluster 10.0.12. This is a complete merge of MariaDB 10.0.12 and Galera Cluster, with additional features and bug fixes. This gives you the entire power of Galera Cluster as well as the benefits of all the MariaDB 10 features

This is the fourth release in the 10.0 Galera Cluster series, and for more changes, please review the

  [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.


  • 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.

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...]
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.
Recover InnoDB dictionary
+0 Vote Up -0Vote Down

Why do we need to recover InnoDB dictionary

c_parser is a tool from TwinDB recovery toolkit that can read InnoDB page and fetch records out of it. Although it can scan any stream of bytes recovery quality is higher when you feed c_parser with pages that belong to the PRIMARY index of the table. All InnoDB indexes have their identifiers a.k.a. index_id. The InnoDB dictionary stores correspondence between table name and index_id. That would be reason number one.

Another reason – it is possible to recover table structure from the InnoDB dictionary. When a table is dropped MySQL deletes respective .frm file. If you had neither backups nor table schema it becomes quite a challenge to recover the table

  [Read more...]
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...]
    See Per-Database Activity With VividCortex
    +0 Vote Up -0Vote Down

    Is your application multi-tenancy, where each tenant lives in its own database? We have such a scenario at VividCortex, and many of our customers do as well. Wouldn't it be nice to understand which tenants are causing more load than others, which are the noisy neighbors impacting others' experience, and so on? Well, now you can!

    We now support per-database metrics in Top Queries. You can change the Rank menu from Queries to Databases, and you will see a breakdown of database activity in the familiar format, all in 1-second resolution.

    As you can see from the Lock Waits column in the image, computed columns work as usual too, so you can quickly figure out which databases are consuming more resources such as CPU or IO in addition to the standard metrics (time,

      [Read more...]
    Previous 30 Newer Entries Showing entries 151 to 180 of 32833 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.