Postgres Pro
Downloads
Home   >   mailing lists

Re: MySQL Blackhole Engine - Mailing list pgsql-admin

From Deron
Subject Re: MySQL Blackhole Engine
Date
Msg-id CAF3Lvs6UEVfOhW9-OwUXjudmqJwVLTw84T4f+C-tF2T80p_a-Q@mail.gmail.com
Whole thread Raw
In response to Re: MySQL Blackhole Engine  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: MySQL Blackhole Engine
List pgsql-admin
Tree view
Yes,  I can't really find a good use case for it.   I am meeting with some of them in the next few days to find out exactly what they are using it for.  If there is a legitimate use case for this, I will forward that information.

Thanks for the suggestions.  I will pass this information along as well if they really need the behavior.

Deron



On Tue, Nov 6, 2012 at 3:25 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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: Simon Riggs
Date:
Subject: Re: MySQL Blackhole Engine
Next
From: Scott Ribe
Date:
Subject: Re: MySQL Blackhole Engine