Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 17790 10 Older Entries

Displaying posts with tag: mysql (reset)

MySQL 5.7 Introduces a JSON Data Type
+1 Vote Up -0Vote Down

There's a new JSON data type available in MySQL 5.7 that I've been playing with. I wanted to share some examples of when it's useful to have JSON data in your MySQL database and how to work with the new data types (not least so I can refer back to them later!)

MySQL isn't the first database to offer JSON storage; the document databases (such as MongoDB, CouchDB) work on a JSON or JSON-ish basis by design, and other platforms including PostgreSQL, Oracle and SQL Server also have varying degress of JSON support. With such wide adoption as MySQL has, the JSON features are now reaching a new tribe of developers.

Why JSON Is Awesome

Traditional …

  [Read more...]
Ubuntu 16.04 first stable distro with MySQL 5.7
Employee_Team +2 Vote Up -0Vote Down

Ubuntu 16.04 artwork by Canonical Ltd (CC-BY-SA).

Congratulations to Ubuntu on releasing 16.04 LTS with MySQL 5.7! As far as I know, it’s the first stable release of a Linux distro that contains MySQL 5.7. Fedora and openSUSE also have MySQL 5.7, but not yet in a stable release.…

Thanks for stopping by!
Employee_Team +1 Vote Up -0Vote Down

The MySQL Engineering Team at their BOF session on Tuesday night. Sunny Bains in focus answering InnoDB questions.

On behalf of the entire team, I would like to thank you for stopping by our “meet the MySQL engineering team” BOF held Tuesday night.…

MariaDB AWS Key Management Service (KMS) Encryption Plugin
+1 Vote Up -0Vote Down

MariaDB 10.1 introduced Data at Rest Encryption. By default we provide a file_key_management plugin. This is a basic plugin storing keys in a file that can be itself encrypted. This file can come from a usb stick removed once keys have been brought into memory. But this remains a basic solution not suitable for security [...]

Data Encryption at Rest in Oracle MySQL 5.7
+1 Vote Up -0Vote Down

 

I’ve previously evaluated MariaDB’s 10.1 implementation of data encryption at rest (https://www.pythian.com/blog/data-encryption-rest), and recently did the same for Oracle’s implementation (https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace-encryption.html) in their MySQL 5.7.

 

First, here’s a walkthrough of enabling encryption for MySQL 5.7:

1. Install keyring plugin.

1a. Add …

  [Read more...]
MySQL 5.7.12 – MySQL Document Store – YouTube Video
Employee_Team +1 Vote Up -0Vote Down

Today we are introducing a new MySQL Server feature called MySQL Document Store. Make sure to watch the announcement video on the MySQL YouTube Channel!

Find out more by looking into the following documents.

  [Read more...]
Announcing MySQL Connector/J 6.0
Employee_Team +1 Vote Up -0Vote Down

We are pleased to announce the first release of MySQL Connector/J 6.0! This is a new branch of development, which breaks from some of the traditions of the very stable and very mature Connector/J 5.1 branch. We have combed through lots of code and refactored it in order to support development of future features including our X DevAPI implementation and support for X Protocol. This work manifests in a number of visible changes, including revising the growing set of connection and build …

  [Read more...]
MySQL 5.7.12 – Part 6: MySQL Document Store – A New Chapter in the MySQL Story
Employee_Team +1 Vote Up -0Vote Down

So hopefully you’ve read the first 5 blogs in this 6 part series you should have a good introduction to
•    Part 1 – What we heard from the MySQL Community (keep it solid, and innovate faster) and our change to new release model those requirements.…

Percona Live 2016: A quick chat with Bill Nye, the Science Guy!
+0 Vote Up -0Vote Down

Percona Live is humming along, and we had quite a whirlwind keynote session this morning. Bill Nye the Science Guy gave an amazing talk, Bill Nye’s Objective – Change the World, on how the process of science and critical thinking can help us not only be positive about the challenges we face in our world today, but also help us to come up with the big ideas we need to solve them. He discussed …

  [Read more...]
(MySQL) Performance Monitoring with Prometheus [UPDATE]
+0 Vote Up -0Vote Down

In my last I was looking for a way to do performance monitoring and I stumbled upon Prometheus. Prometheus is much more than monitoring a single node service. Anyway let’s get the idea of gathering metrics using MySQL as example.

This how a simple configuration of Prometheus could look like:

global: 
  scrape_interval: 1m
  scrape_timeout: 10s
  evaluation_interval: 1m

scrape_configs:
  - job_name: mysql
    scheme: http
    target_groups:
    - targets: 
        - '10.17.148.31:9104'
      labels:
        zone: mysql

Every minute Prometheus …

  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 17790 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.