Re: MySQL Blackhole Engine

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Deron <fecastle(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: MySQL Blackhole Engine
Date: 2012-11-06 23:25:13
Message-ID: 22422.1352244313@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Deron <fecastle(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sergey Konoplev 2012-11-06 23:26:40 Re: MySQL Blackhole Engine
Previous Message Deron 2012-11-06 23:07:21 MySQL Blackhole Engine