Starting with MySQL 5.7 we introduced the Query Rewrite Plugin. That tool is really useful for changing queries. Of course the best location to modify the query is the source code of the application, but this is not always possible. Either the application is not under your control or queries are generated from a framework like Hibernate and sometimes it is hard to change the query generation.
If you are interested in details about the Query Rewrite Plugin, I recommend this blogpost from the MySQL Engineering: http://mysqlserverteam.com/the-query-rewrite-plugins/
Recently I was asked how this works in replication environments. Which query goes into the binlog?

If you are using the Rewriter plugin that comes with MySQL 5.7, the answer is easy: This plugin only supports rewriting SELECT queries. SELECT queries don't get into the binlog …

Interesting developments in the MySQL world – it can now be used as a document store and you can query the database using JavaScript instead of SQL (via the MySQL Shell). There is also a new X Plugin (see: mysql-5.7.12/rapid/) (which now makes use of protocol buffers (see: mysql-5.7.12/extra/protobuf/)). I will agree, this is more than just a maintenance release.

Do get started playing with MySQL Shell. If you’re using the yum repository, remember to ensure you have …

Most of the time we require to check specific element is exists or not in javascript but jquery provide length method that can help to check element is exists or not If you are new and want to do this then see bellow examplestrong classexampleExamplestrongpre classprettyprint lan

Today i will let you know example of laravel check if record exists in database We will look at example of laravel check if record not exists This post will give you simple example of laravel check if record exists in table lets discuss about laravel check if record exists in database So let

Sometimes we want to make Capitalize string in our AngularJS project then we have to create filter because AngularJS not provide any predefined function that can Capitalize word or string However you can solve this problem by makeing your own filter that can help you to make Capitalize string o

If you have been following our multi-part blog-post series around MySQL 5.7.12 so far you have heard on term a lot: “X”. So what does X stand for? A very good question, let’s see if Part 3 of the blog-post series on the MySQL Document Store will help you finding more about that.…

I recently tried my hands at TDD to develop a basic ToDo app using QUnit as the testing framework.

Here is the link to the application demo.
I have written both unit and integration / functional tests while developing this app. The source code can be checked here.
To run and see the results of tests, refer below links:

Unit test results
Integration / Functional test …

In some situations we require to check if view exists then render view otherwise display something else But you can perform this task using exists function of view helper It will return true or false So you can use bellow examplestrong classexampleExamplestrong pre classprettypr

In this post i want to share about how to update node version in ubuntu OS I would like to share this post because i try lot to update my node js package When i install 01025 nodejs but i want to update nodejs current latest version At that time i did try lot to upgrade but i cant update my no

The X Protocol

For the MySQL Document Store we developed a new protocol to lay out a solid foundation for the features we’ll implement over the next years.

Building a Protocol with Async APIs in mind

Asynchronous APIs are all about executing other work while a task gets blocked.

…