Re: MySQL Blackhole Engine

On Tue, Nov 6, 2012 at 3:07 PM, Deron <fecastle(at)gmail(dot)com> wrote:
> 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.
>
> I don't honestly know what this is used for. Of course I did know what
> /dev/null was used for until I started using it. So maybe this has some
> merit? Is there some sort of equivelent structure in PG?

You can create a row-level BEFORE INSERT trigger on a table that does
nothing but RETURN NULL. In this case all the inserts into this table
will be ignored.

>
> http://dev.mysql.com/doc/refman/5.0/en/blackhole-storage-engine.html
>
> Thanks,
>
> Deron

--
Sergey Konoplev

a database and software architect
http://www.linkedin.com/in/grayhemp

Jabber: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp Phone: +14158679984