replication with automatic master failover problems

2005-03-03 Thread Olivier Kaloudoff
ting, read up to log 'master.09', position 8198468 050301 23:08:39 [ERROR] Error reading relay log event: slave SQL thread was killed Do you know if we forgot an important option, or maybe something is wrong in our setup ? Regards, Olivier Kaloudoff CKR Solutions Open Sourc

Re: Shell execution of mysql query

2005-02-23 Thread Olivier Kaloudoff
ly the same query as listed below. the following egrep (or grep -e) should do the trick: mysql -D $dbName --vertical -u $DBUSER -p$DBPASS < $queryFile > $opFile egrep -qv "Empty set (0.00 sec)" $opFile rc=$? Olivier Kaloudoff CKR Solutions Open Source Mandelieu, France http:/

Qcache and "read data from master"

2005-02-09 Thread Olivier Kaloudoff
Hi, I noticed the following behaviour on mysql 4.1.8 and two servers; to setup replication, I did the required grant on the master, and choose to use "LOAD DATA FROM MASTER" on the slave. As we monitor the Qcache usage on the master, it happend that Qcache was reset to 0 Queries

Re: Permission Denied for INSTALL-BINARY

2005-02-09 Thread Olivier Kaloudoff
On Wed, 9 Feb 2005, Mark Sargent wrote: Hi All, using Fedora2 and trying to install from a .tar file. Extracted to this dir, mysql-standard-4.1.9-pc-linux-gnu-i686 where I see the INSTALL-BINARY file. Using this cmd, ./INSTALL-BINARY gives the following error, [EMAIL PROTECTED] mysql-standard-4.

Re: ERROR 1189 (08S01): Net error reading from master

2005-02-08 Thread Olivier Kaloudoff
hat db0 receives the command, as the Query Cache is completely wiped out to 0 Queries when "load data from master is issued" So there does not seem like a network problem to me :) another idea ? Olivier Kaloudoff ha scritto: Hi, As no one answered to the question below, I'm w

Re: ERROR 1189 (08S01): Net error reading from master

2005-02-08 Thread Olivier Kaloudoff
eplication at all.. Olivier On Tue, 8 Feb 2005, Olivier Kaloudoff wrote: Hi, I have some problems here with two mysql servers, version 4.1.8; on the master server, binary logs are activated, free disk space is not null; [EMAIL PROTECTED]:~# ls -l /repl/mysql/data/master.* -rw-rw 1 m

ERROR 1189 (08S01): Net error reading from master

2005-02-08 Thread Olivier Kaloudoff
3 sec) the only thing I can get is: mysql> load data from master; ERROR 1189 (08S01): Net error reading from master Any ideas ? is this a bug in 4.1.8 ? Regards, Olivier Kaloudoff CKR Solutions Open Source Mandelieu, France http://www.ckr-solutions.com -- MySQL General Mailing List

Re: server performance

2005-01-25 Thread Olivier Kaloudoff
Hello, I use a mysql server on red hat 9 linux box with PIII 733 Mhz cpu and 256 MB memory. On this machine we use an adserver with a mysql backend. All click and view logs are kept in mysql tables. The number of the advertisements are increasing and so do the server's overhead. Some times I can n

Re: Reg Backup

2004-10-04 Thread Olivier Kaloudoff
archives first before asking. Regards, Olivier Kaloudoff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]