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 30 of 32769 Next 30 Older Entries
Oklahoma City MySQL Group Forming
+1 Vote Up -0Vote Down

I’m excited to learn, just one day before the event, that Oklahoma City has formed a MySQL User Group. OKCMySQL.org

July 23, 2014 will be the inaugural meet-up for the OKC MySQL user group. As a special guest speaker, Peter Zaitsev (CEO of Percona and co-author of High Performance MySQL) will be giving a presentation on “Best Indexing Practices“, followed by a Q/A session.

Time is very short.  RPVP on Meetup.

I hope to see you at The Paramount – 701 West Sheridan, Oklahoma City, OK (

  [Read more...]
Inaugural Meet-up Oklahoma City MySQL Meetup
Employee +1 Vote Up -0Vote Down

The inaugural Meet-up Oklahoma City MySQL Meetup is Wednesday, July 23, 2014!
As a special guest speaker, Peter Zaitsev (CEO of Percona and co-author of High Performance MySQL) will be giving a presentation on “Best Indexing Practices”, followed by a Q/A session.

Please RSVP if you plan to attend so we can get a good headcount for food and beverages that will be provided and as always, please spread the word to friends or colleagues in the industry.

It should be a great night and great first event for the MySQL user group in OKC!

  [Read more...]
Reference architecture for a write-intensive MySQL deployment
+0 Vote Up -0Vote Down

We designed Percona Cloud Tools (both hardware and software setup) to handle a very high-intensive MySQL write workload. For example, we already observe inserts of 1bln+ datapoints per day. So I wanted to share what kind of hardware we use to achieve this result.

Let me describe what we use, and later I will explain why.


  • Chassis: Supermicro SC825TQ-R740LPB 2U Rackmount Chassis
  • Motherboard: Supermicro X9DRI-F dual socket
  • CPU: Dual Intel Xeon Ivy Bridge E5-2643v2 (6x 3.5Ghz cores, 12x HT cores, 25M L3)
  • Memory: 256GB (16x 16GB 256-bit quad-channel) ECC registered DDR3-1600
  • Raid: LSI MegaRAID 9260-4i 4-port 6G/s hardware RAID controller, 512M buffer
  • MainStorage: PCIe SSD HGST FlashMAX II 4.8TB
  • Secondary
  [Read more...]
Announcing ClusterControl Support for MariaDB 10
+0 Vote Up -0Vote Down
July 22, 2014 By Severalnines

We just wanted to make it official: Severalnines ClusterControl now supports MariaDB 10!


As most of you know will know by now, MariaDB 10 is the newest and most advanced version of the popular MariaDB relational database system. Whilst remaining application-compatible with the MySQL database, it adds many new capabilities to address the most challenging web and enterprise application use cases. Cluster deployments would be based on MariaDB Galera Cluster 10, which is a complete merge of MariaDB 10.0.12 and Galera Cluster. 


ClusterControl for MariaDB Clusters


  [Read more...]
#DBHangOps 07/24/14 -- More Indexing!
+1 Vote Up -0Vote Down
#DBHangOps 07/24/14 -- More Indexing!

Hello everybody!

Join in #DBHangOps this Thursday, July, 24, 2014 at 11:00am pacific (18:00 GMT), where we pick up on our last conversation about indexing:

  • Indexing
    • More discussion on geo spatial indexes
    • Fulltext indexing and ranking
    • MariaDB indexing features (From Gerry!)
    • Anything else indexing!

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!

MySQL Connector/NET 6.9.2 RC has been released
Employee +1 Vote Up -0Vote Down

Dear MySQL users,

MySQL Connector/Net 6.9.2 a new version of the all-managed .NET driver for MySQL has been released. This is a RC release for 6.9.x and is not recommended for production environments.

It is appropriate for use with MySQL server versions 5.5-5.7.

It is now available in source and binary form fromhttp://dev.mysql.com/downloads/connector/net/#downloadsandmirrorsites

(note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

Enjoy and thanks for the support!

On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team.

Percona XtraDB Cluster 5.6.19-25.6 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on July 21st 2014. Binaries are available from downloads area or from our software repositories. We’re also happy to announce that Ubuntu 14.04 LTS users can now download, install, and upgrade Percona XtraDB Cluster 5.6 from

  [Read more...]
MySQL for Visual Studio 1.2.2 RC has been released
Employee +2 Vote Up -0Vote Down
Dear MySQL users,
MySQL for Visual Studio is a product including all of the Visual Studio integration. The 1.2.2 version is a release candidate release of this product which is feature complete but still can contain minor bugs and is not suitable for production environments.
This version is appropriate for use with MySQL server versions 5.5-5.6.
+1 Vote Up -1Vote Down

From another web page:

"I'm not sure that loading a 1GB dump file into MySQL is a particularly good idea - it's not the most stable piece of software and I've had issues with smaller dumps than that before." March 29, 2013


It really irritates me when people says stupid things when the problem is their own incompetence or inexperience. Now let's think about this for just a second. MySQL is certainly one of the most popular databases powering the Internet. It is used extensively in tiny little sites like Google and Facebook. It is far from unstable. I routinely work on systems that have uptimes of many months if not years. Normal behavior is that the server is up until it needs be upgraded. I have worked on systems that executes tens of thousands of queries a second as a typical part of their usage patterns. And I have loaded SQL dump files that where well over 100

  [Read more...]
InfiniDB Expands Global Partner Program
+0 Vote Up -0Vote Down

InfiniDB Adds New Resources and Incentives for Channel Partners, Value Added Resellers and System Integrators to Sell and Build Applications with the InfiniDB High Performance Analytic Database

How To Install Nginx With PHP And MySQL (LEMP Stack) On CentOS 7
+0 Vote Up -0Vote Down

How To Install Nginx With PHP And MySQL (LEMP Stack) On CentOS 7

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a CentOS 6.5 server with PHP support (through PHP-FPM) and MySQL (Mariadb) support.

Setting up and Using MySQL Replication
Employee_Team +1 Vote Up -0Vote Down

MySQL Replication allows servers to copy changes from one instance to another. Take the MySQL for Database Administrators course to learn about replication, including:

  • How to set up a replication environment
  • Complex topologies
  • Replication types
  • Global transaction IDs (GTIDs)
  • MySQL Utilities
  • Logs and threads

Replication is one of the many topics covered in the MySQL for Database Administrators course. You can take this 5-day instructor-led course as  

  [Read more...]
A schema change inconsistency with Galera Cluster for MySQL
+0 Vote Up -0Vote Down

I recently worked on a case where one node of a Galera cluster had its schema desynchronized with the other nodes. And that was although Total Order Isolation method was in effect to perform the schema changes. Let’s see what happened.


For those of you who are not familiar with how Galera can perform schema changes, here is a short recap:

  • Two methods are available depending on the value of the wsrep_OSU_method setting. Both have benefits and drawbacks, it is not the main topic of this post.
  • With TOI (Total Order Isolation), a DDL statement is performed at the same point in the replication flow on all nodes, giving strong guarantees that the schema is always identical on all nodes.
  • With RSU (Rolling Schema Upgrade), a DDL statement is not replicated to the other nodes.
  [Read more...]
MySQL Type Conversion Rules
+1 Vote Up -0Vote Down

When you send a query to MySQL, you usually don't need to think explicitly about the types of the expressions in your query. If you compare this to a lot of programming languages, you'll find that it's not always the way things work. In strongly typed languages like Java, for example, typing is very strict.

In this respect, MySQL is much more like a dynamically typed language such as PHP or Perl --- a DWIM (do what I mean) typing system. Yet, internally, every expression in MySQL has a type, and it does conversions amongst them as needed.

Sometimes, you might wonder how does this query work and exactly what's happening to the variables in these expressions? Importantly, does it always work right?

Examples of MySQL Type Conversion


  [Read more...]
The Battle Begins…. Which Cloud Provider will Reign Supreme?
+0 Vote Up -0Vote Down

Place your bets now – it’s gonna be a good fight. The cloud is the arena where the next big tech giant battles will be taking place.. We’ll have to sit down as watch as the go head-to-head to win the customers who have started the mass migration to the cloud.

If you are thinking of migrating your databases to cloud, your vote will count towards determining the winner. As you evaluate your options, we suggest you consider these guys first and foremost.


Amazon Web Services
  • Amazon DynamoDB provides a scalable, low-latency NoSQL online Database Service backed by SSDs.
  • Amazon ElastiCache provides in-memory caching for web applications. This is Amazon’s
  [Read more...]
Decoding (encrypted) MySQL traffic with Wireshark
+1 Vote Up -0Vote Down
In a comment on my post about Using SSL with MySQL xiaochong zhang asked if it is possible to decode SSL/TLS encrypted MySQL traffic. The short answer is: It depends.

To test this we need a MySQL server which is SSL enabled. I used MySQL Sandbox to create a sandboxed 5.6.19 server. Then I used mysslgen to create the config and the certificates.

$ make_sandbox 5.6.19
$ ./mysslgen.py --config=sandboxes/msb_5_6_19/my.sandbox.cnf --ssldir=sandboxes/msb_5_6_19/ssl

This assumes there already is a extracted tarball of MySQL 5.6.19 in ~/mysql/5.6.19

The mysslgen.py script will return a message with the changes you should make in your mysqld and client sections of the my.sandbox.cnf file. Then

  [Read more...]
MariaDB 10.1.0 Overview and Highlights
+0 Vote Up -0Vote Down

MariaDB 10.1.0 was recently released, and is available for download here:


This is the first alpha release of MariaDB 10.1, so there are a lot of new changes and functionalities added, which cover a wide variety of areas such as: Performance, InnoDB/XtraDB, WebScaleSQL, Optimizer, Security, Storage Engine functionality, & Administration Improvements.

These are 9 of the most notable changes in MariaDB 10.1.0 (but do check out the release notes and changelogs below for the full list of changes):

  • InnoDB: Allow > 16K pages on InnoDB – InnoDB now allows page size to be configured as 16K, 32K and 64K. Note that single row size must be
  • InnoDB:
  •   [Read more...]
    MySQL Enterprise Monitor 3.0.13 has been released
    Employee_Team +0 Vote Up -0Vote Down

    We are pleased to announce that MySQL Enterprise Monitor 3.0.13 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud in a few weeks. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.

    You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.

    You will also find the binaries on the

      [Read more...]
    Systemtap solves phantom MySQLd SIGTERM / SIGKILL issue
    +0 Vote Up -0Vote Down

    The Percona Managed Services team recently faced a somewhat peculiar client issue. We’d receive pages about their MySQL service being unreachable. However, studying the logs showed nothing out of the ordinary…. for the most part it appeared to be a normal shutdown and there was nothing in anyone’s command history nor a cron task to speak of that was suspicious.

    This is one of those obscure and peculiar (read: unique) issues that triggered an old memory; I’d seen this behavior before and I had just the tool to catch the culprit in the act.

    Systemtap made diagnostics of this issue possible and I can’t state enough how much of a powerful and often under-utilized tool set systemtap really is.

    cat >

      [Read more...]
    OurSQL Episode 194: Common Schema, part 4
    +0 Vote Up -0Vote Down
    PodcastsPerformanceQuery OptimizationServer Tuning

    This week we continue our series on Common Schema and talk about different ways to look at the processlist, help with the query profiler, and some internal Common Schema tables. Ear Candy is about RHEL 7.0 using MariaDB, and At the Movies is The Human Postmortem.

    OurSQL Episode 193: Common Schema, part 3
    +0 Vote Up -0Vote Down
    PodcastsServer Tuning

    This week we continue our discussion about Common Schema by talking about security views and schema analysis views. Ear Candy is that apt repositories for MySQL are available, and At the Movies is about copyright vs. civil liberties.

    MySQL Webinar: MySQL EXPLAIN, explained
    Employee +0 Vote Up -0Vote Down
    Some time ago, Matt Lord and I delivered a webinar on the MySQL EXPLAIN feature.  This webinar is available for on-demand access here (http://www.mysql.com/news-and-events/web-seminars/mysql-explain-explained/).  Based on the questions we got during the webinar, I want to emphasize that EXPLAIN does not execute the query, it only determines the query plan for the query.  Hence, EXPLAIN will not be able to evaluate how good the chosen query plan actually is.

    If you have questions on this topic after listening to this webinar, feel free to ask questions; either as comments on this blog or at the MySQL Optimizer Forum.

    You can also access other webinars on MySQL (http://www.mysql.com/news-and-events/on-demand-webinars/). New webinars will be announced here (http://www.mysql.com/news-and-events/web-seminars).
    Hadoop BoF Session at OSCON
    +0 Vote Up -0Vote Down

    I have a BoF session next week at OSCON next week:

    Migrating Data from MySQL and Oracle into Hadoop

    The session is at 7pm Tuesday night – look for rooms D135 and/or D137/138.

    Correction: We are now in  E144 on Tuesday with the Hadoop get together first at 7pm, and the Data Migration to follow at 8pm.

    I’m actually going to be joined by Gwen Shapira from Cloudera, who has a BoF session on Hadoop next door at the same time, along with Eric Herman from Booking.com. We’ll use the opportunity to talk all things Hadoop, but particularly the ingestion of data from MySQL and other databases into the Hadoop datastore.

    As always, it’d be great to meet anybody interested in Hadoop at the BoF, please come along and

      [Read more...]
    Connector/ODBC 5.3
    +0 Vote Up -0Vote Down
    Connector/ODBC 5.3 (5.3.4 GA, published on Friday, 18 Jul 2014)
    Q&A: Even More Deadly Mistakes of MySQL Development
    +1 Vote Up -0Vote Down

    On Wednesday I gave a presentation on “How to Avoid Even More Common (but Deadly) MySQL Development Mistakes” for Percona MySQL Webinars.  If you missed it, you can still register to view the recording and my slides.

    Thanks to everyone who attended, and especially to folks who asked the great questions.  I answered as many as we had time for

      [Read more...]
    Update on MySQL on POWER8
    +2 Vote Up -0Vote Down

    About 1.5 months ago I blogged on MySQL 5.6 on POWER andtalked about what I had to poke at to make modern MySQL versions run and run well on shiny POWER8 systems.

    One of those bugs, MySQL bug 47213 (InnoDB mutex/rw_lock should be conscious of memory ordering other than Intel) was recently marked as CLOSED by the Oracle MySQL team and the upcoming 5.6.20 and 5.7.5 releases should have the fix!

    This is excellent news for those wanting to run MySQL on SMP systems that don’t have an Intel-like memory model (e.g. POWER and MIPS64).

    This was the most major and invasive patch in the patchset for MySQL on POWER. It’s

      [Read more...]
    Brainiac Corner with Jeremy Tinley
    +0 Vote Up -0Vote Down

    The Brainiac Corner is a format where we talk with some of the smartest minds in the system, database, devops, and IT world. If you have opinions on pirates, or anything else related, please don't hesitate to contact us

    Today, we interview Jeremy Tinley, the current Database Administrator at Etsy. He is a huge fan of puns and jokes. His favorite today is "A DBA walks into a bar and sees two tables. He says 'Can I join you?'" He gets randomly preselected for TSA precheck lines more than anyone else he knows. If you are interested in his thoughts, connect through Twitter.

    How did you get from

      [Read more...]
    Recover after DROP TABLE. Case 2
    +1 Vote Up -0Vote Down


    In the previous post we described the situation when TwinDB recovery toolkit can be used to recover accidentaly dropped table in the case innodb_file_per_table=OFF setting.
    Now we consider another situation. Let’s assume that mysql server has setting innodb_file_per_table=ON. This option tells InnoDB to store each table with user in a separate data  file.

    We will use for recovery test the same database sakila, that was used in the previous post.

    root@test:/var/lib/mysql/sakila# ll
    total 23468
    drwx------ 2 mysql mysql     4096 Jul 15 04:26 ./
    drwx------ 6 mysql

      [Read more...]
    High Availability with mysqlnd_ms on Percona XtraDB Cluster
    +1 Vote Up -0Vote Down

    This is the second part of my series on High Availability with mysqlnd_ms. In my first post, “Simple MySQL Master HA with mysqlnd_ms,” I showed a simple HA solution using asynchronous MySQL replication. This time we will see how to leverage an all-primary cluster where you can write to all nodes. In this post I used Percona XtraDB Cluster, but you should also be able to do the same with MySQL NDB Cluster or Tungsten Replicator.

    To start with, here is the mysqlnd_ms configuration I used:

    .  All of these files are available from my

      [Read more...]
    Oracle Critical Patch Update for MySQL
    +1 Vote Up -0Vote Down
    Oracle has released the Critical Patch Update (CPU) for July 2014. The Oracle MySQL Risk Matrix lists 10 security fixes.

    It took me some time to understand the subcomponent names. So here is the list with the full name of each subcomponent:

    SubcomponentFull nameSRFTSServer: Full Text SearchSRINFOSCServer: INFORMATION_SCHEMASRCHARServer: Character setsENARCEngine: ArchiveSROPTZRServer: OptimizerSRREPServer: ReplicationSRSPServer: Stored ProcecureENFEDEngine: Federated
    I don't think there is anything really important in the list, but it might be a good trigger to update to the latest release.

    Upgrading should be easy especially if you're using the APT or

      [Read more...]
    Showing entries 1 to 30 of 32769 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.