Whichever tool you use it is important to understand the fundamentals of how network performance metrics(like latency, packet loss or throughput) can be calculated.This calculation can be manual with Wireshark or any other packet analyzer or automated with the NPM solution… Read more ›
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… Read more ›
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… Read more ›
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… Read more ›
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 –… Read more ›
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… Read more ›
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%.… Read more ›
MySQL cache in PHP
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
$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 = exec_db_query($sql); // Put data into cache for 1 hour $r->set($key, serialize($data) ); $r->expires($key, 3600); } display_data($data); |
Redis connection note The example uses generic connection to the Redis server. To make the example work with our service you will need to use code similar to this one:
|
1 2 3 4 5 6 7 8 9 10 |
// change these parameter according to the information in your instance list $host = '50.30.35.9'; $port = 1234; $password = 'somehashcode'; $db = 0; $r = new Redis(); $r->connect($host, $port); $r->auth($password); $r->select($db); |
Link : http://redis4you.com/code.php?id=001
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… Read more ›
Info penting, bisa saja terjadi dimanapun! Serangga jenis Tomcat tiba-tiba menyerbu Surabaya, tepatnya di Apartemen East Coast, Pakuwon City Jalan Kejawan Putih. Serangga yang juga dikenal dengan sebutan kumbang Rove ini datang dengan jumlah yang diperkirakan mencapai jutaan. Muncul pertama… Read more ›