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
Apr
12
2016
Apr
12
2016
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
Apr
12
2016
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 …
Apr
12
2016
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
Apr
11
2016
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…[Read more]
Apr
11
2016
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, …
Apr
11
2016
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 …
[Read more]
Apr
11
2016
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.…
Apr
11
2016
In a few days, I will be flying to San Francisco and then making my way to Santa Clara to attend the Percona Live Conference. On the last day of the conference (Thursday), I will speak about MySQL Parallel Replication. I hope to see you there and I will he happy to answer questions you might have (on this subject and others):
Thursday at 12:50 pm: MySQL Parallel Replication: inventory,
Apr
11
2016