Re: MySQL 5 comparison - Mailing list pgsql-advocacy

From Hans-Jürgen Schönig
Subject Re: MySQL 5 comparison
Date
Msg-id 41E242B0.5010708@cybertec.at
Whole thread Raw
In response to Re: MySQL 5 comparison  (David Fetter <david@fetter.org>)
List pgsql-advocacy
Chris Travers wrote:
> One explenation regarding the replication issue....
>
>>
>> lucent@schankserver:~/replication_tests/query$ cat 05.sql
>> BEGIN;
>> UPDATE t_one SET intvalue = id WHERE id = 'RANDOMINT';
>> UPDATE t_one SET intvalue = id WHERE id = 'RANDOMINT';
>> COMMIT;
>>
>> BEGIN;
>> DELETE FROM t_one WHERE id = 'RANDOMINT';
>> ROLLBACK;
>>
> Where is Randomint calculated?  If it is on the server, I would expect
> the replication to provide unpredictable results with MySQL as it
> replicates statements rather than tuples.  Personally, I think
> statement-based replication is a bit of a no-no because if you are doing
> complex non-deterministic queries, this will generate inconsistant results.


It is done by my benchmarking tool.
They do query based replication? Oh man, that really sucks ...

    Hans


--
Cybertec Geschwinde u Schoenig
Schoengrabern 134, A-2020 Hollabrunn, Austria
Tel: +43/660/816 40 77
www.cybertec.at, www.postgresql.at


pgsql-advocacy by date:

Previous
From: Josh Berkus
Date:
Subject: Re: OSCON Committee
Next
From: Francois Suter
Date:
Subject: First article in France about PostgreSQL v8