We've talked a lot about the high-resolution data we capture, but if you haven't experienced it yourself, it might be a little abstract. Here, look at the difference between 1-second and 1-minute data.

Are your monitoring systems glossing over important detail with low-frequency data?

All of our metrics are in 1-second granularity. That's 60x more data points per minute than most monitoring tools. It's 120x more data points per second than MongoDB Monitoring Service's premium paid tier. It's 500x more data points per minute than MySQL Enterprise Monitor at its default settings.

It's enough detail to see 1-second server stalls you will never find otherwise. This gives you the ability to proactively find and stop problems that will become much more serious over time.

And this data is not only realtime but …

We use an in-house deployment service system we built called Teletraan to push new code to Pinners around the world. Our goal for Teletraan is to be as dependable and straightforward as possible to remove any deploy-related issues for engineers. In order to achieve this, we’ve put great effort into keeping our deploy process and system secure.

Before, Teletraan didn’t have native authentication and authorization checks when performing operations, so our products and internal tools were at risk for unintended deploy-related changes across teams. As we continue to quickly grow as an organization, it’s important to have a robust permissions control mechanism to prevent possible poor experiences for Pinners and for our productivity as engineers. 

Role-based permissions and access control lists

At Pinterest, …

Percona is glad to announce the release of Percona Server 5.6.27-76.0 on December 4, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories.

Based on MySQL 5.6.27, including all the bug fixes in it, Percona Server 5.6.27-76.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source and free – …

Percona is glad to announce the release of Percona Server 5.5.46-37.6 on December 4, 2015. Based on MySQL 5.5.46, including all the bug fixes in it, Percona Server 5.5.46-37.6 is now the current stable release in the 5.5 series.

Percona Server is open-source and free. Details of the release can be found in the 5.5.46-37.6 milestone on Launchpad. Downloads are available …

The JSON format includes the concept of array. A JSON object cant contain an attribute of array type. We have seen that we can use the MariaDB CONNECT Storage Engine provided UDFs (user defined functions) to implement dynamic columns. Let us create a table with a text column containing a a JSON string and let ...continue reading "Using JSON’s Arrays for MariaDB Dynamic Columns"

We have created new resources and tools for you and this is a summary of what we’ve recently published. Please do check it out and let us know if you have any comments or feedback.

New Technical Webinar

Polyglot Persistence for the MongoDB, PostgreSQL & MySQL DBA
Tuesday, November 22nd

Join us for our new webinar on Tuesday, December 22nd, which is also our last webinar in 2015! Art van Scheppingen, Senior Support Engineer at Severalnines, will discuss all the main aspects of managing a polyglot open source database environment as well as conduct a live demo to walk you through some examples.

To register and for the full agenda, …

This Log Buffer Edition covers top Oracle, SQL Server and MySQL blog posts of the week.

Oracle:

• In Oracle EBS 12.0 and 12.1 the Workflow notification system was not enabled to send e-mail notifications to users or roles who happened to have multiple e-mail addresses associated to them.
• Just how can a SQL Developer user quickly build out a SQL script for a database user that will include ALL of their privileges, roles, and system grants?
• Oracle BI 12c has been released for some time now. There are a few changes in the way …

When MySQL becomes too slow (or too unstable), temptation usually is to tweak the MySQL configuration file. Indeed, it’s a good place to start. But if you ever looked at the available configuration options, you know things can get messy – MySQL now has over 450 configuration variables for your consideration, that are not classified in any way, and neither of them are included in the stock my.cnf. It’s hard to know where to start!

I’m hoping that this blog post will help you overcome the anxiety of tuning MySQL, whether you’re setting up a new server, or tuning an already running server for better performance.

Don’t do it the way rookies do it

During the last 9 years I’ve spent at Percona working as a MySQL performance and scalability consultant, I found that customers often use the trial and error approach when tuning MySQL configuration: they change a few things and check if it …

Playing around with the Employees sample database and full text search on MySQL, I found a weird bug. After creating a full text targeting a column on a table, a "select distinct" query to retrieve the range of values returns an empty set. So if you initially perform the following query, the outcome comes with 7 rows: mysql> select distinct title from titles; +--------------------+ | title

This blog post explores the syncing options for an inconsistent MySQL slave of Galera cluster node using pt-table-sync

The post Fixing inconsistency on MySQL Slave of Galera Cluster first appeared on Change Is Inevitable.