In the previous blog posts, we gave a brief introduction to ClusterControl Developer Studio and the ClusterControl Domain Specific Language and how to extract information from the Performance Schema. ClusterControl’s Developer Studio allows you to write your own scripts, advisors and alerts. With just a few lines of code, you can already automate your clusters!

In this blog post we will dive deeper into Developer Studio and show you how you can keep an eye on performance and at the same time scale out the number of read slaves in your replication topology whenever it is necessary.

CMON RPC

…

Azerbaijan MySQL User Group next meeting was with IT girls from “WoWoman” division in Baku.
We have talked about Linux and MySQL.
There was a hands-on lab about installing Ubuntu, working with basic Linux commands.

I would like to share some photos from this event

MySQL replication performance is a topic that requires no special introduction. Replication was never designed to be extremely fast and there isn't a single MySQL DBA who wouldn't learn it the hard way.
Today, with the improvements introduced in MySQL 5.7, as well as a complete re-implementation done by Amazon Aurora, it seems like we can finally see the light at the end of this very long tunnel.
Let's take both products for a spin and see how they behave. Introduction Before we get busy with the benchmarks, let's quickly explain why MySQL 5.7 and Amazon Aurora are so special. I wouldn't spend a weekend testing them if they weren't, right? MySQL MySQL 5.7 finally uses multi-threaded slave (MTS) implementation that makes sense. Long story short: instead of doing poor man's multithreading that requires you to split your data into multiple schemas (and doesn't guarantee consistency for cross-schema modifications), it can simply replay …

Events provides a simple observer implementation allowing you to subscribe and listen for events in your application In this posts you can learn how to create event for email send in your laravel 52 application event is very help to create proper progmamming way First create event using bellow

Codership is pleased to announce the release of Galera Cluster 5.5.48 and 5.6.29 with Galera Replication library 3.15, implementing wsrep API version 25.

The library is now available as targeted packages and package repositories for a number of Linux distributions, including, RHEL, Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

This release incorporates all changes up to MySQL 5.5.48 and 5.6.29.

New features and notable fixes in Galera replication since last binary release by Codership (3.14):

• fixes for compiling on Alpha / HP PA / s390x architectures (codership/galera#389)
…

In this tutorial i going to show you how to make real time chat message module using socketio redis express and nodejs in Laravel 5 socketio through we can make real time chat module in our Laravel 5 application i show you from scratch because you can install nodejs and its packages etc in t

Galera und Docker Network

Using Docker to run Galera on multiple nodes is quite a mess as described here. It is possible but no fun at all. As Docker does NATing every bidirectional setup is complicated.

Starting with Docker Network (version 1.9) you can simply span a Docker owned network (multiple of them) over multiple nodes. These networks are separated as the known bridged network Docker uses by default. It also provides a simple node/container discovery using the --name switch. Feels like a simple DNS.

Let's have a look how easy it is to deploy a Galera cluster. It is not for production. I use my own Docker image. It is just to play around.

There are our nodes:

• Swarm1 IP=172.17.152.11
• Swarm2 IP=172.17.152.12
• Swarm3 IP=172.17.152.13

At the …

If you have jquery or javascript array with lots of undefined value and you want to remove all undefined value from array you can remove undefined items from your array without using each loop you have to just use filter I would like give the example how to remove undefined element from javascript

Mysql custom fucntion is a very prety and intresting concept In this posts i want to create one custom mysql function for remove numeric characters from table field value this function through you can also remove numeric characters from string in mysql in following sql query fire in your mysql or

This is a response to the JSON document fast lookup with MySQL 5.7 article by Frederic Descamp.

It is very easy to also use MySQL Workbench and the new GeoJSON support to actually show the features.

My query:
SELECT ST_GeomFromGeoJSON(feature->"$.geometry",2) AS feature 
FROM test_features WHERE street='BEACH' ;

The result: