EmergencyEMERGENCY? Get 24/7 Help Now!

MariaDB 10.2 CHECK and DEFAULT clauses

 | July 29, 2016 |  Posted In: MariaDB, MySQL

MariaDB 10.2 CHECK and DEFAULT

In this blog post, we’ll look at the MariaDB 10.2 CHECK and DEFAULT clauses. MariaDB 10.2 includes some long-awaited features. In this blog, we are going to discuss the improvements to some table definitions: the DEFAULT clause and the CHECK constraints. These clauses describe columns default values and rules for data validation. Note that MariaDB […]

Read More

Upcoming Webinar August 2 10:00 am PDT: MySQL and Ceph

 | July 28, 2016 |  Posted In: MySQL, Technical Webinars

MySQL and Ceph

Join Brent Compton, Kyle Bader and Yves Trudeau on August 2, 2016 at 10 am PDT (UTC-7) for a MySQL and Ceph webinar. Many operators select OpenStack as their control plane of choice for providing both internal and external IT services. The OpenStack user survey repeatedly shows Ceph as the dominant backend for providing persistent storage volumes […]

Read More

The Value of Database Support

 | July 20, 2016 |  Posted In: MongoDB, MySQL, Percona Support

database support

In this post, I’ll discuss how database support is good for your enterprise. Years ago when I worked for the MySQL Support organization at the original MySQL AB, we spoke about MySQL Support as insurance and focused on a value proposition similar to that of car insurance. You must purchase car insurance before the incident […]

Read More

Upcoming Webinar Wednesday July 20, 11 am PDT: Practical MySQL Performance Optimization

 | July 19, 2016 |  Posted In: MySQL

MySQL Performance Optimization

Are you looking to improve your MySQL performance? Application success is often limited by poor MySQL performance. Please join Percona CEO and Founder Peter Zaitsev for this exclusive webinar on Wednesday, July 20th, 2016 at 11:00 AM PDT (UTC – 7) as he presents “Practical MySQL Performance Optimization“. Peter Zaitsev discusses how to get excellent […]

Read More

Using Ceph with MySQL

 | July 13, 2016 |  Posted In: Hardware and Storage, High-availability, MySQL, OpenStack

Ceph

Over the last year, the Ceph world drew me in. Partly because of my taste for distributed systems, but also because I think Ceph represents a great opportunity for MySQL specifically and databases in general. The shift from local storage to distributed storage is similar to the shift from bare disks host configuration to LVM-managed […]

Read More

Percona Server 5.6.31-77.0 is now available

 | July 7, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server, Percona Software, TokuDB

percona server 5.6.30-76.3

Percona announces the release of Percona Server 5.6.31-77.0 on July 7th, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.31, including all the bug fixes in it, Percona Server 5.6.31-77.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source and free – this […]

Read More

MySQL 5.7, utf8mb4 and the load data infile

 | July 5, 2016 |  Posted In: MySQL

utf8mb4 and the load data infile

In this post, I’ll discuss how MySQL 5.7 handles UTF8MB4 and the load data infile. Many of my clients have told me that they do not like using the LOAD DATA INFILE statement and prefer to manually parse and load the data. The main reason they do it is issues with the character sets, specifically […]

Read More

Amazon RDS and pt-online-schema-change

 | July 1, 2016 |  Posted In: MySQL

Amazon RDS and pt-online-schema-change

In this blog post, I discuss some of the insights needed when using Amazon RDS and pt-online-schema-change together. The pt-online-schema-change tool runs DDL queries (ALTER) online so that the table is not locked for reads and writes. It is a commonly used tool by community users and customers. Using it on Amazon RDS requires knowing about some specific […]

Read More

Rescuing a crashed pt-online-schema-change with pt-archiver

 | June 30, 2016 |  Posted In: MySQL, Percona Server, Percona Software, Percona Toolkit, Replication

crashed pt-online-schema-change

This article discusses how to salvage a crashed pt-online-schema-change by leveraging pt-archiver and executing queries to ensure that the data gets accurately migrated. I will show you how to continue the data copy process, and how to safely close out the pt-online-schema-change via manual operations such as RENAME TABLE and DROP TRIGGER commands. The normal process to […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.