MySQL Forums
Forum List  »  Replication

Replication pointers
Posted by: Theo Viset
Date: August 29, 2005 01:45AM

Hiall,

I want to execute an sql script that creates my database, my user, the replication user, execute all grant statements for connections and all replication statements for a daisy chained database (A -> B -> A) and fill the new database with initial data.

I ran into a problem with the master/slave file pointers, which I had to set manually quite often. Is there a way to create this database and be sure that the pointers are always the same? Now I had to check the 'SHOW MASTER STATUS' and set the pointer accordingly with the "CHANGE MASTER TO..." statement.

Now I created a database, locked the tables when I set the pointers, and tarred this file as my initial database. However, then I always need to have this tar as a database and change the database when I need to update initial data, while I want to be able to create a script to build the database in stead.

Any suggestions?

Greetz Theo

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication pointers
3170
August 29, 2005 01:45AM
1929
August 29, 2005 03:24AM
1932
August 29, 2005 12:42PM
1969
August 30, 2005 03:52AM
2118
August 30, 2005 05:32AM
1912
August 31, 2005 11:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.