10-09-2010
Neo,
I assume these options are static so you could take a dump of the production db (use --master-data), then import the data in the slave, update the rows on the slave with the proper configuration and then start the replication. As far as those rows remain untouched on the master, the slave configuration will remain valid.
This User Gave Thanks to radoulov For This Post:
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 PHP
mysqlnd_ms_match_wild
MYSQLND_MS_MATCH_WILD(3) 1 MYSQLND_MS_MATCH_WILD(3)
mysqlnd_ms_match_wild - Finds whether a table name matches a wildcard pattern or not
SYNOPSIS
bool mysqlnd_ms_match_wild (string $table_name, string $wildcard)
DESCRIPTION
Finds whether a table name matches a wildcard pattern or not.
This function is not of much practical relevance with PECL mysqlnd_ms 1.1.0 because the plugin does not support MySQL replication table
filtering yet.
PARAMETERS
o $table_name
- The table name to check if it is matched by the wildcard.
o $wildcard
- The wildcard pattern to check against the table name. The wildcard pattern supports the same placeholders as MySQL replication
filters do. MySQL replication filters can be configured by using the MySQL Server configuration options --replicate-wild-do-table
and --replicate-wild-do-db. Please, consult the MySQL Reference Manual to learn more about this MySQL Server feature. The sup-
ported placeholders are:
o % - zero or more literals
o _ - one literal
Placeholders can be escaped using .
RETURN VALUES
Returns TRUE table_name is matched by wildcard. Otherwise, returns FALSE
EXAMPLES
Example #1
mysqlnd_ms_match_wild(3) example
<?php
var_dump(mysqlnd_ms_match_wild("schema_name.table_name", "schema%"));
var_dump(mysqlnd_ms_match_wild("abc", "_"));
var_dump(mysqlnd_ms_match_wild("table1", "table_"));
var_dump(mysqlnd_ms_match_wild("asia_customers", "%customers"));
var_dump(mysqlnd_ms_match_wild("funny%table","funny\%table"));
var_dump(mysqlnd_ms_match_wild("funnytable", "funny%table"));
?>
The above example will output:
bool(true)
bool(false)
bool(true)
bool(true)
bool(true)
bool(true)
PHP Documentation Group MYSQLND_MS_MATCH_WILD(3)