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 database structures have us design table-shaped ways of storing all our data. As long as all your records (or "rows") are the same shape and have the same sorts of data in approximately the same quantities, this works brilliantly well. There are some common problems that aren't a good …

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.…

In this tutorial you can learn how to add simple pagination in your blade file If you are beginners then it can help you Laravel 5 provide its own method for pagination But if you are work on code PHP then you have to write long code for pagination and render view etc but in Laravel it is very si

In this tutorial i want to share with you how to create image uploading in Laravel 5 If you are beginners then you can do that simply Laravel 5 provide very simple way to create file uploading with proper validation like max file size 2mb file extention should be jpegpngjpggif or svg etc So y

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.…

When i was working on my php project and i need to direct import mysql database in my phpmyadmin in Ubuntu 1404 system but my database size was 30MB so i cant upload my database thats why I need to change upload max file in phpini so try to find something how to change uploadmaxfilesize in

You can get location path of phpini file using phpiniloadedfile of PHP Sometimes we require to get phpini file path So if you need to get path of php confogration file then you can get following waystrongExamplestrongpre classprettyprint langphpprintrphpiniloadedfile

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 ...continue reading "MariaDB AWS Key Management Service (KMS) Encryption Plugin"

Thank you for the write up. I’m considering doing exactly what this article describes. Our developers are interested in setting up a mission critical JIRA instance for QA and bug tracking. This translates to 1000 active users and several million bugs (eventually).

You mention having 2000 active JIRA users. I was wondering if you could share additional infrastructure details about your JIRA instance. How large is the production DB in terms of disk space? What are you using to backup the DB (xtradump, mysqldump, SAN snapshot)?

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 the following to the [mysqld] section of /etc/my.cnf:

View the code on Gist.

1b. Restart the server:

...
service mysqld restart

1c. Verify:

... …