101 Tips to MySQL Tuning and Optimization

MySQL is a powerful open-source database.  With more and more database driven applications, people have been pushing MySQL to its limits.  Here are 101 tips for tuning and optimizing your MySQL install.  Some tips are specific to the environment they are installed on, but the concepts are universal.   I have …

Smokeping

SmokePing keeps track of your network latency: Best of breed latency visualisation. Interactive graph explorer. Wide range of latency measurement plugins. Master/Slave System for distributed measurement. Highly configurable alerting system. Live Latency Charts with the most ‘interesting’ graphs. Free and OpenSource Software written in Perl written by Tobi Oetiker, the …

6 Proven Ways To Make Your Push Notifications Irresistible To Open

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 …

What is Data Integrity? Learn How to Ensure Database Data Integrity via Checks, Tests, & Best Practices

Data integrity is a fundamental component of information security. In its broadest use, “data integrity” refers to the accuracy and consistency of data stored in a database, data warehouse, data mart or other construct. The term – Data Integrity – can be used to describe a state, a process or …

Why you should use Postgres over MySQL for analytics purpose

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 …

PHP MySQL Redis

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 …