Re: MySQL 5 comparison

Chris Travers wrote:
> One explenation regarding the replication issue....
>
>>
>> lucent(at)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