Buy Percona ServicesBuy Now!

This Week in Data with Colin Charles 35: Percona Live 18 final countdown and a roundup of recent news

 | April 13, 2018 |  Posted In: Amazon Aurora, AWS, MariaDB, MongoDB, MyRocks, MySQL, Percona Monitoring and Management, Percona Software, Percona XtraBackup, ProxySQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Percona Live is just over a week away — there’s an awesome keynote lineup, and you really should register. Also don’t forget to save the date as Percona Live goes to Frankfurt, Germany November 5-7 2018! […]

Read More

ProxySQL Admin Support for Multiple Clusters

 | April 11, 2018 |  Posted In: Insight for DBAs, MySQL, ProxySQL

ProxySQL for Connection Pooling

In this blog post, we demonstrate a new feature in ProxySQL Admin: support for multiple clusters. In a previous blog post, Ramesh and Roel introduced a new tool that helps configured Percona XtraDB Cluster nodes into ProxySQL. However, at that time it only worked for a single cluster per ProxySQL Admin configuration. Starting from ProxySQL […]

Read More

Calling All Polyglots: Percona Live 2018 Keynote Schedule Now Available!

 | April 11, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, Containers, Database Monitoring, MariaDB, MongoDB, MySQL, Percona Live, PostgreSQL, ProxySQL

Percona Live 2018 Keynotes

We’ve posted the Percona Live 2018 keynote addresses for the seventh annual Percona Live Open Source Database Conference 2018, taking place April 23-25, 2018 at the Santa Clara Convention Center in Santa Clara, CA.  This year’s keynotes explore topics ranging from how cloud and open source database adoption accelerates business growth, to leading-edge emerging technologies, […]

Read More

Percona Live Europe 2018 – Save the Date!

 | April 5, 2018 |  Posted In: InnoDB, Insight for DBAs, Insight for Developers, MariaDB, MongoDB, MyRocks, MySQL, Percona Live, PostgreSQL, ProxySQL, Time Series Database

Percona Live Europe 2018

We’ve been searching for a great venue for Percona Live Europe 2018, and I am thrilled to announce we’ll be hosting it in Frankfurt, Germany! Please block November 5-7, 2018 on your calendar now and plan to join us at the Radisson Blu Frankfurt for the premier open source database conference. Percona Live in Santa […]

Read More

Leveraging ProxySQL with AWS Aurora to Improve Performance, Or How ProxySQL Out-performs Native Aurora Cluster Endpoints

 | April 3, 2018 |  Posted In: Amazon Aurora, Amazon RDS, MySQL, ProxySQL

ProxySQL with AWS Aurora

In this blog post, I’ll look at how you can use ProxySQL with AWS Aurora to further leverage database performance. My previous article described how easy is to replace the native Aurora connector with ProxySQL. In this article, you will see WHY you should do that. It is important to understand that aside from the basic optimization […]

Read More

Using ProxySQL and VIRTUAL Columns to Solve ORM Issues

 | March 29, 2018 |  Posted In: MySQL, ProxySQL

ProxySQL for Connection Pooling

In this blog post, we’ll look at using ProxySQL and VIRTUAL columns to solve object-relational mapping (ORM) issues. There are a lot of web frameworks all around. Programmers and web designers are using them to develop and deploy any website and web application. Just to cite some of the most famous names: Drupal, Ruby on […]

Read More

This Week in Data with Colin Charles 33: Reporting from FOSSASIA 2018 and Azure Announces Database Services for MySQL and PostgreSQL

 | March 23, 2018 |  Posted In: AWS, Events and Announcements, JSON, MongoDB, MySQL, MySQL 8.0, Percona Live, PostgreSQL, ProxySQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. Writing to you on the ground from FOSSASIA 2018, where I gave a track introduction yesterday since we have a pretty awesome database track most Saturday, and generally, all MySQL focused on Sunday. There’s even a […]

Read More

Webinar Thursday, March 22, 2018: Percona XtraDB Cluster 5.7 with ProxySQL for Your MySQL High Availability and Clustering Needs

and  | March 20, 2018 |  Posted In: high availability, High-availability, MySQL, Percona XtraDB Cluster, ProxySQL, Technical Webinars

MySQL high availability

Please join Percona’s Ramesh Sivaraman (QA Engineer) and Krunal Bauskar (Software Engineer, Percona XtraDB Cluster Lead) as they present Percona XtraDB Cluster 5.7 with ProxySQL for Your MySQL High Availability and Clustering Needs on Thursday, March 22, 2018 at 8:30 am PDT (UTC-7) / 11:30 am EDT (UTC-4). Percona has developed Percona XtraDB Cluster (based […]

Read More

This Week in Data with Colin Charles 32: Stack Overflow Developer Survey, SCALE16x and Interesting MySQL 8 Version Numbers

 | March 16, 2018 |  Posted In: MariaDB, MongoDB, MySQL, MySQL 8.0, open source databases, PostgreSQL, ProxySQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. SCALE16x is over. Percona had a large showing — both Peter Zaitsev & myself had talks, and the booth in the expo hall saw Rick Golba, Marc Sherwood, and Dave Avery also pop by. The lead […]

Read More

Verifying Query Performance Using ProxySQL

 | March 15, 2018 |  Posted In: Database Monitoring, MySQL, Percona Monitoring and Management, ProxySQL

Query Performance Using ProxySQL

In this blog post, we’ll look at how you can verify query performance using ProxySQL. In the previous blog post, I showed you how many information can you get from the “stats.stats_mysql_query_digest” table in ProxySQL. I also mentioned you could even collect and graph these metrics. I will show you this is not just theory, it […]

Read More