Buy Percona ServicesBuy Now!

New MySQL 8.0 innodb_dedicated_server Variable Optimizes InnoDB from the Get-Go

 | March 26, 2018 |  Posted In: InnoDB, Insight for DBAs, MySQL, MySQL 101, MySQL 8.0, Percona Monitoring and Management

MySQL 8.0 innodb_dedicated_server

In this post, we’ll look at the MySQL 8.0 innodb_dedicated_server variable. MySQL 8.0 introduces a new variable called innodb_dedicated_server. When enabled, it auto tunes innodb_buffer_pool_size, innodb_log_file_size and innodb_flush_method at startup (if these variables are not explicitly defined in my.cnf). The new MySQL 8.0 variable automatically sizes the following variables based on the RAM size of […]

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

Percona Live 2018 Featured Talk: Deep Dive into the RDS PostgreSQL Universe with Jignesh Shah

 | March 21, 2018 |  Posted In: Amazon RDS, AWS, MySQL, Percona Live, PostgreSQL

Percona Live 2018 Jignesh AWS

Welcome to another interview blog for the rapidly-approaching Percona Live 2018. Each post in this series highlights a Percona Live 2018 featured talk at the conference and gives a short preview of what attendees can expect to learn from the presenter. This blog post highlights Jignesh Shah, Senior Product Manager at Amazon Web Services. His talk […]

Read More

FLUSH and LOCK Handling in Percona XtraDB Cluster

 | March 21, 2018 |  Posted In: Insight for DBAs, MySQL, Percona XtraDB Cluster

FLUSH and LOCK Handling

In this blog post, we’ll look at how Percona XtraDB Cluster (PXC) executes FLUSH and LOCK handling. Introduction Percona XtraDB Cluster is a multi-master solution that allows parallel execution of the transactions on multiple nodes at the same point in time. Given this semantics, it is important to understand how Percona XtraDB Cluster executes statements regarding FLUSH […]

Read More

Using Different Mount Points on PMM Docker Deployments

 | March 20, 2018 |  Posted In: MySQL

Mount Points on PMM Docker

In this blog post, we’ll see how to use different mount points on PMM Docker deployments (Percona Monitoring and Management). This is useful if you want to use other mount points for the different directories, or even if you want to use a custom path that is not bound to Docker’s volumes directory (which is /var/lib/docker/volumes/ […]

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

Percona XtraDB Cluster, MySQL Asynchronous Replication and log-slave-updates

 | March 19, 2018 |  Posted In: MySQL, Percona XtraDB Cluster, Replication

Asynchronous Replication

Recently, I’ve been looking into issues with the interactions between MySQL asynchronous replication and Galera replication. In this blog post, I’d like to share what I’ve learned. MySQL asynchronous replication and Galera replication interactions are complicated due to the number of factors involved (Galera replication vs. asynchronous replication, replication filters, and row-based vs. statement-based replication). So […]

Read More

How to Speed Up Pattern Matching Queries

 | March 19, 2018 |  Posted In: Insight for DBAs, MySQL

pattern matching queries

From time to time I see pattern matching queries with conditions that look like this: “where fieldname like ‘%something%’ “. MySQL cannot use indexes for these kinds of queries, which means it has to do a table scan every single time. (That’s really only half true — there are the FullText indexes. In another blog […]

Read More

Percona Toolkit 3.0.8 Is Now Available

 | March 16, 2018 |  Posted In: Events and Announcements, MySQL, Percona Toolkit

Percona announces the release of Percona Toolkit 3.0.8 on March 16, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, Percona […]

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