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.

This year, Percona introduced Community Voting for Percona Live submission.  This is what you can read on the conference website:

In an effort to involve the larger community in the selection of speaking sessions for the 2016 Percona Live Data Performance Conference, we’ve implemented a community voting process. After a speaker submits a proposal we encourage sharing to the community and social

We're thrilled to announce VividCortex's new partnership with Percona -- the only company that delivers enterprise-class solutions for both MySQL and MongoDB across traditional and cloud-based platforms. As part of the partnership, Percona will resell VividCortex as a value-added monitoring solution, and Percona's own support technicians and managed service administrators will have VividCortex at their fingertips, to assist in serving and optimizing their customers’ applications.  

Including VividCortex as part of Percona's services will provide enterprise users of Percona Server for MySQL and Percona Server for MongoDB with the safest, most streamlined, and precise method for monitoring high performance data systems. Percona customers who opt for VividCortex will enjoy improved visibility and greater insights into their database performance …