Protective convenience
Recent versions of MySQL has an added security feature, the –login-path option. This feature puts your username and password in an encrypted file, and you refer clients to this file instead of typing plain text passwords on the console, or putting them in scripts.

…

From June 16th to 17th, the MySQL Team will be attending and speaking at the Hong Kong Open Source Conference 2018.

Unfortunately I won’t be present but some of my great colleagues will be speaking about MySQL.

If you are planning to attend HKOSCon2018, don’t miss their talks:

• Heading to the New Stage of MySQL 8.0 – Ivan Ma
• Crossing Relation and Document Database using …

If you attended my latest Troubleshooting MySQL Concurrency Issues with Load Testing Tools webinar you learned how I exploit benchmarking tools to replicate locking issues and crashes. But I told you nothing about proper use of these tools: for reliable benchmarks. I did not tell you that for a reason… I am just a Support Engineer and not a benchmarking expert.

And I have a dream. I want to invite world famous MySQL benchmarking experts for a Percona webinar and ask them for their secrets. I have a pretty long list of my own questions, but in order to make 1-hour webinar productive, we need to concentrate on just a few of the hottest ones. Therefore I need your help.

Please add your questions into the comments field of this blog post. Then we will choose the most important and/or most popular of …

Historically the advice for MySQL Cluster has been to not colocate
the MySQL Server and the NDB data node for scalable applications.

There are still reasons to apply this principle in scalable setups
where the application isn't close to the data.

But with MySQL Cluster 7.6 we have added a number of reasons why it
makes sense to colocate the MySQL Server and the NDB data node.

Internally in the NDB development we have had a debate about whether
to integrate the NDB data node inside the MySQL Server. The reasons
for this is that the MySQL Server will be closer to the data. The
argument against is that the NDB data node and the MySQL Server are
designed with different recovery models. NDB data …

Recently during my several talks and trips to meet the MySQL Community and MySQL InnoDB Cluster, I realized that some important message was missing. I got a lot of questions about which version of Router or Shell people should use. There is some confusion about which version to use, it seems that people thinks they should use MySQL Shell 1.0.x and MySQL Router 2.1.x with MySQL 5.7 and use the 8.0.x version having the same version as MySQL 8.0. This is wrong !

In fact, whatever the version of MySQL InnoDB Cluster you are using, you should ALWAYS use the latest version of Router and Shell. Currently it’s 8.0.11. So yes, even if you use MySQL 5.7.22, you MUST use MySQL Router 8.0.11 and …

In MySQL Cluster 7.6 we introduced a new thread type in the NDB API.
Traditionally each cluster connection has one send thread to assist in sending messages to NDB, a receive thread that can
assist in receiving messages from NDB.
There is also a connection thread that listens to new connections and connects to the NDB data nodes.

There is also a set of user threads that is created by the application
that uses the NDB cluster connection.

Most of the sending is done by the user threads, the NDB API sending
thread is only used only when we are sending faster than the network
is able to handle.

We can process receive messages in the user threads or in the NDB
API receive thread. The default …

This Wednesday, 6th June 2018, I will be presenting at OpenExpo Europe in Madrid: Experiences with testing dev MySQL versions and why it’s good for you.  It’s always good to test new releases of MySQL and this presentation talks about why.  If you are at the conference then please come along and say hello. Update 2018-06-07.  … Continue reading I will be presenting at OpenExpoEurope in Madrid on Wednesday

In this blog, I will provide answers to the Q & A for the Troubleshooting MySQL Concurrency Issues with Load Testing Tools webinar.

First, I want to thank everybody for attending my May 23, 2018, webinar on troubleshooting tools for MySQL. The recording and slides for the webinar are available here. Below is the list of your questions that I was unable to answer fully during the webinar.

Q: What do you recommend for benchmarking NDB cluster? Which should be used and how?

A: The issue with benchmarking NDB cluster is not the tool choice, but …

This week is going to be a bit busy for MySQL team. We are going to be present at four conferences in Europe and two in the US. Please find them below:

• ​International PHP Conference, Berlin Germany, June 4-8, 2018

  • This time we are going to have a booth on the Bronze level in the expo area. The exhibition is only on Jun 5-6, 2018. You can find our colleague Mario Beck, the MySQL Sales Consulting Manager for EMEA at the stand. Come to our MySQL booth!!
• OpenExpo Europe, Madrid, Spain, June 6-7, 2018
  • Do not miss to come to the biggest OS show in Madrid! MySQL and Linux team will be there at the shared MySQL&Linux booth in the expo area. Also you can find our talks as follows in the …

In a spirit of open source, and furthering our stated mission to be the unbiased champions of open source database software, we’re excited to introduce this community initiative. Our aim is to provide a platform for members of the open source database community to exchange ideas and knowledge, make suggestions and sound out ideas.

In some ways, you might view it as an all year-round, online celebration of what delegates enjoy about the Percona Live Open Source Database Conference. Something of a misnomer since Percona Live – as many readers will already know – is not just about Percona Software but embraces all open source database technology.

So it will be with this blog space.

Who will write for the Percona community blog?

If you already blog, then maybe you don’t want to be providing content for this blog too. Then again – if you post great …