As indicated in a previous post, I am working on Planet [for the] MySQL Community for which I did a RFC on the Requirements. I am happy to announce the beta release of Planet [for the] MySQL Community using the Planet Pluto Free Feed Reader and (Static) Website Generator. If you are in a hurry, you can check it out at https://planet-beta-pluto.oursqlcommunity.org/. This post
May
14
2020
May
13
2020
This post was remaining in stand-by for a long time, specially that I was expecting that observed issues will be fixed soon. But time is going, and the problems are remaining. And I'm constantly asked "why, Dimitri, you're suggesting now to use XFS, while in the past you always suggested EXT4 ??" -- hope the following article will clarify you the "why" and maybe motivate you to do your own evaluations to see how well the things are working for you on your own systems under your own workloads..
NOTE : this will also clarify why the new Double Write did not appear in MySQL 8.0 in 2018, as it was planned, but only recently (http://dimitrik.free.fr/blog/posts/mysql-80-perf-new-dblwr.html)
Read more... (6 min remaining to read)
May
13
2020
I was testing the latest Percona XtraDB Cluster 8.0 (PXC) release which has the Galera 4 plugin, and I would like to share my experiences and thoughts on the Streaming Replication feature so far.
What Is Streaming Replication, in One Sentence?
In Galera 4, the large transaction could split into smaller fragments, and even before it got committed these fragments have been replicated to the other nodes and have already started the certification and apply process.
The manual describes all the pros and cons, but let’s see how it works. I have created a table with 10M rows and I am going to run some large updates on that.
First I have run the updates without Streaming Replication, and because it is disabled by …
[Read more]
May
13
2020
pt-online-schema-change emulates the way that MySQL alters tables internally, but it works on a copy of the table you wish to alter. It executes INSERT statements to import the data, that runs in a single connection to fill the new table. In this repository, there is a script called myloader_pt-osc.sh that uses myloader to execute parallel INSERTs, instead of using pt-online-schema-change internal tooling, but it also uses a patched version of pt-online-schema-change.
Patch pt-online-schema-change
There are 2 changes that we needed to perform on pt-online-schema-change:
1- Be able to stop the execution after the copy of the table is
created
2- Tell pt-online-schema-change that no data needs to be imported
We are …
[Read more]
May
12
2020
Join us for a webinar on Best Practices to Remotely Monitor MySQL.
As a DBA, the top 3 activities include, but are not limited to:
- Performance Diagnosis
- SQL Optimization
- Space Management
Coming across new technology can be a challenge and difficult to optimize in a hybrid database environment.
In this session, we’ll demonstrate how the technical aspects of MySQL RDBMS are quite similar to your existing database.
Find out what concepts are common to both, and what's different in the world’s most popular open source database.
SPEAKERS: Harsh Nayak, MySQL Solution Engineer
and
Henrique Lemes, MySQL Solution Engineer
DATE: May 26th, 2020
TIME: 11:00 AM PST (Pacific Time)
To attend it live or to get informed when it will be available …
[Read more]
May
12
2020
Join us for a webinar on Best Practices to Remotely Monitor MySQL. As a DBA, the top 3 activities include, but are not limited to: Performance Diagnosis SQL Optimization Space Management Coming across new technology can be a challenge and difficult to optimize in a hybrid database environment. In th...
May
12
2020
Join us for a webinar on how to Boost Performance with MySQL Document Store.
Overall performance of any application is dependent on how the database performs.
There are multiple factors that affect performance: how indexes are used, how queries are structured, how the data is modeled…the list goes on and on.
In this talk you’ll hear the benefits and learn how you can boost performance of your application with MySQL 8.0.
The webinar will cover many SQL/NoSQL use cases.
You will see how easy it is to migrate from other NoSQL databases to MySQL Document Store.
And finally, you will discover how enterprise tools can help you manage this hybrid model.
SPEAKERS: Tony Darnell, MySQL Solution Engineer
and
Bill Papp, MySQL Solution Engineer
DATE: May 19th, 2020
…[Read more]
May
12
2020
Join us for a webinar on how to Boost Performance with MySQL Document Store. Overall performance of any application is dependent on how the database performs. There are multiple factors that affect performance: how indexes are used, how queries are structured, how the data is modeled…the list goes o...
May
12
2020
Join us for a webinar on how to achieve compliance and Manage your data with MySQL Enterprise Audit.
Meeting database compliance and security is a top priority for many organizations. A security breach not only costs substantial fines and penalties, but it often leads to the organization’s users losing trust and confidence in the services.
Teams need to invest in the correct tools and processes to guarantee compliance and manage your organization’s data securely.
Join this webinar as we explore what makes the best compliance and data management strategies an organization should implement.
We will review MySQL tools that generate reports and dashboards to track and audit your database activity.
SPEAKERS: Lee Stigile, Director MySQL Solution Engineering …
[Read more]
May
12
2020
Percona Live Online Agenda Slot: Tue 19 May • New York 11:00 a.m. • London 4:00 p.m. • New Delhi 8:30 p.m.
Abstract
I will talk about the latest improvements in MySQL 8.0.20 and the MySQL Engineering Team’s steady progress with MySQL 8.0. These include solutions like Document Store, InnoDB Cluster, and InnoDB ReplicaSet where MySQL Router and MySQL Shell are playing an important role. All of these Oracle solutions are completely open source.
Why is your talk exciting?
This talk is exciting because we will be looking at all the latest features in MySQL 8.0 Sadly my time will be probably too short to detail them all and cover the open source code contributions we’ve received from users.
Who would benefit the most from your talk?
All MySQL users would benefit, whether newbies or veterans. You would be …
[Read more]