Category: Uncategorized

Push notifications are a powerful engagement strategy for app developers, hyped particularly because of their personalisation and targeting features. When used appropriately, they can bring your brand closer to users, make them more loyal and increase their frequency of app use.  Unfortunately, given the now widespread adoption (and abuse) of …

Being an analytics/reporting product company, we’ve worked with a fair amount of customers who run Postgres/Redshift for their analytics, and the same fair amount who uses MySQL. And from our experience with both, I’d prefer our new customers to use Postgres all the time. For reporting/analytics/data-warehouse purpose, Postgres wins over …

We’re often using MySQL so much, like read data from DB, calculate something, write data with index. And I bet You know, that process is also using your i/o machine. I prefer my CPU usage 100% than my i/o 50%. Redis is live in memory, so it won’t do anything …

MySQL cache in PHP $r = new Redis(); $r->connect(“127.0.0.1”, “6379”); $id = (int) $_REQUEST[“id”]; $sql = “select * from users where id = $id”; // Create a hash key $key = “sql_cache:” . md5($sql); // Check if data is in cache. if ($data = @unseralize( $r->get($key) ) === false){ $data …

It’s a common occurrence to have two and more load balancers as HA frontends to databases at high traffic sites. I’ve used the open-source HAproxy like this, and have seen others use it. Building this infrastructure and getting the traffic distributed evenly is not really the topic I’d like to …