question about replication under version 3.23.38 for Unix (database)
HI, everyone, I met a problem about setting up replication(master/slave) of mysql sever on unix boxes. Mysql servers are installed under /usr/local/ on master and slave and they can be run under /usr/local/mysql/bin. It seems to me that I have three choices where to put my configuration files, my.cnf, after I modify them for master and slave respectively . 1) /etc/my.cnf (global options) 2) DATADIR/my.cnf (Sever-specific option) 2) ~/.my.cnf (User-specific option) I have already tried all the three options, but only the first one worked. For sever-specific option, DATADIR that I choose to use is /data/mysql on my unix. And for User-specific option, I have tried my home directory /home/joseph. For either of these two cases, it is obvious that mysql server didnot read the modified configuration under these two directories, because I tried show master status and show slave status and find nothing happened. Anyone can answer why and how to work it out under last two cases? thank you, Joseph
question about a select application (sql, database)
Hi, everyone, I wrote a program to keep inserting rows to the databases. But I want to check the LAST row I inserted. Is there any good way to do it?? thanks, Joe
MySQL -- tee command ???
Hi, everyone, I have a question about the tee command in MySQL. I know one of its applications is to log everything from the screen to the outfile for debugging purpose. But how do I redirect output ONLY to outfile instead of both standard output (screen) and outfile. Because I donot want to see millions of lines scolled down on the screen when I access to a huge database, but I still want to debug through looking at the content of the db. I wish I make myself clearly. Please reply to me directly, because I am not on the mailing list yet. thanks, Joe Chow
2-way replication in MySQL (sql)
Hi, everyone, This is my another question. I have one master server and one slave server now. In case that the master is down for any reason, I want the slave still accessible by clients. Is that possible in my SQL? by two way replications? This problem seems quiet complicated to me. Please give me some detail ideas or point out the resources helpful. thanks a lot, Joe Chow - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
need help on replication
Hi, there, This is my first try on this mailing list. I am a new user of mysql and need some help about replication on mysql 3.23.36. I had followed the manual to set up master/slave server. At the beginning, they are connected perfectly. All the modifications (i.e. create databases, insert values ..) on the master server were mirrored by the slave server. However, after I dumped some databases from the master to the slave, the bad things happened. The connection between the master and the slave was down. I failed to reconnect them by shutting down and restarting the master and the slave a couple of times. So, here are my questions: 1 Does myadmindump .. command have anything to do the disconnection? 2 How could I reconnect them now? If you could take a minute to help me out, I'd much appreciated. thanks, Joe Chow - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: need help on replication
Hi, Jeremy, It is very nice to talk to you. Thanks for your information. It's working now, but I did nothing but going over the procedure again. I may make some mistakes during my operations. But it is really a good idea to keep an eye on the err log for solutions. By the way, I once first tried to set up the slave on a NT machine. But for unknown (means I donot know) reasons, I can not even net start mysql on that machine now. The error message is system error 5. Did you meet this problem? If so, how did you solve it? thanks alot, Joe -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 10:33 AM To: Joseph Chow Cc: [EMAIL PROTECTED] Subject: Re: need help on replication On Wed, May 09, 2001 at 10:29:42AM -0600, Joseph Chow wrote: Hi, there, This is my first try on this mailing list. I am a new user of mysql and need some help about replication on mysql 3.23.36. I had followed the manual to set up master/slave server. At the beginning, they are connected perfectly. All the modifications (i.e. create databases, insert values ..) on the master server were mirrored by the slave server. However, after I dumped some databases from the master to the slave, the bad things happened. The connection between the master and the slave was down. I failed to reconnect them by shutting down and restarting the master and the slave a couple of times. You'll need to look in the mysql error log on the slave and see what it says. That should give us/you a good idea what may have happened. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 126 days, processed 780,401,285 queries (71/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php