The latest from the MySQL community

Examples are a great way to learn new things. As many of you may or may not know we’ve added some new things to MySQL Server 5.7.12  and the ecosystem around it, extending it  to allow you to use the MySQL as a Document Store. Meeting the challenge meant expanding Developer Interfaces and Database tools.

• Addressing information with a both classic and modern data architectures
• For all types of data – structured, semi, and unstructured
• Empowering developers – Simpler, Faster, Flexible
• Leveraging latest NoSQL oriented tools/methods – JavaScript, Node.js, JSON, CRUD, Methods chaining, and more

From the developer side the MySQL Document Store new APIs by …

As an update to the previous announcement, please find below list of events where you can find either MySQL Community team or MySQL experts at.  Please find more details at each conference below.  New events are marked with NEW! Any update to already announced event is marked as UPDATE!:

• July 2016:
  • NEW! Debian Conference 2016, Cape Town, Africa (July 2-9, 2016) 
    • MySQL Community team is going to support this conference financially even without staffing. 
  • Open Source Conference Okinawa 2016, Japan (July 2, 2016)
    • As tradition we are going to actively participate at this OS event, this time in Okinawa, Japan. There will …

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.1 Alpha, MariaDB Connector/C 2.3.0, MariaDB Galera Cluster 5.5.50, and MariaDB Galera Cluster 10.0.26. See the release notes and changelogs for details on these releases. Download MariaDB 10.2.1 Alpha Release Notes Changelog What is MariaDB 10.2? MariaDB APT and YUM Repository Configuration Generator […]

The post MariaDB 10.2.1 Alpha and other releases now available appeared first on MariaDB.org.

After studying the differences between MySQL 5.6 and 5.7, and going through a vigorous regression test process, it’s now time for perform the actual upgrade itself. How do we best introduce 5.7 in our live environment? How can we minimize risks? What do we do if something goes wrong? And what tools are available out there to assist us?

The upgrade process

You will most likely perform a rolling upgrade - this means that you will upgrade one slave at a time, taking them out of rotation for the time needed to complete the upgrade. As the binary, in-place upgrade is supported for 5.6 -> 5.7, we can save lot of time by avoiding long dump and reload operations. This makes the upgrade process prompt and easy to perform.

The MySQL Windows Experience Team is proud to announce the release of MySQL for Visual Studio 2.0.3 m2. Note that this is a development preview release and not intended for production usage.

MySQL for Visual Studio 2.0.3 M2 is the second development preview release of the MySQL for Visual Studio 2.0 series.  This series adds support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax that does not assume previous experience writing traditional SQL.

To learn more about how to write applications using the X DevAPI, see http://dev.mysql.com/doc/x-devapi-userguide/en/. For more information about how the X DevAPI is implemented in MySQL for Visual Studio, and its usage, see …

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 details. First, a high-level explanation of how the tool works.

This is an example from the documentation:

pt-online-schema-change --alter "ADD COLUMN c1 INT" D=sakila,t=actor

The tool runs an ALTER on the table “actor” from the database “sakila.” The alter adds a column named “c1” of type …

MySQL Connector/Net 7.0.3 is the second development release of MySQL Connector/Net  7.0 series.

MySQL Connector/Net 7.0 adds support for the new X DevAPI which enables developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax that does not assume previous experience writing traditional SQL.

To learn more about how to write applications using the X DevAPI, see this User’s Guide. For more information about how the X DevAPI is implemented in Connector/Net, please check the official product documentation.

Please note that the X DevAPI requires at least MySQL Server version 5.7.12 or higher with the X Plugin enabled. For general documentation about how to get started using MySQL as a …

With the time MySQL as database getting better in terms of High performance , scalability and security.
MySQL 5.7 new features : http://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html

As a MySQL user my favorites are from above list:

•  New options for replication :
  Changing replication filters online including and excluding table/db and enabling GTID transaction online.
•  InnoDB related changes:
  Online buffer pool resize and many defaults are changed to more secure and optimized values.
• Security features :
  Improved User authentication like default users, SSL and data encryption with key capabilities in order to secure overall database.
• Monitoring and analysis statistics :
  Improved performance schema for live transactions analysis …

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 recover from a crashed pt-online-schema-change is to drop the triggers on your original table and drop the new table created by the script. Then you would restart pt-online-schema-change. In this case, this wasn’t possible.

A customer recently needed to add a primary key column to a very busy table (with around 200 million rows). The table only had a …

Recently I experimented with column-level privileges in MySQL. Column-level privileges are fairly straightforward, but given how infrequently they are used I think there are a few areas worth discussing.

Here are a few high-level observations:

• Users can execute INSERT and UPDATE statements that affect columns they don't have privileges on, as long as they rely on implicit defaults
• Since SQL is row-based, it doesn't make sense to support column-level DELETE privileges, thus only SELECT, INSERT, and UPDATE are supported
• You can grant privileges on multiple columns in one GRANT statement or multiple GRANT statements, the results are cumulative

Read on for more details on each type of …