by Emily Ikuta | Jul 5, 2017 | MySQL
Join Percona’s Solutions Engineer, Dimitri Vanoverbeke as he presents Security and Encryption in the MySQL World on Thursday, July 6, 2017, at 7:00 am PDT / 10:00 am EDT (UTC-7). Register Now MySQL and MariaDB Server provide many new features that help with...
by Emily Ikuta | Jul 3, 2017 | MySQL, Webinars
Join Percona’s Senior Architect, Matthew Boehm, as he presents Indexes – What You Need to Know to Get the Most Out of Them on Wednesday, July 5, 2017 at 8:00 am PDT / 11:00 am EDT (UTC-7). Register Now Proper indexing is key to database performance. Find out how MySQL...
by Manjot Singh | Jun 28, 2017 | MySQL, Security
Welcome to Part 2 in a series of blog posts on MySQL encryption at rest. This post covers InnoDB tablespace encryption. 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...
by Tibor Korocz | Jun 27, 2017 | Insight for DBAs, MySQL, Security
This blog post looks at SSL connections and how they work in MySQL 5.7. Recently I was working on an SSL implementation with MySQL 5.7, and I made some interesting discoveries. I realized I could connect to the MySQL server without specifying the SSL keys on the...
by Emily Ikuta | Jun 26, 2017 | MariaDB, MySQL, Webinars
Join Percona’s Chief Evangelist, Colin Charles as he presents MariaDB Server 10.2: The Complete Guide on Tuesday, June 27, 2017, at 7:00 am PDT / 10:00 am EDT (UTC-7). Register Now The new MariaDB Server 10.2 release is out. It has some interesting new features, but...
by Kenny Gryp | Jun 23, 2017 | Insight for DBAs, Percona Software
Thank you for attending the Wednesday, June 21, 2017 high availability webinar titled Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication. In this blog, I will provide answers to the Q & A for that webinar. You can find the slides and a recording of...
by Vadim Tkachenko | Jun 22, 2017 | Benchmarks, Insight for DBAs, MySQL
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test. We have mentioned ClickHouse in some recent posts (ClickHouse: New Open Source Columnar Database, Column Store Database Benchmarks:...
by Alexey Zhebel | Jun 21, 2017 | Insight for DBAs, MariaDB, MongoDB, Monitoring, MySQL, Percona Events, Percona Software, ProxySQL
Percona announces the release of Percona Monitoring and Management 1.1.5 on June 21, 2017. For installation instructions, see the Deployment Guide. Changes in PMM Server PMM-667: Fixed the Latency graph in the ProxySQL Overview dashboard to plot microsecond values...
by Dave Avery | Jun 20, 2017 | Insight for DBAs, MySQL, Webinars
Join Percona’s Senior Operations Engineer, Daniel Kowalewski as he presents Deploying MySQL in Production on Thursday, June 22, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). Register Now MySQL is famous for being something you can install and get going in less than...
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...
