Sometimes we want to display loading image or animation or text when fire every ajax request In not for only one ajax request but if you want to load image on every ajax request then you can do that using bellow exampleI use ajaxStart and ajaxComplete function for show image until All POST

Tue, 2016-04-12 16:06Johan

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

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

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 SSL has been available in MaxScale for a while, but it has been somewhat unreliable. We now believe that client side SSL is fully …

Based on messages, we create mysql replication platforms , using async message to build strong distributed subscription system.

read this PDF : http://www.vmcd.org/docs/MySQL_async_message.pdf

Whenever you require to strip HTML tags usign Angular Filter then this post can help you If you are working on php then it is very easily use predefine function But in AngularJS you need to make your own filter for remove html tag from string So In bellow example you can see how to create and us

Percona Live is a Christmas in MySQL world. It’s time when all friends and family gather over a glass of beer. Everyone is talking about achievements of the last year and make New Year resolutions for a next one.

There will be two talks from TwinDB this year. One is about data recovery and one – about backups.

The data recovery talk is a kind of traditional talk. I will briefly cover InnoDB files format so you know where to look for data. I will show how to recover data from two most popular accidents: InnoDB tablespace corruption and DROP TABLE or DROP DATABASE. Data recovery is impossible without table structure recovery. I will show how to get the structure from an .frm file or from InnoDB dictionary (think of DROP TABLE when the .frm file is gone). We made a drastic improvement in user …

In this tutorial post i show you the example of Stripe subscription example using Laravel Cashier in Laravel 51 application In this example i use Laravel CashierBilling of Laravel 5 Whenever you are work on big project like ecommerce or ERP on that project mostly we need to use subscription pla

In this blog post, we will discuss how to deal with jumbo chunks in MongoDB.

You are a MongoDB DBA, and your first task of the day is to remove a shard from your cluster. It sounds scary at first, but you know it is pretty easy. You can do it with a simple command:

db.runCommand( { removeShard: "server1_set6" } )

MongoDB then does its magic. It finds the chunks and databases and balances them across all other servers. You can go to sleep without any worry.

The next morning when you wake up, you check the status of that particular shard and you find the process is stuck:

"msg" : "draining ongoing",
"state" : "ongoing",
"remaining" : {
"chunks" : NumberLong(3),
"dbs" : NumberLong(0)

There are three chunks that for some reason haven’t been migrated, so the

removeShard

A wise man once said that the safest way to store date and time values in MySQL is to store Unix timestamps in an unsigned INT column. I agree with Baron, but most of us have to deal with DATE, DATETIME, and/or TIMESTAMP values sometimes, and it's often useful to know how to convert values from one time zone to another.

The CONVERT_TZ() Function

You can convert a temporal value in MySQL from one time zone to another using the CONVERT_TZ() function. As an example, say I want to watch the Boston Marathon in Melbourne, Australia but I'm afraid it may be on after my bed time. The elite men start at 10:25 AM on April 18, 2016. Boston's time zone will be EDT that day, …

In this blog post we’ll discuss a caveat when downloading MariaDB MaxScale binaries.

Following the previous performance results in my last two posts on sysbench and primary keys (https://www.percona.com/blog/2016/04/07/mysql-5-7-sysbench-oltp-read-results-really-faster/ and https://www.percona.com/blog/2016/03/28/mysql-5-7-primary-key-lookup-results-is-it-really-faster/), I wanted to measure overhead from proxies servers like ProxySQL and MaxScale.

Unfortunately, I found that MaxScale binaries are not available without registering on the …

MySQL 5.7.12 is the fourth stable (GA) release of the MySQL 5.7 series. It brings with it the usual bug fixes and incremental enhancements that you would expect with a point release. Except this time things are a little bit different.…