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
3086
August 29, 2005 01:45AM
1887
August 29, 2005 03:24AM
1887
August 29, 2005 12:42PM
1923
August 30, 2005 03:52AM
2078
August 30, 2005 05:32AM
1872
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.