| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Deron <fecastle(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: MySQL Blackhole Engine |
| Date: | 2012-11-06 23:51:17 |
| Message-ID: | CA+U5nMJKL89mV-UUnOuh39Ote=mmBn+dgCSbFzWu2MF0S4kCiw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 6 November 2012 23:25, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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?
I had also assumed that they were useless.
The docs say that the actions are binary logged, but the actual INSERT ignored.
Which is exactly what Hannu is asking for with LOG ONLY TABLEs.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Deron | 2012-11-06 23:56:14 | Re: MySQL Blackhole Engine |
| Previous Message | Sergey Konoplev | 2012-11-06 23:26:40 | Re: MySQL Blackhole Engine |