Percona’s Principal Support Engineer, Sveta Smirnova presents the webinar MySQL Test Framework for Troubleshooting on April 12, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4).

MySQL Test Framework (MTR) provides a unit test suite for MySQL. MySQL Server developers and contributors write the tests in the framework, and use them to ensure the build is working correctly.

I found that this isn’t the only thing that makes MTR useful. I regularly use it in my support job to help customers and verify bug reports.

With MySQL Test Framework I can:

• Create a complicated environment in a single step, and re-use it later
• Test the same …

Running databases on cloud infrastructure is getting increasingly popular these days. Although a cloud VM may not be as reliable as an enterprise-grade server, the main cloud providers offer a variety of tools to increase service availability. In this blog post, we’ll show you how to architect your MySQL or MariaDB database for high availability, in the cloud. We will be looking specifically at Amazon Web Services and Google Cloud Platform, but most of the tips can be used with other cloud providers too.

Both AWS and Google offer database services on their clouds, and these services can be configured for high availability. It is possible to have copies in different availability zones (or zones in GCP), in order to increase your chances to survive partial failure of services within a region. Although a hosted service is a very convenient way of running a database, note that the service is designed to behave in a specific way and that may or …

Have you ever tried to improve the performance of a query by adding a new index to a table with a large number of rows, waited for ages while the index is built, only to discover that it didn't really help as much as you'd like?

Or perhaps you have had an index that you have a hunch isn't doing much to help your query performance and decided to drop it, only to have a bunch of users complain that their queries are stalling?

If so, then you will appreciate a nice new feature in the forthcoming MySQL 8.0 release called "invisible indexes".

Invisible indexes enable you to test the effect of removing an index on query performance without making a destructive change that must be undone should the index turn out to be required. By marking an index as invisible, you are effectively "hiding" it from the optimizer while the index itself remains intact and can be restored at any time. This feature makes it much easier to test the …

In MySQL 8.0 we introduce the ICU library to handle our regular expression support. This library is maintained by the Unicode Consortium and is used on a wide variety on platforms. The reason we switch libraries is threefold: security, Unicode support and functionality.…

In reply to Marcelo Altmann.

i have multiple tables in each database on diffrent masters so how it would be possible to replicate the data from all masters to one
slave.

In this blog post, we’ll look at how to approach pt-table-checksum errors.

pt-table-checksum is one of the most popular tools in Percona Toolkit, and it is widely used to identify data differences between masters and slaves. Therefore, as Percona Support Engineers we have customers often asking questions related to the pt-table-checksum errors and warnings produced. Below are the most common issues raised with pt-table-checksum, and we decided to address those issues to help with how to mitigate related warnings or errors.

Unable to detect …

If you are interested in MySQL Performance and you are looking for an optimal storage, you should have a look at this presentation by Frank Ober where you will be able to see how MySQL behaves on Intel Optane SSDs:

This session was recorded during the Silicon Valley MySQL Group meetup of last March 28th.

You will also find an overview of the tools you can use to test your environment.

Thank you to Intel for testing MySQL 8.0 and having collaborated with Dimitri.

Dimitri will also …

We are happy to announce upcoming “MySQL User Camp, Bangalore” on 27thApril 2018. This time with following presentations:

• MySQL Docker with Demo
• What’s new in MySQL 8.0
• Customer Experience: InnoDB Cluster Implementation.

Explore the opportunity to get to know more about MySQL by networking with other MySQLers.

Date/Time: Friday 27th Apr 2018, 3 pm – 5:30 pm

Venue details:

• OC001, Block1, B wing,
• Kalyani Magnum Infotech Park,
• J.P. Nagar, 7th Phase Bangalore – 76

Registration: Free (FCFS)                     

Registration: Please send an email to  …

We’ve been searching for a great venue for Percona Live Europe 2018, and I am thrilled to announce we’ll be hosting it in Frankfurt, Germany! Please block November 5-7, 2018 on your calendar now and plan to join us at the Radisson Blu Frankfurt for the premier open source database conference.

We’re in the final days of organizing for the Percona Live 2018 in Santa Clara. You can still purchase tickets for an amazing lineup of keynote speakers, tutorials and sessions. We have ten tracks, including MySQL, MongoDB, Cloud, PostgreSQL, Containers and Automation, Monitoring and Ops, and Database Security. Major areas of focus at the conference will include:

…

Welcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter.

This blog post highlights Jenni Snyder, Engineering Manager – Operations at Yelp. Her tutorial talk is titled The Accidental DBA. Open source relational databases like MySQL and PostgreSQL power some of the world’s largest websites. They can be used out of the box with few adjustments, and rarely require a dedicated Database …