Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 34994 10 Older Entries
Orchestrator visual cheatsheet, TL;DR the "smart" way
+0 Vote Up -0Vote Down

Orchestrator is really growing. And the amount of users (DBAs, sys admins) using it is growing. Which gives me a lot of immediate feedback in the form of "Look, there's just too many options to move slaves around! Which ones should we use?"

TL;DR look at the two visualized commands below

They are enough

The "smart" commands to end all commands

So all relocation commands are important, and give you fine-grained, pin-pointed control of the method of topology refactoring. However, most of the …

  [Read more...]
How MySQL-Sandbox is tested, and tests MySQL in the process
+0 Vote Up -0Vote Down

MySQL-Sandbox is a great tool for testing a new release, and in fact this is what I do when a new MySQL tarball becomes available. I don't think many people are aware of the full testing capabilities of the sandbox, though.

When you think about testing, you may just think of creating a sandbox with the new tarball, and then hammering it with your pet procedure. That works, of course, as the main purpose of MySQL-Sandbox is to allow you to do just that. There is, however, a full test suite that can tell you in a short while if your tarball is compatible with the past or not.

  [Read more...]
Evaluating MySQL Parallel Replication Part 3: Benchmarks in Production
+0 Vote Up -0Vote Down

Tue, 2015-09-01 11:17jeanfrancoisgagne

Parallel replication is a much-expected feature of MySQL. It is available in MariaDB 10.0 and in MySQL 5.7. In this 3rd post of the series, we present benchmark results from Booking.com production environments.

This is a repost of Jean-François Gagné's blog post on blog.booking.com.

Note: this post has an annex: …

  [Read more...]
Orchestrator 1.4.340: GTID, binlog servers, Smart Mode, failovers and lots of goodies
+0 Vote Up -0Vote Down

Orchestrator 1.4.340 is released. Not quite competing with the MySQL latest changelog, and as I haven't blogged about orchestrator featureset in a while, this is a quick listing of orchestrator features available since my last publication:

  • Supports GTID (Oracle & MariaDB)
    • GTID still not being used in automated recovery -- in progress.
    • enable-gtid, …
  [Read more...]
Booking.com’s Jean-François Gagné on Percona Live Amsterdam
+0 Vote Up -0Vote Down

Booking.com, one of the world’s leading e-commerce companies, helps travels book nearly 1 million rooms per night. Established in 1996, Booking.com B.V. guarantees the best prices for any type of property, from small, family-run bed and breakfasts to executive apartments and five-star luxury suites.

The travel website is also a dedicated contributor to the MySQL and Perl community. Other open source technologies include CentOS Linux, Nginx, python, puppet, Git and more.

A Diamond sponsor of Percona Live Amsterdam Sept. 21-23, you can meet the people who power Booking.com at booth 205. Enter promo …

  [Read more...]
First Release of dbForge Data Generator for MySQL
+0 Vote Up -0Vote Down

Today, Devart is proud to announce the release of a new product – dbForge Data Generator for MySQL v1.0!

Cached linkbench performance for MySQL 5.7.8, 5.6, WebScale and MyRocks
+0 Vote Up -0Vote Down

This extends previous results for Linkbench to compare performance for a cached database with concurrent clients. My conclusions are:

  • InnoDB compression in the Facebook patch for MySQL 5.6 is much faster for insert-heavy workloads than the same feature in upstream 5.6 and 5.7. Too bad those changes might not reach upstream
  • InnoDB …

  [Read more...]
High-load clusters and desynchronized nodes on Percona XtraDB Cluster
+0 Vote Up -0Vote Down

There can be a lot of confusion and lack of planning in Percona XtraDB Clusters in regards to nodes becoming desynchronized for various reasons.  This can happen a few ways:

  [Read more...]
MySQL replication in action - Part 5 - parallel appliers
+0 Vote Up -0Vote Down

Previous episodes:

MySQL replication monitoring 101MySQL replication in action - Part 1: GTID & CoMySQL replication in action - Part 2 - Fan-in topologyMySQL replication in action - Part 3 - All-masters P2P …  [Read more...]
Unexpected Memory Consumption for Bulk Index Creation in InnoDB (MySQL)
+1 Vote Up -0Vote Down

In my last Booking.com Hackathon, I worked on MyISAM vs InnoDB for data loading (LOAD DATA IN FILE) and bulk index creation.  My motivation was the following: knowing that some are still using MyISAM for this particular use-case, I wanted to verify/understand if/why InnoDB is slower than MyISAM.  I do not yet have complete results on this specific subject but I found some interesting things that

Showing entries 1 to 10 of 34994 10 Older Entries

Planet MySQL © 1995, 2015, 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.