Showing entries 1 to 10 of 37732
10 Older Entries »
Scaling with ProxySQL Query Cache

MySQL Query Cache

Before writing about ProxySQL Query Cache, let's see what MySQL Query Cache is.

MySQL Query Cache is a very interesting feature that, quoting the documentation:

stores the text of a SELECT statement together with the corresponding result that was sent to the client. If an identical statement is received later, the server retrieves the results from the query cache rather than parsing and executing the statement again

It is a cache, so it is meant to improve performance. Although, it is not the magic bullet and it is not unusual to see severe performance degradation or random …

[Read more]
How To Write Exciting Conference Proposals

Most conference proposals are too boring, even when the speakers and topics are great. This is a pity. I think something about the process of submitting to a CfP sets a trap for most speakers. This post is my advice for avoiding that trap.

TL;DR: Your proposal should focus on your story about what you’ve done personally and what you’ve learned. Your story, not the topic. And, don’t tell us anything about the importance of the topic or how high the stakes are.

I’ve written twice before (1, 2) about how to write better conference proposals. But while recently reviewing another thousand or so proposals, I suddenly understood something simple that separates the boring ones from the exciting ones. And I realized …

[Read more]
How to break MySQL InnoDB cluster

A few weeks ago I started experimenting with MySQL InnoDB cluster. As part of the testing, I tried to kill a node to see what happens to the cluster.

The good news is that the cluster is resilient. When the primary node goes missing, the cluster replaces it immediately, and operations continue. This is one of the features of an High Availability system, but this feature alone does not define the usefulness or the robustness of the system. In one of my previous jobs, I worked at testing a commercial HA system and I've learned a few things about what makes a reliable system.

Armed with this knowledge, I did some more experiments with InnoDB Cluster. The attempt from my previous article had no other expectation than seeing operations continue with ease (primary node …

[Read more]
Percona Server for MySQL 5.7.18-15 is Now Available

Percona announces the GA release of Percona Server for MySQL 5.7.18-15 on May 26, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository.

Based on MySQL 5.7.18, including all the bug fixes in it, Percona Server for MySQL 5.7.18-15 is the current GA release in the Percona Server for MySQL 5.7 series. Percona’s …

[Read more]
Monitoring with Artificial Intelligence and Machine Learning

Artificial intelligence and machine learning (AI and ML) are so over-hyped today that I usually don’t talk about them. But there are real and valid uses for these technologies in monitoring and performance management. Some companies have already been employing ML and AI with good results for a long time. VividCortex’s own adaptive fault detection uses ML, a fact we don’t generally publicize.

AI and ML aren’t magic, and I think we need a broader understanding of this. And understanding that there are a few types of ML use cases, especially for monitoring, could be useful to a lot of people.

I generally think about AI and ML in terms of three high-level results they can produce, rather than classifying them in terms of how they achieve those results.

1. Predictive Machine Learning

Predictive machine learning is the most familiar use case in …

[Read more]
What About ProxySQL and Mirroring?

In this blog post, we’ll look at how ProxySQL and mirroring go together.

Overview

Let me be clear: I love ProxySQL, and I think it is a great component for expanding architecture flexibility and high availability. But not all that shines is gold! In this post, I want to correctly set some expectations, and avoid selling carbon for gold (carbon has it’s own uses, while gold has others).

First of all, we need to cover the basics of how ProxySQL manages traffic dispatch (I don’t want to call it mirroring, and I’ll explain further below).

ProxySQL receives a connection from the application, and through it we can have a simple SELECT or a more complex transaction. ProxySQL gets each query, passes them to the Query Processor, processes them, identifies if a query is mirrored, duplicates the whole MySQL session ProxySQL internal object and associates it to a mirror queue (which refer to a …

[Read more]
Using MariaDB MaxScale 2.1 Regex Filter for Migrations

Using MariaDB MaxScale 2.1 Regex Filter for Migrations anderskarlsson4 Thu, 05/25/2017 - 13:13

Migrating applications from one database system to another is sometimes easy and sometimes not. But they are hardly ever effortless. Among the obvious issues are schema and data, migrating from one datatype to another, with slightly different behavior and semantics is one thing and another is migrating the actual data, is it UTF8 and if so how many bytes? What is the collation? What is the required accuracy of numeric types?

And on top of this are things such as triggers, stored procedures and such. Not to mention performance tuning and the optimal way to construct SQL statements.

Speaking of SQL statements, we have application code also. Yes, most databases have some kind of application running on them, often more than one, and these access the database using SQL over some kind of API such as JDBC, ODBC or some proprietary …

[Read more]
MySQL for Excel 1.3.7 has been released

Dear MySQL users,

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.7. This is a maintenance release for 1.3.x. It can be used for production environments.

MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as:

  • Importing MySQL data into Excel
  • Exporting Excel data directly into MySQL to a new or existing table
  • Editing MySQL data directly within Excel

MySQL for Excel is installed using the MySQL Installer for Windows.The …

[Read more]
Import a JSON Data Set into MySQL

JSON Data Into MySQLJSON is now a very hot format for sharing data and MySQL's 5.7 Data Set is now a very hot way of storing that data. But I have had some requests on getting a raw JSON data set into MySQL. So lets start with Global Airfields data from the Awesome JSON Datasets collection. airfields.jsonThe data is in a file named airfields.json and comes as one very long line. MySQl has now way of taking out the individual JSON documents from that string and putting them in a row. The jq tool will let use see the data broken down into objects. Try jq -C '.[]' airfields.json and you will see individual documents colorized.


{
"ID": "LFOI",
"ShortName": "ABBEV",
"Name": …
[Read more]
Percona Software and Roadmap Update with CEO Peter Zaitsev: Q2 2017

This blog post is a summary of the Percona Software and Roadmap Update – Q2 2017 webinar given by Peter Zaitsev on May 4, 2017. This webinar reflects changes and updates since the last update (Q1 2017).

A full recording of this webinar, along with the presentation slide deck, can be found here.

Percona Software

Below are the latest and upcoming features in Percona’s software. All of Percona’s software is 100% free and open source, with no …

[Read more]
Showing entries 1 to 10 of 37732
10 Older Entries »