------=_NextPart_000_03FF_01C368A4.75720DC0
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable
Hi, it's my story.
I have two 4.0.14 mysql server on one machine with win XP Professional
polish version.
First acts as master: on port 3300
Second acts as slave: on port 3301
below my configuration:
####### FOR MASTER #################
# This will be passed to all mysql clients
[client]
#password=3Dmy_password
port=3D3300
#socket=3DMySQL
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
basedir =3D c:/mysql4/
datadir =3D c:/mysql4/data/
port=3D3300
language=3Dpolish
default-character-set=3Dlatin2
log-bin
server-id=3D1
log-warnings
set-variable =3D key_buffer=3D16K
set-variable =3D max_allowed_packet=3D1M
set-variable =3D thread_stack=3D64K
set-variable =3D table_cache=3D4
set-variable =3D sort_buffer=3D64K
set-variable =3D net_buffer_length=3D2K
query_cache_size =3D 1024K
# Uncomment the following if you are using Innobase tables
innodb_data_file_path =3D ibdata1:50M
innodb_data_home_dir =3D d:\\innodb\\mysql4\\master\\ibdata
innodb_log_group_home_dir =3D d:\\innodb\\mysql4\\master\\iblogs
innodb_log_arch_dir =3D d:\\innodb\\mysql4\\master\\iblogs
set-variable =3D innodb_mirrored_log_groups=3D1
set-variable =3D innodb_log_files_in_group=3D3
set-variable =3D innodb_log_file_size=3D5M
set-variable =3D innodb_log_buffer_size=3D8M
innodb_flush_log_at_trx_commit=3D1
innodb_log_archive=3D0
set-variable =3D innodb_buffer_pool_size=3D16M
set-variable =3D innodb_additional_mem_pool_size=3D2M
set-variable =3D innodb_file_io_threads=3D4
set-variable =3D innodb_lock_wait_timeout=3D50
[mysqldump]
quick
set-variable =3D max_allowed_packet=3D16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable =3D key_buffer=3D8M
set-variable =3D sort_buffer=3D8M
[myisamchk]
set-variable =3D key_buffer=3D8M
set-variable =3D sort_buffer=3D8M
[mysqlhotcopy]
interactive-timeout
###########################
### FOR SLAVE #########
# This will be passed to all mysql clients
[client]
#password=3Dmy_password
port=3D3301
#socket=3DMySQL
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
basedir =3D c:/mysql4_slave/
datadir =3D c:/mysql4_slave/data/
port=3D3301
language=3Dpolish
default-character-set=3Dlatin2
server-id=3D2
# log-bin
# log-slave-updates
master-host=3D127.0.0.1
master-user=3Direk
master-password=3DXXXXXXXXXX
master-port=3D3300
master-connect-retry=3D30
# log-update=3Dlog_updates.log
log-warnings
set-variable =3D key_buffer=3D16K
set-variable =3D max_allowed_packet=3D1M
set-variable =3D thread_stack=3D64K
set-variable =3D table_cache=3D4
set-variable =3D sort_buffer=3D64K
set-variable =3D net_buffer_length=3D2K
query_cache_size =3D 1024K
# Uncomment the following if you are using Innobase tables
innodb_data_file_path =3D ibdata1:50M
innodb_data_home_dir =3D d:\\innodb\\mysql4\\slave\\ibdata
innodb_log_group_home_dir =3D d:\\innodb\\mysql4\\slave\\iblogs
innodb_log_arch_dir =3D d:\\innodb\\mysql4\\slave\\iblogs
set-variable =3D innodb_mirrored_log_groups=3D1
set-variable =3D innodb_log_files_in_group=3D3
set-variable =3D innodb_log_file_size=3D5M
set-variable =3D innodb_log_buffer_size=3D8M
innodb_flush_log_at_trx_commit=3D1
innodb_log_archive=3D0
set-variable =3D innodb_buffer_pool_size=3D16M
set-variable =3D innodb_additional_mem_pool_size=3D2M
set-variable =3D innodb_file_io_threads=3D4
set-variable =3D innodb_lock_wait_timeout=3D50
[mysqldump]
quick
set-variable =3D max_allowed_packet=3D16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
set-variable =3D key_buffer=3D8M
set-variable =3D sort_buffer=3D8M
[myisamchk]
set-variable =3D key_buffer=3D8M
set-variable =3D sort_buffer=3D8M
## END configuration
So i have noticed this things.
I start replication with master and slave:
1)
Master is running ...
---------------------------------------------------
Slave is running ... and at console can i see:
030804 22:55:36 InnoDB: Started
030804 22:55:36 Slave I/O thread: connected to master
'i***@127.0.0.1:3300', r
eplication started in log 'FIRST' at position 4
030804 22:55:36 Slave SQL thread initialized, starting replication in =
log
'FIRS
T' at position 0, relay log '.\hq-relay-bin.001' position: 4
mysqld-max-nt: ready for connections.
Version: '4.0.14-max-nt' socket: '' port: 3301
---------------------------------------------------
That is ok.
3) checked master data dir:
hq-bin.001
hq-bin.index
4) checked slave data dir:
hq-relay-bin.001
hq-relay-bin.index
master.info
relay-log.info
5) I stopped slave - shutdown nicely.
6) I stopped and started master 3 times.
7) I checked master data dir and i can see:
hq-bin.001
hq-bin.002
hq-bin.003
hq-bin.004
hq-bin.index
8) I started master.
9) master data dir:
hq-bin.001
hq-bin.002
hq-bin.003
hq-bin.004
hq-bin.005
hq-bin.index
10) I started a slave:
030804 23:07:36 InnoDB: Started
030804 23:07:36 Slave I/O thread: connected to master
'i***@127.0.0.1:3300', r
eplication started in log 'hq-bin.001' at position 79
030804 23:07:36 Slave SQL thread initialized, starting replication in =
log
'hq-b
in.001' at position 79, relay log '.\hq-relay-bin.001' position: 116
mysqld-max-nt: ready for connections.
Version: '4.0.14-max-nt' socket: '' port: 3301
11) I stopped slave (master is still runing):
12) I started slave again:
030804 23:09:17 InnoDB: Started
030804 23:09:17 Slave I/O thread: connected to master
'i***@127.0.0.1:3300', r
eplication started in log 'hq-bin.005' at position 79
030804 23:09:17 Slave SQL thread initialized, starting replication in =
log
'hq-b
in.005' at position 79, relay log '.\hq-relay-bin.002' position: 489
030804 23:09:17 next log error: -1 offset: 19 log:
030804 23:09:17 Error reading relay log event: Error purging processed =
log
030804 23:09:17 Could not parse relay log event entry. The possible =
reasons
are
: the master's binary log is corrupted (you can check this by running
'mysqlbinl
og' on the binary log), the slave's relay log is corrupted (you can =
check
this b
y running 'mysqlbinlog' on the relay log), a network problem, or a bug =
in
the ma
ster's or slave's MySQL code. If you want to check the master's binary =
log
or sl
ave's relay log, you will be able to know their names by issuing 'SHOW =
SLAVE
STA
TUS' on this slave.
030804 23:09:17 Error running query, slave SQL thread aborted. Fix the
problem,
and restart the slave SQL thread with "SLAVE START". We stopped at log
'hq-bin.
005' position 79
mysqld-max-nt: ready for connections.
Version: '4.0.14-max-nt' socket: '' port: 3301
13) In slave data dir:
hq-relay-bin.003
hq-relay-bin.index
master.info
relay-log.info
THIS IS BUG ???
Now my slave is runnung, but does'nt do a replication.
14) stop slave and running it again.
030804 23:12:00 InnoDB: Started
030804 23:12:00 Failed to open the relay log
(relay_log_name=3D'.\hq-relay-bin.00
2', relay_log_pos=3D489
030804 23:12:00 Could not find first log during relay log =
initialization
030804 23:12:00 Failed to initialize the master info structure
mysqld-max-nt: ready for connections.
Version: '4.0.14-max-nt' socket: '' port: 3301
Right, in slave data dir isn't that file, it is deleted by mysql server =
wich
is running as slave, WHY ??
IS that BUG, what should i do ?
LOAD DATA FROM MASTER ?? or sync again slave tables with master tables =
??
Best regards, irek
------=_NextPart_000_03FF_01C368A4.75720DC0--