Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.

This Log Buffer Edition covers some of the hottest blog posts of Oracle, SQL Server and MySQL for the previous week.

Oracle:

A recent post on the OTN database forum reminded Jonathan how easy it is to forget to keep repeating a piece of information after the first couple of hundred times you’ve explained it. No matter how “intuitively obvious” it is for one person, it’s new to someone else.

The OMS Patcher is a newer patching mechanism for the OMS specifically.

A SQLT report has all kinds of pertinent information including—to name …

Gravatar is a service that provide unique globally avatars and integrated it into their WordPresscom blogging platform If you dont have avatar image then you can get Gravatar src image from thier email if it register on WordPresscom So if you want to implement in your laravel application then i

We’re excited to be presenting the latest version of ClusterControl, the one-stop console for your entire database infrastructure, during our next live webinar on May 24th. We’ll be introducing some cool new features for MySQL and MongoDB users in particular as well as walk you through the work we’ve recently done for improved security.

Date, Time & Registration Europe/MEA/APAC

Tuesday, May 24th at 09:00 BST / 10:00 CEST (Germany, France, Sweden)
Register Now

North America/LatAm

Tuesday, May 24th at 09:00 Pacific Time (US) / 12:00 Eastern Time (US)
Register Now

Our colleagues Johan Andersson (CTO), Vinay Joosery (CEO) and Ashraf Sharif (System Support Engineer) will be demonstrating …

In this post, we’ll discuss how you can quick start MySQL testing using Docker, specifically in a Mac environment.

Like a lot of people, I’m hearing a lot about Docker and it’s got me curious. The Docker ecosystem seems to be moving quickly, however, and simple “getting started” or “how-to” type articles that are easy to find for well-established technologies seem to be out-of-date or non-existent for Docker. I’ve been playing with Docker on Mac for a bit, but it is definitely a second-class citizen in the Docker world. However, I saw Giuseppe’s blog on the new Docker beta for Mac and decided to try it for myself. These steps work for the beta version on a Mac (and probably Windows), but they should work with …

How useful is a benchmark that doesn’t stress the optimizer?

If you are working with REST API then you always need to return json data response that way frontend developer can handle it easily i created bellow controller method in this method i return json array response that way you can understand very well laravel 5 provide response helper and it will

Sometimes we need to create file of our project directory and give to download that zip file to users we are always prefer zip file because it is very safe and secure from virus If you want to generate zip file and donwload that file in your laravel 5 application then you do it easily using chump

If you require to remove cordova and ionic from ubuntu then you uninstall using terminal command you can uninstall cordova then you can just run bellow command I added two command one for uninstall cordova and other uninstall ionic frameworkstrongExamplestrongpre classprettyprint lang

In this blog post, we’ll discuss how the Query Rewrite plugin can harm performance.

MySQL 5.7 comes with Query Rewrite plugin, which allows you to modify queries coming to the server. (You can view the details here: https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html.)

It is based on the audit plugin API, and unfortunately it suffers from serious scalability issues (which seems to be the case for all API-based audit plugins).

I want to share the results for sysbench OLTP RO with and without the query rewrite plugin — but with one very simple rewrite rule, which doesn’t affect any queries. This is the rule from the documentation:

INSERT INTO query_rewrite.rewrite_rules (pattern, replacement)
    -> VALUES('SELECT ?', 'SELECT ? + 1');

There are results for both …