by Colin Charles | May 4, 2018 | MySQL
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. The week after Percona Live Santa Clara 2018 tends to be much quieter, aided by the fact that I took a few days away during...
by Lorraine Pocklington, Community Manager | May 4, 2018 | MariaDB, MongoDB, MySQL, Open Source, Percona Events, Percona Live, PostgreSQL
So, after a whirlwind few days, Percona Live 2018 has been and gone. There was a great energy about the conference, and it was fantastic to meet so many open source database enthusiasts and supporters. A few things that I experienced: Your great willingness to share...
by Krunal Bauskar | May 3, 2018 | MySQL, Percona Software, Webinars
On March 22, 2018, we held a webinar on how Percona XtraDB cluster 5.7 (PXC) and ProxySQL can help achieve your database clustering high availability needs. Firstly, thanks to all the attendees for taking time to attend the webinar and we are sure you had a webinar...
by Alex Poritskiy | May 3, 2018 | Insight for DBAs, MySQL
Recently I worked on one customer issue that I would describe as “slave performance too slow”. During a quick analysis, I’ve found that the replication slave SQL thread cannot keep up while processing row-based events from the master’s binary...
by Alkin Tezuysal | May 2, 2018 | Insight for DBAs, Insight for Developers, MySQL, ProxySQL
In this blog post, I’m going to revisit the ProxySQL Query Rewrite feature. You may have seen me talking about possible use case scenarios in the past few conferences, but the reason I’m starting with this is that query rewriting was the original intention for...
by Vinodh Krishnaswamy | May 1, 2018 | Insight for DBAs, Insight for Developers, MongoDB
In this blog post, we’ll look at how MongoDB rollback works during replicaset failovers. In recent versions, MongoDB has provided lots of features related to replicaset and automatic failover. When it comes to failover, the next question that arises is “How does...
by Tim Vaillancourt | May 1, 2018 | Insight for DBAs, Insight for Developers, MongoDB, Webinars
Please join Percona’s Senior Technical Operations Architect, Tim Vaillancourt as he presents Running MongoDB in Production (Part 3) on Thursday, May 3, 2018, at 10:00 am PDT (UTC-7) / 1:00 pm EDT (UTC-4). Are you a seasoned MySQL DBA that needs to add MongoDB to your...
by Vadim Tkachenko | May 1, 2018 | MySQL, Storage Engine
Join Percona CTO Vadim Tkachenko at the Cloud Native Utah meetup in Salt Lake City on Tuesday, May 8, 2018, for an Intro to ClickHouse. Next week, I’ll be switching from MyRocks performance testing and present an introduction to ClickHouse to the Cloud Native...
by Vadim Tkachenko | Apr 30, 2018 | Benchmarks, Insight for DBAs, MySQL, Storage Engine
In this blog post, I’ll look at MyRocks performance through some benchmark testing. As the MyRocks storage engine (based on the RocksDB key-value store http://rocksdb.org ) is now available as part of Percona Server for MySQL 5.7, I wanted to take a look at how...
by Nickolay Ihalainen | Apr 30, 2018 | Insight for DBAs, MySQL, Security
This blog post describes how to keep sensitive data secure on slave servers in a MySQL async replication setup. Almost every web application has a sensitive data: passwords, SNN, credit cards, emails, etc. Splitting the database to secure and “public”...
by Colin Charles | Apr 27, 2018 | Insight for DBAs, Insight for Developers, Percona Live
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Santa Clara 2018 is now over! All things considered, I think it went off quite well; if you have any...
by Roel Van de Paar | Apr 27, 2018 | Insight for DBAs, MySQL, Open Source
What does Anton Ego – a fictional restaurant critic from the Pixar movie Ratatouille – have to do with MySQL 8.0 GA? When it comes to being a software critic, a lot. In many ways, the work of a software critic is easy. We risk very little and thrive on negative...
by Matt Yonkovit | Apr 26, 2018 | Cloud, MySQL, Percona Live, Percona Services
The requirements for managing and running a database in a modern enterprise have evolved over the past ten years. Those in charge of running enterprise databases have seen their focus shift from ensuring access and availability, to architecture, design and scalability...
by Lorraine Pocklington, Community Manager | Apr 26, 2018 | MySQL, Percona Events, Percona Live
One of the highlights of Percona Live is that the winners of the annual MySQL Community Awards are announced. A 100% community effort, the awards were created to recognize community contribution. This year saw six very deserving winners in three categories: MySQL...
by Dave Avery | Apr 25, 2018 | Percona Live
Percona Live 2018 is officially done! The closing ceremony ends the conference with a last few lightning talks and a prize giveaway. We ended the Percona Live 2018 conference the same way we started: with talks! This year, we had our lightning talks as part of our...
by Dave Avery | Apr 25, 2018 | Cloud, Open Source, Percona Live
We’re heading into the home stretch at Percona Live 2018, but the sessions are continuing. I was able to attend a talk this afternoon given by Inaam Rana, a Database Developer at Alibaba Cloud, on PolarDB, an InnoDB based shared-everything storage solution....
by Dave Avery | Apr 25, 2018 | Insight for DBAs, MySQL, Percona Live, Security
We’re moving along at Percona Live 2018, and there are still packed and energetic talks after lunch. My next session was with Andrew Regner, Production Engineer at Facebook. His talk was on securing access to Facebook’s databases. Since the beginning,...
by Dave Avery | Apr 25, 2018 | Insight for DBAs, Insight for Developers, MySQL, Percona Live
Percona Live 2018 is moving along, and the first person I got a chance to talk with is Michael Demmer, Senior Staff Engineer at Slack. His talk was on Migrating to Vitess at (Slack Scale). MySQL is the backbone of Slack’s data storage infrastructure. It handles...
by Dave Avery | Apr 25, 2018 | Cloud, MongoDB, Monitoring, Percona Live
Welcome to Percona Live 2018 keynotes, day two! Day two of Percona Live 2018 looks to be as filled with great talks as day one. Today we started with keynote presentations from Percona, a panel on the evolution of databases and talks from VividCortex and Upwork. You...
by Dave Avery | Apr 24, 2018 | Cloud, Insight for DBAs, MySQL, Percona Live
In this blog post on Percona Live 2018 sessions, we’ll talk with Shuhoa Wu, Software Developer for Shopify, Inc. about how Ghostferry is the Swiss Army knife of live data migrations. Existing tools like mysqldump and replication cannot migrate data between...
