After publishing Part 2 of a series on JSON data in MySQL last week, a few folks reached out to me with some great feedback. Not only that, but they shared some resources I thought would be beneficial to pass on.

Morgan Tocker, the Product Manager that works on JSON support in MySQL pointed me toward the MySQL Server Team’s blog, which is more approachable than the docs for topical matters and directed discussion. Specifically he highlighted the JSON category, which has several great posts on everything from using path expressions to ‘upgrading’ json data previously stored in TEXT data columns to JSON data columns. Definitely worth perusing.

…

Join us for our latest webinar on Thursday, April 7, at 10 am PDT (UTC-7) on Introduction to Troubleshooting Performance: What Affects Query Execution?

MySQL installations experience a multitude of issues: server hangs, wrong data stored in the database, slow running queries, stopped replications, poor user connections and many others. It’s often difficult not only to troubleshoot these issues, but to even know which tools to use.

Slow running queries, threads stacking for ages during peak times, application performance suddenly lagging: these are some of the things on a long list of possible database performance issues. How can you figure out why your MySQL installation isn’t …

Your Database, Any Cloud - NinesControl (beta)

As you may have seen, we recently announced NinesControl, a developer friendly service to deploy and manage MySQL and MongoDB clusters using your preferred Cloud Provider.

There is still time for you to join and get an early look at NinesControl - just provide us with your email address, and we will be in touch to give you early access to the service.

NinesControl users will be able to benefit from the following key features:

• Provision a database on any cloud
• Real-time unified monitoring
• Automated database management and availability

Sign up up to stay informed and apply for early access

And see further details on NinesControl below in this blog.

What is NinesControl?

…

Whenever you require to create all array value in lowercase then you can create that without using loop you have to just use arraymap arraymap function take two argument one for php function strtolower and second one for array May be we need to do this when we are working on big projects an

Sometimes we need to fire trigger like after delete update some fields of another tables for example if you have chatmessage tables and when remove row on this table then we need to update removecounterremovecounter 1 on users table i did give you bellow example you can see how to write t

Sometimes we need to fire trigger like after delete update some fields of another tables for example if you have chatmessage tables and when remove row on this table then we need to update removecounterremovecounter 1 on users table i did give you bellow example you can see how to write t

When you are working php or net etc and you return data like jsonencodedata on ajax request but in front side you get like a string at that time you have to parse json object and get them so lets see example and learn how to usestrong classexampleExamplestrong pre classprettyp

If you are work on laravel 5 application and you require to get user agentuser agent mean user browser details like firefox cherome etc then you can get easy you dont need to use SERVER variable like native PHP but laravel 5 provide Request facade you can fetch easy using following example

You may want to dump diagnostic information about the running MySQL Database.    

For MySQL 5.7, the SYS schema comes with the installation.  You can find the corresponding information on
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html

For MySQL 5.6,the SYS schema can be downloaded from the following URL https://github.com/mysql/mysql-sys
The zip file as ‘mysql-sys-master.zip’ is expanded, where the sys_56.sql can be loaded into the MySQL 5.6 database.
# mysql -uroot -h127.0.0.1 < sys_56.sql
Using MySQL Workbench and connecting to the Server, you can find the SYS schema installed.

Running the “diagnostics” stored procedure : …

To synchronize the data between the Galera Cluster and a new or re-entering Galera node Galera Cluster uses 2 different mechanisms:

• For full synchronization of data: Snapshot State Transfer (SST).
• For delta synchronization of data: Incremental State Transfer (IST).

The Incremental State Transfer (IST) is relevant when a node is already known to the Galera Cluster and just left the cluster short time ago. This typically happens in a maintenance window during a rolling cluster restart.

The Galera Cache is a round-robin file based cache that keeps all the write-sets (= transactions + meta data) for a certain amount of time. This time, which should be bigger than your planned maintenance window, depends on the size of the Galera Cache (default 128 Mbyte) and the traffic which will happen during your maintenance window.

If your traffic is …