by Yves Trudeau | Jun 20, 2017 | Insight for DBAs, MySQL, Percona Software
In this blog, we’ll look at different MySQL high availability options. The dynamic MySQL ecosystem is rapidly evolving many technologies built around MySQL. This is especially true for the technologies involved with the high availability (HA) aspects of MySQL....
by Agustín | Jun 14, 2017 | Insight for DBAs, MySQL
In this post we’ll review how MySQL triggers can affect queries. Contrary to what the documentation states, we can activate triggers even while operating on views: https://dev.mysql.com/doc/refman/5.7/en/triggers.html Important: MySQL triggers activate only for...
by Dave Avery | Jun 13, 2017 | Insight for DBAs, MySQL, PostgreSQL, Webinars
Join Percona’s Senior Technical Services Engineer Emanuel Calvo as he presents Demystifying Postgres Logical Replication on Thursday, June 15, 2017 at 7 am PDT / 10 am EDT (UTC-7). Register Now The Postgres logical decoding feature was added in version 9.4, and...
by Peter Zaitsev | Jun 9, 2017 | Cloud, Insight for DBAs, Monitoring, MySQL
In this blog, we will provide answers to the Q & A for the MySQL In the Cloud: Migration, Best Practices, High Availability, Scaling webinar. First, we want to thank everybody for attending the June 7, 2017 webinar. The recording and slides for the webinar are...
by Dave Avery | Jun 8, 2017 | MongoDB, MySQL
In this post, we’ll use a blog poll to find out what operating system you use to run your production database servers. As databases grow to meet more challenges and expanding application demands, they must try and get the maximum amount of performance out of...
by Peter Zaitsev | Jun 7, 2017 | MySQL
In this blog post, I’ll look at how ProxySQL Admin behaves in some unusual and unexpected ways from a MySQL perspective. ProxySQL allows you to connect to its admin interface using the MySQL protocol and use familiar tools, like the MySQL command line client, to...
by Manjot Singh | Jun 6, 2017 | MySQL, Security
In this first of a series of blog posts, we’ll look at MySQL encryption at rest. At Percona, we work with a number of clients that require strong security measures for PCI, HIPAA and PHI compliance, where data managed by MySQL needs to be encrypted “at...
by Dave Avery | Jun 5, 2017 | MariaDB, MongoDB, MySQL, Percona Live, Storage Engine
Announcing the opening of the Percona Live Open Source Database Conference Europe 2017 in Dublin, Ireland call for papers. It will be open from now until July 17, 2017.* Do you have a big idea to explain, use case to share or skill to teach? Submit your speaking...
by Dave Avery | Jun 5, 2017 | Cloud, MySQL, Webinars
Join Percona’s CEO and Founder Peter Zaitsev as he presents MySQL In the Cloud: Migration, Best Practices, High Availability, Scaling on Wednesday, June 7, 2017, at 10 am PDT / 1:00 pm EDT (UTC-7). Register Now Businesses are moving many of the systems and processes...
by Ramesh Sivaraman | May 31, 2017 | Insight for DBAs, MySQL, Percona Software, ProxySQL
In this blog post, we’ll look at how Percona XtraDB Cluster maintenance mode uses ProxySQL to take cluster nodes offline without impacting workloads. Percona XtraDB Cluster Maintenance Mode Since Percona XtraDB Cluster offers a high availability solution, it...
by Dave Avery | May 30, 2017 | Insight for DBAs, MySQL, Percona Software, Webinars
Please join Percona’s solution engineer, Dimitri Vanoverbeke as he presents Online MySQL Backups with Percona XtraBackup on Wednesday, May 31, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7). Register Now Percona XtraBackup is a free, open source, complete online...
by Alexey Zhebel | May 29, 2017 | Cloud, Insight for DBAs, Insight for Developers, MariaDB, MongoDB, Monitoring, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona Monitoring and Management 1.1.4 on May 29, 2017. For installation instructions, see the Deployment Guide. This release includes experimental support for MongoDB in Query Analytics, including updated QAN interface. Query...
by Hrvoje Matijakovic | May 26, 2017 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona Server for MySQL 5.7.18-15 on May 26, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based...
by Marco Tusa | May 25, 2017 | Insight for DBAs, MySQL, Percona Software, ProxySQL
In this blog post, we’ll look at how ProxySQL and mirroring go together. Overview Let me be clear: I love ProxySQL, and I think it is a great component for expanding architecture flexibility and high availability. But not all that shines is gold! In this post, I...
by Dave Avery | May 24, 2017 | Benchmarks, Insight for DBAs, MariaDB, MongoDB, MySQL, Percona Software, Webinars
This blog post is a summary of the Percona Software and Roadmap Update – Q2 2017 webinar given by Peter Zaitsev on May 4, 2017. This webinar reflects changes and updates since the last update (Q1 2017). A full recording of this webinar, along with the...
by Agustín | May 22, 2017 | Insight for DBAs, MariaDB, MySQL, Percona Software
In this blog, we’ll look at ICP counters in the information_schema.INNODB_METRICS. This is part two of the Index Condition Pushdown (ICP) counters blog post series. As mentioned in the previous post, in this blog we will look at how to check on ICP counters on...
by Alexey Zhebel | May 19, 2017 | MongoDB, MySQL, Percona Events, Percona Software
Percona announces the release of Percona Toolkit 3.0.3 on May 19, 2017. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually. Percona...
by Dave Avery | May 16, 2017 | Cloud, Insight for DBAs, MariaDB, MongoDB, Monitoring, MySQL, Percona Live, Storage Engine
The slides and videos from the Percona Live Open Source Database Conference 2017 are available for viewing and download. The videos and slides cover the keynotes, breakout sessions and MySQL and MongoDB 101 sessions. To view slides, go to the Percona Live agenda, and...
by Hrvoje Matijakovic | May 12, 2017 | MySQL, Percona Software, Storage Engine
Percona announces the GA release of Percona Server for MySQL 5.7.18-14 on May 12, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based...
by Hrvoje Matijakovic | May 12, 2017 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server for MySQL 5.6.36-82.0 on May 12, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository. Based on...
