| From: | Guy Rouillier <guyr-ml1(at)burntmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: multimaster |
| Date: | 2007-06-01 22:24:09 |
| Message-ID: | 46609C89.2080804@burntmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alexander Staubo wrote:
> As it stands today, horizontally partitioning a database into multiple
> separate "shards" is incredibly invasive on the application
> architecture, and typically relies on brittle and non-obvious hacks
> such as configuring sequence generators with staggered starting
> numbers, omitting referential integrity constraints, sacrificing
> transactional semantics, and moving query aggregation into the app
> level. On top of this, dumb caches such as Memcached are typically
> layered to avoid hitting the database in the first place.
Have you looked at raidb? http://c-jdbc.objectweb.org. Narrow niche,
but if it happens to be the one you are in, then it's an option. I took
a quick look at the user's page, and both of them were using PostgreSQL.
--
Guy Rouillier
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-06-01 22:25:13 | Re: query log corrupted-looking entries |
| Previous Message | Alexander Staubo | 2007-06-01 22:23:44 | Re: Slightly OT. |