Re: why vacuum

On 10/27/2005 4:22 AM, Mario Splivalo wrote:

> On Wed, 2005-10-26 at 12:09 -0400, Jan Wieck wrote:
>> > 
>> 
>> You must have missed the FAQ and other side notes about replication in 
>> the MySQL manual. Essentially MySQL replication is nothing but a query 
>> duplicating system, with the added sugar of taking care of now() and 
>> some other non-deterministic things, but not all of them.
>> 
>> Non-deterministic user defined procedures, functions and triggers will 
>> simply blow MySQL's sophisticated replication apart.
>> 
> 
> That is just not true. I haven't tried MySQL 4 and above, but in 3.5.x
> replication wos working as expected, and the load that replication posed
> was insignificant. The only TRUE problem was that replication was
> unidirectional. That SAME problem has Slony, and other 'replication
> systems' available for postgres.

Read again. "Non-deterministic user defined procedures ...". Please give
me *ONE* example of a user defined procedure in 3.5.x at all. You must
have missed the point that stored procedures are a new feature in 5.0.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #