How do you make mysqld write a DELETE to the binlog just by entering a SELECT statement ?
No triggers and no stored routines/functions are involved.

Banking on open source. Open source as a business model. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

Banking on open source
# CIOL.com reported on the benefits of Standard Chartered Bank’s open source-based core banking system.

Open source as a business model
The “open source has failed as a …

1. Apertus -- open source cinema camera. (via joshua on Delicious)
2. A Survey of Collaborative Filtering Techniques -- From basic techniques to the state-of-the-art, we attempt to present a comprehensive survey for CF techniques, which can be served as a roadmap for research and practice in this area. (via bos on Delicious)
3. Drizzle Replication using RabbitMQ as Transport -- we're watching the growing use of message queues in web software, and here's an interesting application. (via …

 

A buddy of mine, Doug Marks, recently opened my eyes to some sites that are putting out misleading product reviews fueled by Google Ad Words.  I wrote about this on my InfoWorld blog with a story entitled "FTC and Google need to crack down on scam review sites" which provides a counterpoint to the concerns on the US FTC's blogger disclosure rules that become effective …

Our contest to give away one of our blazingly fast Kickfire Analytic Appliances to a deserving organization is heading into the home stretch. We have already had almost 1,000 people voice their opinion and encourage everyone interested in data warehousing, business intelligence, MySQL, open source, or any other aspect of this contest to vote for their favorite semi-finalist before 5:00P PT Tuesday, December 1st.  We will announce the winner on Wednesday, December 5th.

To enter the contest, we asked organizations to submit their most compelling story of “data warehouse pain.” Our esteemed judges, Curt Monash, founder of Monash Research (www.monash.com) and publisher of DBMS2, Joy Mundy, principal at the Kimball Group (www.kimballgroup.com), Peter Zaitsev, founder and chief executive officer of Percona ( …

In my previous post, Capturing Erroneous Queries with MySQL Proxy, I showed how to capture erroneous queries, along with relevant information, that one could not effectively obtain from the MySQL general query log. However, in that post, I simply output the information to the terminal. Therefore, in this example, I want to show how to write this information to a proxy log file.

To change this to log to a log file does not require too many changes, and so this is a useful example on how to log any proxy-related information to a log file.

1. I perform a check for an existing log file (at least using the variable of name “log_file”), and then assign log_file to the location of where I want the log file to reside (at the beginning of the lua script).

   if (log_file == nil) then
     log_file = "C:/Program Files/MySQL/mysql-proxy-0.7.2/proxy.log"
   end

…

This is a little story of a little bug. This gremlin suddenly appeared in a CGI.PM web-based application I work with. To make a long story short, an email was coming out something like this . . . 

389939
Subject:Update to Report #389939 by B. bloggins Description:389939 #389939: TPDD Now Deploying to monitoring for the MySQL servers.

 . . . when it should have been some thing like this:

Subject: TPDD Update to Report #389939 by B. bloggins

TPDD Now Deploying to monitoring for the MySQL servers.

After about an hour tracking things back, my team and I narrowed it down to this line of code:

$self->send_TXT_email(CGI::param("rep_no"),$rep_object,
                     $subject,$user_ref);

We scratched our respective heads on this for a while, because for user type ‘A’, it worked fine; but for user type ‘B’, it did not. And …

Once again the holidays season is upon us and many of you will be looking for gifts. I would like to recommended the following.

For many years I felt the best overall MySQL book was The MySQL 5.0 Study Guide. It is still a very good book but it does not cover third party tools and is getting slightly dated. My new favorite MySQL book is MySQL Administrators Bible . It covers everything from installing and monitoring MySQL servers to tuning and scaling. This book is written in a clear, easy to read style and deserves to be on the bookshelf of any MySQL DBA. This will be one of those books that you will dog-ear pages and festoon with PostIt notes.
…

Our contest to give away one of our blazingly fast Kickfire Analytic Appliances to a deserving organization is heading into the home stretch. We have already had almost 1,000 people voice their opinion and encourage everyone interested in data warehousing, business intelligence, MySQL, open source, or any other aspect of this contest to vote for their favorite semi-finalist before 5:00P PT Tuesday, December 1st.  We will announce the winner on Wednesday, December 5th.

To enter the contest, we asked organizations to submit their most compelling story of “data warehouse pain.” Our esteemed judges, Curt Monash, founder of Monash Research (www.monash.com) and publisher of DBMS2, Joy Mundy, principal at the Kimball Group (www.kimballgroup.com), Peter Zaitsev, founder and chief executive officer of Percona ( …

It's often not desirable to expose your Drupal server directly to the end users. This document describes how to “hide” a Drupal server behind a reverse proxy server. This is typically done for a number of reasons:

• protection: the topology of the server, the database server can be hidden from the front end

• caching: The proxy server take away load from the backend system through caching

• flexibility: the topology behind the reverse proxy can be changed more easily

• scalability: the proxy server can be used for future load balancing

The technical problem isn't new. It has been solved before. I had however problems finding a solution in a single document.

The configuration is basically a platform neutral AMP stack …