Re: MySQL Blackhole Engine - Mailing list pgsql-admin

From Tom Lane
Subject Re: MySQL Blackhole Engine
Date
Msg-id 22422.1352244313@sss.pgh.pa.us
Whole thread Raw
In response to MySQL Blackhole Engine  (Deron <fecastle@gmail.com>)
Responses Re: MySQL Blackhole Engine  (Simon Riggs <simon@2ndQuadrant.com>)
Re: MySQL Blackhole Engine  (Deron <fecastle@gmail.com>)
List pgsql-admin
Deron <fecastle@gmail.com> writes:
> We are looking at integrating a 3rd party application.  They currently use
> MySQL for their database solution.  We are asking them to see about porting
> to PostgreSQL.   One of the issues they are running into is that they use
> MySQL "BLACKHOLE" storage engine.

Really?  I've always assumed that was utterly useless except as a
template for writing new mysql storage engines.  What are they using it
for?

You could presumably approximate the behavior by attaching a BEFORE
INSERT trigger to a table that just always returns NULL.

            regards, tom lane


pgsql-admin by date:

Previous
From: Deron
Date:
Subject: MySQL Blackhole Engine
Next
From: Sergey Konoplev
Date:
Subject: Re: MySQL Blackhole Engine