MySQL 8.0.13 was released this week. There are several exciting changes including functional indexes and using general expressions as the default value for your columns. So, I will recommend you to get MySQL 8.0.13 installed and try out the new features. You can read about changed in the release notes section of the MySQL documentation and in Geir’s release blog.
…
[Read more]
MySQL Shell is a command-line shell for MySQL Server that has the
capability for
interactive and batch code execution. It also
offers a wealth of APIs that make it easier and more efficient to
work with and manage MySQL servers. In 8.0.13, we made an effort
to make those APIs easily accessible straight from the command
line.…
Containers are eating the world. If you have built and deployed an application in production over the last few years, the odds are that you have deployed your code in containers. You might have created and deployed individual containers (Docker, Linux LXC, etc.) directly in the beginning, but quickly switched over to a container orchestration technology like Kubernetes (K8s) or Swarm when you needed to coordinate multi-node deployments and high availability (HA). In this container-driven world, what will the future of the application stack look like? Let’s start with what we need from this “future” application stack.
What Do We Need From This Future Application Stack?
We …
Enterprises require high availability for their business-critical applications. Even the smallest unplanned outage or even a planned maintenance operation can cause lost sales, productivity, and erode customer confidence. Additionally, updating and retrieving data needs to be robust to keep up with user demand.
Let’s take a look at how Tungsten Clustering helps enterprises keep their data available and globally scalable, and compare it to Amazon’s RDS running MySQL (RDS/MySQL).
Replicas and Failover What does RDS do?
Having multiple copies of a database is ideal for high availability. RDS/MySQL approaches this with “Multi-AZ” deployments. The term “Multi-AZ” here is a bit confusing, as enabling this simply means a single “failover replica” will be created in a different availability zone from the primary database instance. …
[Read more]Without our sponsors, it would be almost out of reach to deliver a conference of the size and format that everyone has come to expect from Percona Live. As well as financial support, our sponsors contribute massively by supporting their teams in presenting at the conference, and adding to the quality and atmosphere of the event. Having their support means we can present excellent in-depth technical content for the tutorials and talks, and that’s highly valued by conference delegates. This year, too, Amazon Web Services (AWS) sponsors the cloud track on day two, with a superb line up of cloud content.
Here’s a shout out to our sponsors, you’ll find more information on the Percona Live sponsors page:
Platinum
…[Read more]
In our previous blog on SCUMM dashboards, we looked at the MySQL overview dashboard. The new version of ClusterControl (ver. 1.7) offers a number of high resolution graphs of useful metrics, and we went through the meaning of each of the metrics, and how they help you troubleshoot your database. In this blog, we will look at the MySQL Replication dashboard. Let’s proceed on the details of this dashboard on what has to offer.
MySQL Replication Dashboard
The MySQL Replication Dashboard offers a very straightforward sets of graph that makes it easier to monitor your MySQL master and replica(s). Starting from the top, it shows the most important variables and information to determine the health of the replica(s) or even the master. This dashboard offers a very useful part when inspecting the health of the slaves or a …
[Read more]Welcome to MySQL 8.0.13. If you haven’t already read about all the great new updates please take a minute and read the announcement. Along with all the new updates in the server we have a full complement of connectors t hat are now available and I wanted to take a moment to share our updates.
First I want to go over the changes related to the X DevAPI, our new API that merges the great relational power of MySQL with our new Document Store. Unless specified, all of our MySQL 8.0 series connectors includes all the DevAPI updates.
DevAPI
Connection Pooling – One of the most expensive operations that a connector can do is to simply connect to the server. This is especially true if you are using SSL/TLS (and you should be!). So we wanted to make …
[Read more]As we already informed you on another blog posted on Oct 16, 2018, MySQL is going to have a MySQL talk at JavaScript (JSFoo) this year. This is our first time we are attending JSFoo, Bangalore, India and we hope our attendance will be very well welcomed! Do not miss the opportunity to come to listen the MySQL talk as follows:
More information and logistics can be found here.
We are looking forward to meeting & talking to you at JSFoo 2018!
As it was already announced on another blog posted on Oct 16, 2018, MySQL is a Bronze sponsor of Forum PHP show this year.
We are going to have a MySQL talk on "MySQL 8.0: What's new" given by Olivier Dasini, the Principal Sales Consultant. His talk is scheduled for October 26th @9:30-10:10am. You are very welcome to come to listen Olivier's talk & discuss MySQL topics with our staff at Forum PHP in Paris, France.
More information & logistics available at Forum PHP website.
We are looking forward to talking to you there!
In February I added a new feature to my Sysbench version that I
use in
my MySQL Cluster testing. This new feature adds a new column in
the
table called filter. It contains the same value as the primary
key.
With this new column I can easily change the range scan queries
in
sysbench from returning 100 rows to instead scan 100 rows
and
return 1 row. This means that sysbench can benchmark the
filtering
performance of the underlying database engine.
Next I ran tests where set the number of rows in the range
to
10.000 rows. This new test was a perfect vehicle to improve
performance
in NDB for scan filtering.
Filtering one row in 7.6.7 in this sysbench tests costs about 750
ns.
When I started out optimising these 750 ns of time I didn't
expect so
much improvement, but using perf it was possible to get
very
fine-grained …