10-09-2010
MySQL Master-Slave Configuration: Don't Replicate a Row of a Table?
Anyone have a clue about this?
I have checked the MySQL documentation and it does not seem possible to exclude a row of a table from replication between Master and Slave. It seems that replication in MySQL can only be managed at the table level, not at the row level.
Does anyone know a work around for this with MySQL?
I have a table on configuration information, including options, and some of the options in the the table cannot replicate, because the configuration options are unique to the Master and Slave.
Thanks!
8 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Our NIS master server went down. We have since fixed it and brought it back up. However all of are machines still point to the slave server when looking at it with ypwhich. My question is how do i point the servers back to the master.
Frank (2 Replies)
Discussion started by: frankkahle
2 Replies
2. SCO
hello , i setup a lan network , but i don't know how configure master and slave in the lan network please help me:confused: (2 Replies)
Discussion started by: hossein
2 Replies
3. AIX
Hello Everybody,
I have a question regarding SLAVE NIS SERVER in aix.
We are using NIS master of Sun Solaris 9.0 which is on different subnet i.e. 10.197.93.0. And Our slave server is having AIX 5.3 installed which is on 10.207.13.0 subnet.
I have a query regarding its name and ip address... (0 Replies)
Discussion started by: jit15975
0 Replies
4. Shell Programming and Scripting
i have a table
records
------------
id | user | time | event
91 admin | 12:00 | hi
92 admin | 11:00 | hi
93 admin | 12:00 | bye
94 admin | 13:00 | bye
95 root | 12:00 | hi
96 root | 12:30 | hi
97 root | 12:56 | hi
how could i only select and display only the user and event from... (6 Replies)
Discussion started by: kpddong
6 Replies
5. Programming
I am writing a process that has a master thread and a set of slave threads. Master thread is supposed to get jobs dynamically and assign to slave thread which is free. Master also get results back from slaves once a job is done. The number of slaves should be adjustable dynamically based on job... (1 Reply)
Discussion started by: tamil.pamaran
1 Replies
6. UNIX Desktop Questions & Answers
I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database.
For this I have created two... (0 Replies)
Discussion started by: Palak Sharma
0 Replies
7. Programming
Hi,
How to wait the slave to be finished first then execute the master?
Can someone give me the specific function? Or the detailed example.
Thanks~ (1 Reply)
Discussion started by: wanliushao
1 Replies
8. IP Networking
Hey everyone. I'm creating a DNS master/slave server set up.
I have the configurations all done I believe, the master has the required zone file, and the named.conf file has the allow transfer and allow query stuff set. The slave has it's own configs set.
My question is that when initially... (1 Reply)
Discussion started by: Lost in Cyberia
1 Replies
LEARN ABOUT LINUX
ndb_drop_table
NDB_DROP_TABLE(1) MySQL Database System NDB_DROP_TABLE(1)
NAME
ndb_drop_table - drop an NDB table
SYNOPSIS
ndb_drop_table options
DESCRIPTION
ndb_drop_table drops the specified NDB table. (If you try to use this on a table created with a storage engine other than NDB, the attempt
fails with the error 723: No such table exists.) This operation is extremely fast; in some cases, it can be an order of magnitude faster
than using a MySQL DROP TABLE statement on an NDB table.
Usage
ndb_drop_table -c connect_string tbl_name -d db_name
The following table includes options that are specific to ndb_drop_table. Additional descriptions follow the table. For options common to
most MySQL Cluster programs (including ndb_drop_table), see Options Common to MySQL Cluster Programs(1).
Table 17.19. ndb_drop_table Options and Variables: MySQL Cluster NDB 7.2
+--------------------------+-----------------------------------+-------------------------------------+
|Format | Description | Added / Removed |
+--------------------------+-----------------------------------+-------------------------------------+
| | Name of the database in which the | |
| --database=dbname, | table is found | All MySQL 5.5 based releases |
| | | |
| -d | | |
+--------------------------+-----------------------------------+-------------------------------------+
COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 NDB_DROP_TABLE(1)