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_select_count
NDB_SELECT_COUNT() NDB_SELECT_COUNT()
NAME
ndb_select_count - print row counts for NDB tables
SYNOPSIS
ndb_select_count [-c connect_string] -d db_name tbl_name[ tbl_name2[ ...]]
DESCRIPTION
ndb_select_count prints the number of rows in one or more NDB tables. With a single table, the result is equivalent to that obtained by
using the MySQL statement SELECT COUNT(*) FROM tbl_name.
Usage
ndb_select_count [-c connect_string] -ddb_name tbl_name[, tbl_name2[, ...]]
The following table includes options that are specific to the MySQL Cluster native backup restoration program ndb_select_count. Additional
descriptions follow the table. For options common to most MySQL Cluster programs (including ndb_select_count), see Options Common to MySQL
Cluster Programs(1).
Table 17.25. ndb_select_count 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 | | |
+--------------------------+-----------------------------------+-------------------------------------+
| | Degree of parallelism | |
| --parallelism=#, | | All MySQL 5.5 based releases |
| | | |
| -p | | |
+--------------------------+-----------------------------------+-------------------------------------+
| | Lock type | |
| --lock=#, | | All MySQL 5.5 based releases |
| | | |
| -l | | |
+--------------------------+-----------------------------------+-------------------------------------+
You can obtain row counts from multiple tables in the same database by listing the table names separated by spaces when invoking this
command, as shown under Sample Output.
Sample Output
shell> ./ndb_select_count -c localhost -d ctest1 fish dogs
6 records in table fish
4 records in table dogs
NDBT_ProgramExit: 0 - OK
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/).
NDB_SELECT_COUNT()