A couple of days ago I wrote about one of my forays into MDX land
(Retrieving denormalized tabular results with
MDX). The topic of that post was how to write MDX so as to
retrieve the kind of flat, tabular results one gets from SQL
queries. An essential point of that solution was the MDX
Ancestor() function.
I stumbled upon the topic of my previous blogpost while I was
researching something else entirely. Creating flat tables and
looking up individual ancestors is actually a rather specific
application of a much more general solution I found initially.
Pivot tables and the "Show Parents" functionalityGUI OLAP tools
typically offer a pivot table query interface. They let you drag
and drop measures and dimension items, like …
Data inconsistencies in replication environments are a pretty common. There are lots of posts that explain how to fix those using pt-table-checksum and pt-table-sync. Usually we only care about the data but from time to time we receive this question in support:
How can I check the table definition consistency between servers?
Replication also allow us to have different table definition between master and slaves. For example, there are some cases that you need some indexes on slaves for querying purposes but are not really needed on the master. There are some other cases where those differences are just a mistake that needs to be fixed.
…
[Read more]Updated 2015-04-25: add the link to the slides of my PLMCE talk and a link to a bug number.
MaxScale 1.1.0 is out and includes the new Binlog Server module. This is the first post in s series of three. The two others are about Operations and High Availability. The links to the 2 other posts are at the end of this page.
In this post, I present how to install and configure MaxScale as a Binlog
Note: DO NOT use this procedure in production, this is a proof of concept (POC). MaxScale 1.1.0 does not yet fully support that procedure and things could go wrong in some situations (see at the end of the post for the details).
In my talk at PLMCE 2015, I presented an architecture to promote a slave as a new master without touching any other slave and I claimed that I tested it. This HOWTO
In the Install and Configure HOWTO, we learned how to install and configure a MaxScale Binlog Server. In this HOWTO, I will present the common operations that you might need to perform when using this software. Those operations include:
Purging Binary Logs, Chaining Binlog Servers, Saving Binary Log Files in the Non-Default Directory, Downloading Binary Logs other than First, Listing Connected
Today, Zend and Microsoft announced a strategic partnership that will transform developer productivity in the cloud. Before I share the details of this news, I’d like to cover some background on Zend and Microsoft’s past collaboration to provide additional context on why today’s announcement is significant for both Zend and Microsoft!
Early Stealth Relationship
In 2001, a small Microsoft SWAT team focused on winning more Web share for Windows Server reached out to the PHP Group. They invited us for a few days to Redmond with the goal of boosting PHP support for Windows. Their motivation was simple: PHP on Linux had already dominated a major part of Web share and they were interested in selling more Windows Servers into that market. Hence, PHP needed to run well on Windows Server. We made some significant improvements during the few days in Redmond, but that forward-looking team met some internal opposition for …
[Read more]MySQL provides hundreds of status counters, but how do you make sense of all that monitoring data?
If you’re in Operations and your job is to monitor the health of MySQL/MariaDB Galera Cluster or Percona XtraDB Cluster, then this webinar is for you. Setting up a Galera Cluster is fairly straightforward, but keeping it in a good shape and knowing what to look for when it’s having production issues can be a challenge.
Status counters can be tricky to read …
- Which of them are more important than others?
- How do you find your way in a labyrinth of different variables?
- Which of them can make a significant difference?
- How might a host’s health impact MySQL performance?
- How to identify problematic nodes in your cluster?
To find out more, please register for this new live webinar.
…
[Read more]The slides for my Improving Performance With Better Indexes presentation at Percona Live 2015 MySQL Conference and Expo are now available.
In this presentation I discuss how to identify, review and analyze SQL statements in order to create better indexes for your queries. This includes understanding the EXPLAIN syntax and how to create and identify covering and partial column indexes.
This presentation is based on the work with a customer showing the 95% improvement of a key 15 table join query running 15,000 QPS in a 25 billion SQL statements per day …
[Read more]It is my pleasure to announce that Percona has acquired Tokutek and will take over development and support for TokuDB® and TokuMX™ as well as the revolutionary Fractal Tree® indexing technology that enables those products to deliver improved performance, reliability and compression for modern Big Data applications.
At Percona we have been working with the Tokutek team since 2009, helping to improve performance and scalability. The TokuDB storage engine has been available for Percona Server for about a year, so joining forces is quite a natural step for us.
Fractal Tree indexing technology—developed by years of data science research at MIT, Stony Brook University and Rutgers University—is the new generation data structure which, for many workloads, leapfrogs traditional B-tree technology which was invented in 1972 (over 40 years ago!). It is also often …
[Read more]If you haven’t already heard, on the Tuesday morning of the 2015 Percona Live MySQL Conference and Expo it was announced that Tokutek is now part of the Percona family. This means TokuDB® for MySQL, and TokuMX™ for MongoDB are Percona products now; and that the Tokutek team is now part of the Percona team.
Percona’s well-deserved reputation for unparalleled customer service and support in the MySQL market makes them the perfect home for Tokutek’s ground-breaking products. And with the Tokutek acquisition, Percona can expand and extend their activities and offerings into the MongoDB market.
This is a win/win for NoSQL and MySQL fans alike.
More About Tokutek
Tokutek is the company that productized a new and revolutionary form of database indexing designed specifically for modern, Big Data applications. Based on data science research on new methods for high-performance data …
[Read more]