MySQL 8.0 upgrade checklist

Recently one of our customers in Fintech. business (among the largest one in the Asia) wanted to upgrade from MySQL 5.7 to MySQL. 8.0. and they approached us for a safest and durable MySQL upgrade strategy, roadmap and execution. In Fintech. business every transaction needs to durable from statutory regulatory compliance perspective and we at MinervaDB never wanted to go for unplanned / easy in-place MySQL 8.0 upgrade method here without proper pre-migration audit, We wanted to list down in detail what are the possible scenarios this MySQL 8.0 upgrade will fail and the compatibility issues between MySQL 5.7 and MySQL 8.0. Thankfully Upgrade Checker utility that comes with MySQL Shell 8.0 can be executed against MySQL 5.7 server to confirm upgrade readiness, We have written a blog on MySQL Shell 8.0 Upgrade Checker …

It was all aboard the Lone Star river boat for the 100 delegates who joined our Community Dinner. Loading took quite some time, Tom Basil attended to the guest list, and then the necessary signatures for those aboard. I’d woken at 6am to a less than favorable forecast, but the weather was kind to us, with blue sky and a gentle breeze.

My colleague and local Austin resident Rick Vasquez had on Tuesday treated me to my first visit to a US liquor store, Specs. This store was bigger than the largest store in my hometown but sold only alcohol-related products and drink-friendly snacks. An experience in itself! We stuck to the brief of Texas-only brew for our guests.

As people boarded they received their swag – PlanetScale and Percona branded steel enamel mugs – and bar and dinner queues formed. The lines moved relatively quickly for the fajita and tex mex themed buffet. …

We are pleased to announce the release of PMM 2 Beta!  PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance.

• Query Analytics:
  • MySQL and MongoDB – Slow log, PERFORMANCE_SCHEMA, and Profiler data sources
  • Support for large environments – default view all queries from all instances
  • Filtering – display only the results matching filters such as the schema name or the server instance
  • Sorting and more columns – now sort by any column.
  • Modify Columns – Add one or more columns for any field exposed by the data source
  …

In this tutorial I want to share with you simple example of php mysql pagination using angularjs we will use dirPaginationjs as Pagination Directive in angularjs paginate using php mysql databasewe will create step by step very basic example of server side pagination in angularjs pagination i

In this tutorial I want to share with you simple example of php mysql pagination using angularjs we will use dirPaginationjs as Pagination Directive in angularjs paginate using php mysql databasewe will create step by step very basic example of server side pagination in angularjs pagination i

Today we’re happy to announce that we’ll be partnering with Datavail to provide solutions for continuous & highly available MySQL, Percona Server & MariaDB database operations based on Tungsten Clustering & Datavail Database Services.

Datavail is a renowned, tech-enabled data management, applications, business intelligence, and software solutions provider with a team of 700+ DBAs that look after customers’ database environments.

What are we aiming for?

Together we’re looking to continue to drive momentum in supporting rapid MySQL & MariaDB based application deployments as well as highly available and scalable database implementations for existing and future customers.

This new collaboration is …

It’s that time of year again, and we’ve just had the presentations of the MySQL Community Awards at Percona Live. A more fulsome blog post will be written for the Community Blog in the next few days about the worthy winners. Meanwhile, though, here’s a summary.

Committee Co-Secretaries Emily Slocombe of Square, and Agustin Gallego of Percona presented these annual community nominated awards today. In four categories, the awards went to:

• Community Contributor of the Year: Weixiang Zhai
• Community Contributor of the Year: Valerii Kravchuk

Both of these awards were made for bug identification and submission. Valerii was represented by Vicențiu Ciorbaru of MariaDB Foundation who accepted the award on his behalf.

• The Application of the Year award was mad to Dbdeployer, for its incredible usefulness to the …

When Skillz, a leading mobile eSports platform connecting 2.6 billion gamers across the globe, sought Pythian’s help with reducing storage costs, they learned they could not only reduce costs but also gain a more responsive application while providing an improved player experience.

The gaming company collects data to customize player experiences by delivering relevant campaigns, performing fraud and cheater detection, segmenting markets, and providing special offers according to region or interest. However, the Skillz environment was complex, comprising of many layers and very complex code, as well as geographical data, and their existing analytics were costly and slow. “We were running these applications hourly to customize these different features, then finding ourselves wishing we could do that much more quickly,” said Miriam Aguirre, VP Engineering at Skillz.

Skillz wanted to move to an ‘event-driven’ analytics …

During my presentation at Percona Live 2019, I’ll be talking about how Riot Games, the company behind League of Legends, migrated hundreds of millions of player accounts to unlock opportunities for us to delight players. This meant moving ten geographically distributed databases into a single global database replicated into four AWS regions. I’ll talk about some of the technical decisions we made, the expected vs actual outcomes, and lessons we learned along the way.

Migrating hundreds of millions of player records without impacting a player’s ability to manage their account and log in was a daunting task. I’ll shed some light on how we managed to handle this data migration while modifying the database schema. I’ll also go into detail on the backend …

ProxySQL 2.0.4, released by ProxySQL, is now available for download in the Percona Repository along with Percona’s proxysql-admin tool.

ProxySQL is a high-performance proxy, currently for MySQL and database servers in the MySQL ecosystem (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues.

This release includes ProxySQL 2.0.4 which fixes many bugs and introduces a number of features …