Thứ Tư, 6 tháng 7, 2016

Chủ Nhật, 26 tháng 6, 2016

Thứ Năm, 23 tháng 6, 2016

SET sql_log_bin Syntax

SET sql_log_bin = {0|1}
 
 
The sql_log_bin variable controls whether logging to the binary log is done. The default value is 1 (do logging). To change logging for the current session, change the session value of this variable. The session user must have the SUPER privilege to set this variable. Set this variable to 0 for a session to temporarily disable binary logging while making changes to the master which you do not want to replicate to the slave.
As of MySQL 5.5, sql_log_bin can be set as a global or session variable. Setting sql_log_bin globally is only detected when a new session is started. Any sessions previously running are not impacted when setting sql_log_bin globally.
Warning
Incorrect use of sql_log_bin with a global scope means any changes made in an already running session are still being recorded to the binary log and therefore replicated. Exercise extreme caution using sql_log_bin with a global scope as the above situation could cause unexpected results including replication failure.
In MySQL 5.7, it is not possible to set @@session.sql_log_bin within a transaction or subquery. (Bug #53437)
 

Thứ Hai, 23 tháng 5, 2016

RateLimiter control TPS for PHP & Java

Class yii\filters\RateLimiter

Inheritanceyii\filters\RateLimiter » yii\base\ActionFilter » yii\base\Behavior » yii\base\Object
Implementsyii\base\Configurable
Available since version2.0
Source Code https://github.com/yiisoft/yii2/blob/master/framework/filters/RateLimiter.php    
RateLimiter implements a rate limiting algorithm based on the leaky bucket algorithm.
You may use RateLimiter by attaching it as a behavior to a controller or module, like the following,
public function behaviors()
{
    return [
        'rateLimiter' => [
            'class' => \yii\filters\RateLimiter::className(),
        ],
    ];
}
 
 
When the user has exceeded his rate limit, RateLimiter will throw a yii\web\TooManyRequestsHttpException exception.
Note that RateLimiter requires $user to implement the yii\filters\RateLimitInterface. RateLimiter will do nothing if $user is not set or does not implement yii\filters\RateLimitInterface.
 

Thứ Sáu, 20 tháng 5, 2016

Test on the right mobile devices

https://www.browserstack.com


The mobile and tablet landscape today is highly fragmented, spanning many devices across manufacturers and models. Supporting and testing on the maximum number of mobile devices is crucial to any website, but it can be a huge investment of time, effort, and money. Therefore, it is critical to choose the ideal list of devices to test your mobile websites.
The devices have been carefully selected to provide maximum coverage, considering such parameters as:
  • Market share and popularity
  • OS and OS versions
  • Screen sizes
  • Viewports and resolutions
  • Upcoming devices
  • Launch year
  • Manufacturers

Thứ Tư, 11 tháng 5, 2016

vis.js

A dynamic, browser based visualization library. The library is designed to be easy to use, to handle large amounts of dynamic data, and to enable manipulation of and interaction with the data. The library consists of the components DataSet, Timeline, Network, Graph2d and Graph3d. Get it over here!