(Robert Hodges) Time-delayed replication is a useful feature that allows a slave to lag a fixed amount of time behind a master, thus providing a time window to recover from disasters like deleting a 10 million line table by accident. You just run over to the slave, turn off replication, and recover
Tag: Open Source
Triggers Use Case Compilation, Part I
(Shlomi Noach) Ive run by quite a few triggers lately on production systems. In previous posts, Ive written about problems solved with triggers. So heres a compilation of some solutions based on triggers; and some problems which are not (yet?) solvable due to current triggers limitations.
Interesting things about TIMESTAMP data type in MySQL
(Haidong Ji) TIMESTAMP is interesting in that it can give you an easy way of keeping track of when was the last time a row was modified, with a few caveats, listed below. The tests were run on 5.1.30-community MySQL Community Server (GPL).
Libmemcached is faster …except with increment and decrement (?)
(Patrick Galbraith) I’m busy working on my book, “Developing Web Applications with Apache, MySQL, Memcached, and Perl”, writing about how Libmemcached (particularly the perl interface to libmemcached, Cache::Memcached::libmemcached/Memcached::libmemcached) is faster.
Using triggers to block malicious code: an example
(Shlomi Noach) Web applications face constant exploitation attempts. Those with a user base must keep their users private data, well private.
MySQL Storage Engine based on PHP
(Johannes Schlter) Sometimes one has weird ideas, or am I the only one? – This specific one is at least a year old, now, during the Christmas days, waiting for New Year’s Eve I had the time and mood to finally try it out: MySQL 5.1 has a plugin interface to easily add storage engines. PHP can easily
Mind the SQL_MODE when running ALTER TABLE
(Augusto Bott) The other day, a client mentioned they were getting strange results when running ALTER TABLE. The episode involved modifying an existing primary key to add an auto_increment primary key: it was shifting values. Say what?!
High-Performance Click Analysis with MySQL
(Baron Schwartz) We have a lot of customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and many similar types of work. The first thing these have in common is that they’re generally some kind of loggable event.
Using triggers for performance
(Anders Karlsson) Can you use TRIGGERs to increase performance? Really? Isn’t so that a TRIGGER on a table will reduce performance, just as any FOREIGN KEYs will? Right?
Goal driven performance optimization
(Peter Zaitsev) When your goal is to optimize application performance it is very important to understand what goal do you really have. If you do not have a good understanding of the goal your performance optimization effort may well still bring its results but you may waste a lot of time before you
