by Yves Trudeau | Sep 15, 2017 | Insight for DBAs, MySQL, ProxySQL
This post is the third of a series focusing on the MySQL high availability solutions available in 2017. The first post looked at the elders, the technologies that have been around for more than ten years. The second post talked about the adults, the more recent and...
by Colin Charles | Sep 15, 2017 | Insight for DBAs, Insight for Developers, Percona Events, Percona Live, Percona Software
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. What a long, packed week! Spent most of it at Open Source Summit North America, while still enjoying the myriad phone calls...
by Jervin Real | Sep 14, 2017 | Insight for DBAs, MySQL, Webinars
Hello again! On August 16, we delivered a webinar on MySQL backups. As always, we’ve had a number of interesting questions. Some of them we’ve answered on the webinar, but we’d like to share some of them here in writing. What is the best way to...
by Dave Avery | Sep 14, 2017 | MongoDB, Monitoring, MySQL, Percona Live
Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter....
by Alexey Zhebel | Sep 14, 2017 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.4.7-1.8 on September 14, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB is an enhanced, open source, fully compatible,...
by Dave Avery | Sep 13, 2017 | MongoDB, Monitoring, MySQL, Percona Live
Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter....
by Vadim Tkachenko | Sep 13, 2017 | Insight for DBAs, Monitoring, MySQL
In this blog, I’ll look at how to use ClickHouse for parallel log processing. Percona is seen primarily for our expertise in MySQL and MongoDB (at this time), but neither is quite suitable to perform heavy analytical workloads. There is a need to analyze data...
by Agustín | Sep 12, 2017 | Insight for DBAs, MariaDB, MySQL
In this post, we will discuss how to search code with the help of cscope. Let’s begin by checking its description and capabilities (quoting directly from http://cscope.sourceforge.net/): Cscope is a developer’s tool for browsing source code. Allows...
by Emily Ikuta | Sep 12, 2017 | Insight for DBAs, Insight for Developers, Monitoring, MySQL, Webinars
Join Percona’s CTO Vadim Tkachenko @VadimTk and Altinity’s Co-Founder, Alexander Zaitsev as they present Supercharge Your Analytics with ClickHouse on Thursday, September 14, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Reserve Your Spot ClickHouse is a...
by Sveta Smirnova | Sep 11, 2017 | Insight for DBAs, Insight for Developers, Monitoring, MySQL
In this post, we will discuss the best way to update an InnoDB table manually. As a support engineer, I often see situations when the cardinality of a table is not correct. When InnoDB calculates the cardinality of an index, it does not scan the full table by default....
by Emily Ikuta | Sep 11, 2017 | MariaDB, MySQL, Webinars
Join Percona’s Chief Evangelist, Colin Charles (@bytebot) as he presents Differences Between MariaDB and MySQL on Tuesday, September 12, 2017, at 7:00 am PDT / 10:00 am EDT (UTC-7). Reserve Your Spot Are they syntactically similar? Where do these two query...
by Dave Avery | Sep 8, 2017 | MySQL
Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter....
by Colin Charles | Sep 8, 2017 | Insight for DBAs, Insight for Developers, MongoDB, MySQL, Percona Live, Storage Engine
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live Europe 2017 in Dublin Have you registered for Percona Live Europe Dublin? We have announced some awesome...
by Manjot Singh | Sep 7, 2017 | MySQL
In this blog post, I’ll look at a comparison of PostgreSQL and MySQL. I came across a post from Hans-Juergen Schoenig, a Postgres consultant at Cybertec. In it, he dismissed MySQL and showed Postgres as better. While his post ignores most of the reasons why...
by Dave Avery | Sep 7, 2017 | MySQL, Percona Live, PostgreSQL
Welcome to another post in our series of interview blogs for the upcoming Percona Live Europe 2017 in Dublin. This series highlights a number of talks that will be at the conference and gives a short preview of what attendees can expect to learn from the presenter....
by Emily Ikuta | Sep 6, 2017 | Insight for DBAs, Insight for Developers, Monitoring, MySQL, Percona Software, Webinars
Join Percona’s Product Manager, Michael Coburn as he presents Using Percona Monitoring and Management to Troubleshoot MySQL Performance Issues on Thursday, September 7, 2017, at 10:00 am PDT / 1:00 pm EDT (UTC-7). Reserve Your Spot Successful applications often...
by George O. Lorch III | Sep 6, 2017 | MySQL, Percona Events, Storage Engine
Percona, in collaboration with Facebook, is proud to announce the first experimental release of MyRocks in Percona Server for MySQL 5.7, with packages. Back in October of 2016, Peter Zaitsev announced that we were going to port MyRocks from Facebook MySQL to Percona...
by Dave Avery | Sep 5, 2017 | Insight for DBAs, Insight for Developers, MongoDB, Security
A new set of MongoDB attacks and data breaches struck businesses this weekend, mirroring the attacks that hit back in January and putting MongoDB security back into the spotlight. Like the last set, this new attack strategy focused on ransomware that demanded a paid...
by Emily Ikuta | Sep 5, 2017 | MongoDB, MySQL, Percona Live, Percona Software, Webinars
Come and listen to Percona CEO Peter Zaitsev on Wednesday, September 6, 2017 at 10am PT / 1pm ET (UTC-7) discuss the Percona roadmap, as well as what’s new in Percona open source software. Reserve Your Spot During this webinar Peter will talk about newly...
by Manjot Singh | Sep 1, 2017 | Percona Software, ProxySQL
In this blog post, we’ll look at how to use ProxySQL to help the database load by handling PINGs. I’ve blogged before about one of our regular clients, Life360. One of the issues they recently had was the PING command taking about 30%-40% of total queries per...
