Mon, 2016-04-25 06:42colin

AliSQL is the fork of MySQL (maintained by Alibaba) that powers all of the group from Tmall, Taobao, Alibaba.com, 1688.com, AliExpress, Cainiao and the payment's network Alipay.

AliSQL isn't new - they've had this fork since 2011: AliSQL 5.1 (Bugfixes for DDL, eliminate race conditions), 2012: AliSQL 5.5 (parallel replication, optimize hot SKUs), 2014: AliSQL 5.6 (Enhanced threadpool, SQL firewall). The team have found/reported/fixed over 40+ bugs, added 41 new features, and optimised 27 bottlenecks. All recent releases of MySQL have had AliSQL contributions (5.6.25 onwards, 5.7.8 onwards, and even 5.8 branch).

AliSQL benefitting MariaDB Server

While not mentioned in the talk, its clear that MariaDB Server 10.0+ has benefited from their tree as well -- our …

If you want to run any php project directly without virtualhost then you can run easily You must have install PHP only Not only core php project but if you have question like how to run codeigniter project how to run yii2 project how to run symfony project how to run zend framework project how

If you want to run laravel project without virtual host then you can run quickly using laravel artisan command if you are beginner and you are confuse how to run laravel application then it is very simple to run so just run bellow command in your terminalstrongRun Projectstrongprephp arti

Laravel is the best framework in PHP todays Laravel framework provide saveral functionality and you can also find from this site But now in this post you can learn how to create custom middleware as filter in laravel 5 example and how to use middleware in laravel 5 In this example you can learn h

Mailgun is very popular API to send email from website It is very fast to send mail and also it track the mail Tracking email is very important feature of mailgun api and you can also see how much user open your mail click on your mail too Mailgun send mail like work gun In this post i would li

Nowdays laravel framework is popular framework in PHP Language So if you required to check if file is exists or not in given path then you can check eisily Normally we always need to check if image exists check if pdf file exists check if docs exists or not etc I give you two way to check file

When i was working in my ionic mobile application on my ubuntu 1404 system and i try to remove android platform at that time i see bellow error premodulejs340 throw err Error Cannot find module bplistparser at FunctionModuleresolveFilename modulejs33815

Over the last couple years on the VividCortex blog, we've discussed a huge range of database monitoring concepts. We've examined ideas we're excited about, shared monitoring practices we recommend, and explored some of the principles that shape our own projects and goals. Of these many posts, however, there are a few in particular worth emphasizing and discussing again and again. Generally, these posts explore the math and statistics behind key monitoring practices and they champion why smart database monitoring is so important; they're often our most read articles, the most indicative of what we value, the influences that make VividCortex a unique product.  

The list below is a quick review of some of VividCortex's key blog posts, coming together to make a Greatest Hits list of our recommended best practices and fundamental concepts. 

• …

The relational database world just changed and you didn't notice, did you? Rather than speaking SQL to your data, what if you could talk to it in PHP directly? No longer do you have to struggle to remember arcane structured query language syntax and just grab data with PHP. You can still write bad queries full of N+1 errors and a whole host of other problems. But you are speaking PHP to your data. And this started with MySQL 5.7.12 and its new Document Store Functionality.

The Document Store functionality expands on the new JSON data type in MySQL 5.7 with a new server plugin, a new API, and a suite of new components designed to make MySQL accessible for users who are not familiar with the SQL language or prefer to use a schemaless data store. This MySQL Server plugin enables communication using the X Protocol. And clients that implement X DevAPI and enables using MySQL as a document store easily. So you can talk to your data in the language …

I thought I posted this long ago... oh well....

We all know that math is the fundamental aspect of all life and the common language used around the world if not beyond. MySQL, like all databases, can help you with numerous aspects of math.

Here is a list of the functions: https://dev.mysql.com/doc/refman/5.6/en/mathematical-functions.html

Here are some simple examples to get you started. 

• The Quadratic Formula  ax^2 + bx + c = 0


# 2x^2  – 4x – 3 = 0.
SET @a=  1;
SET @b=  3;
SET @c= -4;
SET @XX = ( -(@b) - SQRT(  POW(@b,2)  -4 * @a * @c) / POW(@a,2) ) ;
SET @YY = ( -(@b) + SQRT(  POW(@b,2)  -4 * @a * @c) / POW(@a,2) ) ; 
SET @XXX = MOD(@YY, @XX);
…