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 …

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 …

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:

1. Performance Diagnosis
2. SQL Optimization
3. 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 …

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...

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

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...

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 …

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 …

Join us for a webinar on MySQL & Docker this Wednesday May 13th, 2020.  

MySQL is deployed on the biggest social media platforms and their reach is global. Development often includes virtualized container-style level like Docker and Kubernetes. 

In this session we will look into all the containerized solutions that are available, via MySQL Community or the MySQL Enterprise Edition, configuring InnoDB Cluster environments with our app, or even running MySQL Cluster Carrier Grade Edition.

SPEAKER: Keith Hollman. MySQL Principal Consultant

DATE: May 13, 2020

TIME: 10:00 AM GMT/UTC (European Time)

To attend it live or to be informed on when it will be available on-demand:

Register …

Introducing our new website and its many new features and content elements: the home of Continuent - the MySQL Availability Company.

Tags:  Continuent MySQL announcement new website mysql availability tungsten clustering tungsten replicator