On Monday 12 February 2001 16:57, Rodolfo Sikora wrote:
>mysql> select VERSION();
>+-------------+
>| VERSION() |
>+-------------+
>| 3.23.31-log |
>+-------------+
>1 row in set (0.00 sec)
>
>I swer I'm running 3.23.31 (with pgcc) but let's forget about
"Contratulation message", I think the error is something related to
master.info position.
What version is the master? The master will "congratulate" you if your
master.info uses an offset less than 4, in which case you are right on the
magic number of the binlog. The misspeling of the word, however, suggests
that your master is older than 3.23.31.
>
>Thanks for your answers to another questions.
>
>Well, give me some advices to get some stability.
>
>I'll prepare a LVS cluster to avoid problems with unexpected corruption, I
gave up to use mysql with pgcc (I'm afraid about it).
The corruption problem is most likely not with pgcc, but because MySQL code
itself has a bug. Upgrade to 3.23.33 - it is already out, and just watch for
trouble - if you are on x86 Linux, it will give you a nice backtrace + the
query that hits the bug.
>I'm planning use a Bi-Directional replication, 2 servers with
--log-slave-update and other required replication stuff, so I'll put them
replicating each other and if some table get corrupted I'll change the LVS
switch and my system will work fine until I fix the problem.
Be very careful with this - this only works if your updates are 100%
independent of each other, and you get the same data if they happen in
different order on two servers.
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
<___/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php