473,469 Members | 1,488 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Replication and InnoDB

Hi List,

I'd like to setup the following:

Server A <-- Server B <-- Server C
Data A some of Data A some of Data A
Data B Data B

Server A should be the master for server B. Server B should get not
all but some of the data of server A. Additionally there should be
other data stored on server B. Server B is slave for server A and
master for server C. Server C simply should get all the data of server
B.

No problem with MyISAM, but with InnoDB some questions arise:

The manual says, that one should shut down the master and copy the
InnoDB datafiles, logs and .frm files.
1.) If I only need some data of server A on server B wouldn't it be
overkill to copy all the InnoDB data?
2.) If I want to store other data on server B I can't mix up the
InnoDB datafiles and logs for data A and B, can I?

For an answer I thank you in advance.

Regards
Kurt Tragant
Jul 19 '05 #1
0 1179

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

Similar topics

0
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
by: Nick Gaugler | last post by:
I know the replication method is different in MySQL 4.0 then MySQL 3.23.x, but I have a bug that causes problems. The following query will cause MySQL's logic to not properly read any of the...
0
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...
0
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 +...
0
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...
0
by: Ilja Booij | last post by:
Hi all, I have set up master/slave replication between 2 servers (1 master, 1 slave). However, when I change a table on the master (e.g. by inserting a row), the same table on the slave is not...
3
by: muldoon | last post by:
I'm having quite a fuss with my two MySQL DB servers lately. I'm trying to establish replication between a MySQL 4.0.20 server (master) and a MySQL 4.1.11 server (slave). From what I read,...
0
by: webhosting | last post by:
After a failure, we promoted a slave to master. This included renaming the server to the old master's name and ip address, but leaving the server id alone. The new master works fine. We...
15
by: Pailloncy Jean-Gérard | last post by:
Hi, I just see that Mysql will propose at the end of the month a full synchronous replication system with auto-recovery. http://www.mysql.com/products/cluster/ We need to see when stable...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
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...
1
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...
0
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...
0
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...
0
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...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

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.