Sometimes we require to get randomly data using laravel query builder you can use mysql rand with order by If you want to get random data using laravel eloquent then we need to use DBraw In bellow example you can i use DBrawIn this example i use DBrawRAND inside orderBy an

Wed, 2016-05-04 07:17Johan Wikman

We are pleased to announce that MariaDB MaxScale 1.4.3 GA is now available for download!

If MariaDB MaxScale is new to you, we recommend reading this page first.

1.4.3 is a bugfix release, not bringing any new features but fixing certain issues found in 1.4.2.

MariaDB MaxScale 1.4 brings:

1. The Firewall Filter has been extended and can now be used for either black-listing or white-listing queries. In addition it is capable of logging both queries that match and queries that do not match.
2. Client-side …

I'm very pleased to be able to announce the immediate availability of the Open Data Export Layer (ODXL) for SAP/HANA! Executive summaryODXL is a framework that provides generic data export capabilities for the SAP/HANA platform. ODXL is implemented as a xsjs Web service that understands OData web requests, and delivers a response by means of a pluggable data output handler. Developers can use ODXL as a back-end component, or even as a global instance-wide service to provide clean, performant and extensible data export capabilities for their SAP/HANA applications.

Currently, ODXL …

I want to share this posts because when i was working in my laravel application i need to find word from string I mean check string contains word or not but i try to do at last i found two way we can check easily First one using pregmatch and other one strpos of php predefine if you have ques

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.25. See the release notes and changelog for details on this release. Download MariaDB Galera Cluster 10.0.25 Release Notes Changelog What is MariaDB Galera Cluster? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

The post MariaDB Galera Cluster 10.0.25 now available appeared first on MariaDB.org.

In this post, we’ll examine why in an initial flushing analysis we find that Performance Schema data is incomplete.

Having shown the performance impact of Percona Server 5.7 patches, we can now discuss their technical reasoning and details. Let’s revisit the MySQL 5.7.11 performance schema synch wait graph from the previous post, for the case of unlimited InnoDB concurrency:

First of all, this graph is a little “nicer” than reality, which limits its diagnostic value. There are two reasons for this. The first one is that page cleaner worker threads are invisible to Performance Schema (see bug 79894). This alone …

As promised, here are my slides from Percona Live Conference in US, Apr.2016 :

• MySQL 5.7 Performance & Scalability Benchmarks (PDF)
• MySQL 5.7 Demystified Tuning (PDF)

Feel free to ask any questions or details you're needing, etc..

Also, not really related to MySQL, but as I was asked so many times about "how did you manage to project your slides from Mac, but drive it an annotate via iPad?" - here is a short HOWTO:

• you need to have Keynote app installed on both your Mac and iPad
• you create your own WiFi Network on your Mac (MenuBar->WiFi->Create Network...)
• once done, connect to …

In this blog post, we’ll discuss some of the best practices for configuring optimal MySQL memory usage.

Correctly configuring the use of available memory resources is one of the most important things you have to get right with MySQL for optimal performance and stability. As of MySQL 5.7, the default configuration uses a very limited amount of memory – leaving defaults is one of the worst things you can do. But configuring it incorrectly can result in even worse performance (or even crashes).

The first rule of configuring MySQL memory usage is you never want your MySQL to cause the operating system to swap. Even minor swapping activity can dramatically reduce MySQL performance. Note the keyword “activity” here. It is fine to have some used space in your swap file, as there are …

In this example i give you how to add timepicker in your php application or html etc this is full example if you just copy and past bellow code then you can find timepicker you no need to install anything I use datetimepicker library for timepicker that way you can also set datepicker too bootst

Tue, 2016-05-03 12:35M. Luisa Raviol

At the 2016 Open Source Conference in Rome, held a few weeks ago, MariaDB was present along with many of the most relevant players in the Open Source community. This included the Italian Public Administration. They are required by law to give preference to free software and open source software. The goal of the Italian Open Source Observatory is to promote the use of open source software in Italian public administrations. They monitor and collect information on cases of open source adoption and best practices related to open technology usage within institutions.

Our focus at the conference this year was in particular on the new important MariaDB security features. They're part of our open source offering starting with the release of MariaDB 10.1. It's extremely important that these features are accessible to all MariaDB users. However, it's very relevant for the Italian Public Administration …