EmergencyEMERGENCY? Get 24/7 Help Now!

This Week in Data with Colin Charles #3: More Percona Live Europe!

 | August 25, 2017 |  Posted In: MariaDB, MongoDB, MySQL, MySQL 8.0, open source databases, Percona Live, PostgreSQL, Prometheus, ProxySQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. We are five weeks out to the conference! The tutorials and the sessions have been released, and there’s an added bonus – you can now look at all this in a grid view: tutorials, day […]

Read More

Webinar Thursday May 4, 2017: Percona Software News and Roadmap Update Q2 2017

 | May 1, 2017 |  Posted In: MongoDB, MySQL, open source databases, Percona Managed Services, Percona Software, Technical Webinars

Percona Software News

Come and listen to Percona CEO Peter Zaitsev on Thursday, May 4, 2017 at 11:00 am (PST) / 2:00 pm (EST) discuss Percona’s software news and roadmap, including Percona Server for MySQL and MongoDB, Percona XtraBackup, Percona Toolkit, Percona XtraDB Cluster and Percona Monitoring and Management. Register Now During this webinar, Peter will talk about newly […]

Read More

Percona Live Featured Session with Alibaba Cloud – Flashback: Rolling Back a MySQL/MariaDB Instance, Database or Table to a Previous Snapshot

 | April 20, 2017 |  Posted In: open source databases, Percona Live

Percona Live

Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database environment. Make sure to read to the end to get a special Percona Live 2017 registration […]

Read More

Percona Live Webinar Thursday, April 6, 2017: Best Practices Migrating to Open Source Databases

 | April 4, 2017 |  Posted In: MariaDB, MongoDB, MySQL, open source databases, Percona Live, Technical Webinars

Please join Percona’s CEO and Founder, Peter Zaitsev on April 6th, 2017 at 8:00 am PDT / 11:00 am EDT (UTC-7) as he presents Best Practices Migrating to Open Source Databases. Register Now This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see […]

Read More

Open Source Databases on Big Machines: Disk Speed and innodb_io_capacity

 | March 1, 2017 |  Posted In: MySQL, open source databases, OpenSource Databases on big machines

In this blog post, I’ll look for the bottleneck that prevented the performance in my previous post from achieving better results. The powerful machine I used in the tests in my previous post has a comparatively slow disk, and therefore I expected my tests would hit a point when I couldn’t increase performance further due to the disk speed. […]

Read More

Performance Schema Benchmarks: OLTP RW

 | January 26, 2017 |  Posted In: MySQL, open source databases, OpenSource Databases on big machines

Performance Schema Benchmarks

In this blog post, we’ll look at Performance Schema benchmarks for OLTP Read/Write workloads. I am in love with Performance Schema and talk a lot about it. Performance Schema is a revolutionary MySQL troubleshooting instrument, but earlier versions had performance issues. Many of these issues are fixed now, and the default options work quickly and […]

Read More

Setup ProxySQL for High Availability (not a Single Point of Failure)

 | January 19, 2017 |  Posted In: High-availability, Keepalived, MySQL, open source databases, OpenSource Databases on big machines, Percona Live, Percona MySQL Consulting, Percona Software, Percona XtraDB Cluster, ProxySQL

ProxySQL for High Availability

In this blog post, we’ll look at how to set up ProxySQL for high availability. During the last few months, we’ve had a lot of opportunities to present and discuss a very powerful tool that will become more and more used in the architectures supporting MySQL: ProxySQL. ProxySQL is becoming more flexible, solid, performant and used […]

Read More

Open Source Databases on Big Machines: Does READ COMMITTED Scale on 144 Cores?

 | January 19, 2017 |  Posted In: open source databases, OpenSource Databases on big machines

READ COMMITTED

In the second post in my series on open source databases on big machines, we’ll look at whether READ COMMITTED scales with multiple cores. The default transaction level for InnoDB is REPEATABLE READ. A more permissive level is  READ COMMITTED, and is known to work well. While the  REPEATABLE READ level maintains the transaction history up to the start of the transaction, […]

Read More