|
|
 | | From: | =?windows-1252?Q?Hans-J=FCrgen_Sch=F6nig?= | | Subject: | Re: MySQL 5 comparison | | Date: | Mon, 10 Jan 2005 09:54:08 +0100 |
|
|
 | 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
|
|
|
