Tag - mysql-and-variants

MySQL Escaping on the Client-Side With Go

MySQL Escaping With Go

Day-to-day database operation requires, from an administrator, deep knowledge of db internals and security issues, in particular things like SQL injections. In order to prevent such kind of an attack, we have included go-sql-driver into our code for secure placeholder escaping.
Unfortunately, not all cases are secured by the driver.
In case we are using the […]

Read more

Webinar June 25: How to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster

How to Avoid Pitfalls in Schema Upgrade with Percona XtraDB Cluster

In this webinar, Sveta Smirnova, MySQL Engineer at Percona, will uncover nuances of Percona XtraDB Cluster (PXC) schema upgrades and point out details you need to give extra attention to.
Percona XtraDB Cluster (PXC) is a 100% synchronized cluster in regards to DML operations. It is ensured by the optimistic locking model and ability to […]

Read more

Running Custom MySQL Queries in Percona Monitoring and Management

custom mysql queries

Even though Percona Monitoring and Management 2 (PMM) comes with a lot of dashboards and metrics out of the box, sometimes we need to extend the default metrics by running custom MySQL queries.
For example, suppose you want to have information about cached indexes from Innodb tables from innodb_cached_indexes table. That metric is not being […]

Read more

Solution Brief: How Percona Helped Patreon Realize the Value of Their Database Infrastructure

optimize your databases for peak performance

Our latest Solution Brief uses our relationship with Patreon to detail the ways that Percona services work together to provide customers with a complete database infrastructure solution.
Last year Patreon enlisted Percona’s help with their MySQL databases. Utilizing the full range of Percona Services (Managed Services, Support, Consulting, and Training) has allowed Patreon to make […]

Read more

Q & A on Webinar “How Safe is Asynchronous Master-Master Setup in MySQL?”

Q&A Followup

First I want to thank everyone who attended my May 21, 2020 webinar “How Safe is Asynchronous Master-Master Setup in MySQL?“. Recording and slides are available on the webinar page.
Here are answers to the questions from participants which I was not able to provide during the webinar.
Q: What do you generally think of hosting […]

Read more