473,714 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

problem in mysql replication

29 New Member
hai i have problem with mysql replication.
master -slave replication

and

two way replication


please can any one tell me step by step solution

thanks & regards

barrathi
Nov 29 '06 #1
5 3921
sashi
1,754 Recognized Expert Top Contributor
hai i have problem with mysql replication.
master -slave replication

and

two way replication


please can any one tell me step by step solution

thanks & regards

barrathi
Hi there,

Kindly refer to below attached link for further reading & understanding, hope it helps. Good luck & Take care.

MYSQL Replication Step by step guide
Nov 29 '06 #2
barrathi
29 New Member
Hi there,

Kindly refer to below attached link for further reading & understanding, hope it helps. Good luck & Take care.

MYSQL Replication Step by step guide
thank u sashi
Nov 30 '06 #3
barrathi
29 New Member
hai sashi i have one main problem.

problem is master - slave replication is working fine but it works 30 mins to 1 hr
then it is not working.
why because is MASTER_LOG_FILE ='mysql-bin.000001' this file is changing frequently

like 1hr
it shows MASTER_LOG_FILE ='mysql-bin.000001'

after that
MASTER_LOG_FILE ='mysql-bin.000002'

after some time it shows

MASTER_LOG_FILE ='mysql-bin.000099'

this is the main problem

how do fix the master_log_file ?

and if possible u can see following website


http://docs.hp.com/en/5991-7431/ar01s05.html


these are the one of the steps.

mysql> CHANGE MASTER TO
-> MASTER_HOST='ma ster_host_name' ,
-> MASTER_USER='re plication_user_ name',
-> MASTER_PASSWORD ='replication_p assword',
-> MASTER_LOG_FILE ='recorded_log_ file_name',
-> MASTER_LOG_POS= recorded_log_po sition;


For this example, enter the following commands:

mysql> CHANGE MASTER TO
-> MASTER_HOST='ma ster.test',
-> MASTER_USER='os musr',
-> MASTER_PASSWORD ='osmpass',
-> MASTER_LOG_FILE ='mysql-bin.000001',
-> MASTER_LOG_POS= 1678;

thanks
Nov 30 '06 #4
angst
1 New Member
Hello,

I've just setup my first mysql replication this week.
and this is what i've found.

replication works prefectly *IF*, you do not add/edit/delete any thing on the slave server.
you don't need to worrie about the bin-log changing, after the first time that you point it to the log that SHOW MASTER STATUS; displays. the salve can fallow along and keep up.

what I've found is that mysql does not currently support any really two-way replication. so the solution that i've found is that, you can read from both servers, and only insert/update/delete from the master. this will keep both server sync'd up correctly.

unless any one else has a better idea, this is the best i was able to find.

hope this helps,
cheers,
-Ken
Dec 8 '06 #5
barrathi
29 New Member
thanks for your replay angst





Hello,

I've just setup my first mysql replication this week.
and this is what i've found.

replication works prefectly *IF*, you do not add/edit/delete any thing on the slave server.
you don't need to worrie about the bin-log changing, after the first time that you point it to the log that SHOW MASTER STATUS; displays. the salve can fallow along and keep up.

what I've found is that mysql does not currently support any really two-way replication. so the solution that i've found is that, you can read from both servers, and only insert/update/delete from the master. this will keep both server sync'd up correctly.

unless any one else has a better idea, this is the best i was able to find.

hope this helps,
cheers,
-Ken
Dec 21 '06 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1462
by: unplug | last post by:
HI all, I want to ask whether I can do replication in the following case. innodb (master) --replication --> myisam (slave) Rgds, Ringo --
0
1255
by: Ganbold | last post by:
Hi, I'm using MySQL 4.0.13 for both master and slave servers. However I have problem starting slave server. Error log says: 030804 14:06:10 Slave I/O thread: connected to master 'repl@202.xxx.xxx.xxx:3306', replication started in log 'backend2-bin.228' at position 43583528 030804 14:11:48 Slave I/O thread exiting, read up to log 'backend2-bin.228', position 64018330
0
1317
by: ed | last post by:
I am having a problem with replication in MySQL 4.0.13. I have a my.cnf file in the data directory of the slave that should exclude a specific table in one of my databases from replication. I am getting the following error message: "error 'unexpected success or fatal error' on query 'UPDATE excludedDB.excludedTABLE.....' ". I am sure the syntax is correct in the my.cnf I am excluding several
0
1283
by: ed | last post by:
I should appologize for my earlier post "Another Replication Problem". I had not properly analyzed the problem before posting. Although I have been administering a MySQL database for about a year now, replication is completely new to me. Sorry if I wasted anyone's time. Thanks to Jeremy Zawodny for leading me in the right direction. I have concluded that my problem lies in a corrupt bin-log file following a system crash. We had a bad...
0
583
by: I.P. | last post by:
------=_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.
1
1734
by: Uli | last post by:
Hello group, i am relatively new to SQL-Server database, but i have lots of experience with DB2 and Oracle Database. One of my tasks is setting up a replication between a Mysql-Database running on Linux and one of our SQL-Servers. How do i achieve this ? If i understand the documentation correctly you have to program the
2
4925
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
13
2306
by: Jim Hubbard | last post by:
I have a client that desires a new application for use at several stores in different cities. He wants "real time" access to all store data and the ability to continue to run locally even if the internet connection goes down. It occurs to me that a local MySQL instance should definitely be in each store to continue work if the net is down for any reason. But, what is the best way to synchronize/share data among all of the stores? ...
3
6088
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'
0
12897
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
8817
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8715
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9322
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...
1
9086
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
9037
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6641
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4470
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
4734
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2531
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.