473,895 Members | 2,377 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

mysql 4.0.14 + replication + windows XP PROF

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=my_pa ssword
port=3300
#socket=MySQL

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# The MySQL server
[mysqld]
basedir = c:/mysql4/
datadir = c:/mysql4/data/
port=3300
language=polish
default-character-set=latin2
log-bin
server-id=1
log-warnings

set-variable = key_buffer=16K
set-variable = max_allowed_pac ket=1M
set-variable = thread_stack=64 K
set-variable = table_cache=4
set-variable = sort_buffer=64K
set-variable = net_buffer_leng th=2K
query_cache_siz e = 1024K
# Uncomment the following if you are using Innobase tables
innodb_data_fil e_path = ibdata1:50M
innodb_data_hom e_dir = d:\\innodb\\mys ql4\\master\\ib data
innodb_log_grou p_home_dir = d:\\innodb\\mys ql4\\master\\ib logs
innodb_log_arch _dir = d:\\innodb\\mys ql4\\master\\ib logs

set-variable = innodb_mirrored _log_groups=1
set-variable = innodb_log_file s_in_group=3
set-variable = innodb_log_file _size=5M
set-variable = innodb_log_buff er_size=8M
innodb_flush_lo g_at_trx_commit =1
innodb_log_arch ive=0
set-variable = innodb_buffer_p ool_size=16M
set-variable = innodb_addition al_mem_pool_siz e=2M
set-variable = innodb_file_io_ threads=4
set-variable = innodb_lock_wai t_timeout=50
[mysqldump]
quick
set-variable = max_allowed_pac ket=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M

[myisamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M

[mysqlhotcopy]
interactive-timeout
############### ############
### FOR SLAVE #########
# This will be passed to all mysql clients
[client]
#password=my_pa ssword
port=3301
#socket=MySQL

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# The MySQL server
[mysqld]
basedir = c:/mysql4_slave/
datadir = c:/mysql4_slave/data/
port=3301
language=polish
default-character-set=latin2
server-id=2
# log-bin
# log-slave-updates
master-host=127.0.0.1
master-user=irek
master-password=XXXXXX XXXX
master-port=3300
master-connect-retry=30
# log-update=log_upda tes.log
log-warnings

set-variable = key_buffer=16K
set-variable = max_allowed_pac ket=1M
set-variable = thread_stack=64 K
set-variable = table_cache=4
set-variable = sort_buffer=64K
set-variable = net_buffer_leng th=2K
query_cache_siz e = 1024K
# Uncomment the following if you are using Innobase tables

innodb_data_fil e_path = ibdata1:50M
innodb_data_hom e_dir = d:\\innodb\\mys ql4\\slave\\ibd ata
innodb_log_grou p_home_dir = d:\\innodb\\mys ql4\\slave\\ibl ogs
innodb_log_arch _dir = d:\\innodb\\mys ql4\\slave\\ibl ogs

set-variable = innodb_mirrored _log_groups=1
set-variable = innodb_log_file s_in_group=3
set-variable = innodb_log_file _size=5M
set-variable = innodb_log_buff er_size=8M
innodb_flush_lo g_at_trx_commit =1
innodb_log_arch ive=0
set-variable = innodb_buffer_p ool_size=16M
set-variable = innodb_addition al_mem_pool_siz e=2M
set-variable = innodb_file_io_ threads=4
set-variable = innodb_lock_wai t_timeout=50
[mysqldump]
quick
set-variable = max_allowed_pac ket=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M

[myisamchk]
set-variable = key_buffer=8M
set-variable = sort_buffer=8M

## 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 ='.\hq-relay-bin.00
2', relay_log_pos=4 89
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
0 3273

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
3546
by: Lenz Grimmer | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, MySQL 4.0.14, a new version of the popular Open Source/Free Software Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites.
0
1316
by: I.P. | last post by:
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:
0
2159
by: I.P. | last post by:
No one has replied to my post. ----- Original Message ----- From: "I.P." <jancio_wodnik@wp.pl> To: <mysql@lists.mysql.com> Sent: Monday, August 18, 2003 1:01 PM Subject: mysql 4.0.14 + replication + windows XP PROF Hi, it's my story.
39
8442
by: Mairhtin O'Feannag | last post by:
Hello, I have a client (customer) who asked the question : "Why would I buy and use UDB, when MySql is free?" I had to say I was stunned. I have no experience with MySql, so I was left sort of stammering and sputtering, and managed to pull out something I heard a couple of years back - that there was no real transaction safety in MySql. In flight transactions could be lost.
2
4940
by: Beda Christoph Hammerschmidt | last post by:
MySQL, Access, ODBC, Replication Hello, i have a central mysql database that is accesed by multiple clients running MS Access with ODBC. This works fine if Access has a permanent connection to mysql. But now, i want MS Access to operate offline (e.g. on notebook in the
3
6099
by: Juan Antonio Villa | last post by:
Hello, I'm having a problem replicating a simple database using the binary log replication, here is the problem: When the master sends an update to the slave, an example update reads as follows: UPDATE MainInfo SET dAddress='38 Holland Blvd', dCity='miami', dState='FL', dZip='33000', dCountry='USA', dPhone='999987565', dNum='AC15857', dName='Michael A Scott' WHERE did=22'
2
5485
by: daniel | last post by:
I have the following scenario. A mysql database running 3 databases. It is version 5.0.27 on Windows XP Prof.. All innodb databases. The one database is particularly large (7.8GB of data)...pretty much held in 1 table....there are probabably 30 tables in the rest of the databases....combined they probably take up 200MB. The machine is pretty well spec'ed AMD X2 4600+, 2GB RAM, SATA RAID1. Normally the services that use the databases are...
0
12909
Coldfire
by: Coldfire | last post by:
Since i cannot show the differences in a two-column like table. I am first putting MS SQL Server 2005 and then MySQL 5.x. MS SQL Server 2005 Brief Overview - SQL Server is a full-fledged database system developed specifically for large enterprise databases. All advanced features of a relational database are fully implemented. - Once you purchase the product, you are only limited to the Sybase-derived engine.
0
3137
by: TechnoAtif | last post by:
<?php include "dbconnect.php"; include "commonFunc.php"; ?> <!----------------------------------> <table width="80%" border="1" cellpadding="2" cellspacing="0"> <tr > <td colspan="2"><p>
0
11249
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10845
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10935
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9649
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7177
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5863
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6068
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4689
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3294
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.