index not incrementating
Hi, can someone tell me how the index number on the bin logs are incremented? When i update my master machine the changes are still going to $machine-name-bin.001 on my slave its looking for Log_file $machine-name-bin.002 can someone tell me how these number are incremented? the .00# how often, what causes them to increment? also another question is: what happends when the slave machine is rebooted? when it (slave) comes back up does the slave update the database with all the inserts, deletes that happended in the time it took to boot up? I tried rebooting the slave and updating the master and when the slave came back up it was just in a state of waiting for new changes...it did not populate the missing data. Did i do something wrong? I am fairly new to replication and researching weather it is a feasible and safe transition to go to for our production machines. - 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
stability of replication?
I just wanted to know how stable is mysql databse replication is? What we have in mind is a tiered system. $master (california)-(internet ssh tunnel) \$slave (texas) 10 other slave machines on the same network (running 5 separate db per machine) \$slave (san fransisco) 10 other slave machines on the same network (running 5 separate db per machine) \$slave (new york) 10 other slave machines on the same network (running 5 separate db per machine) How fesible would this be? and has anyone worked with replication on a large scale? We're dealing with 2500 tables about 65k total records Read/Write to the master will be like 50 per second Any input or links to documentation is much appreciated. - 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: replication problem
If i put a server-id in the slave my.cnf file and start up the database with safe-mysqld, it starts and dies with this error in the log file. unrecognized option `--server-id=2' -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 7:25 AM To: Duc Chau Cc: [EMAIL PROTECTED] Subject: Re: replication problem The slave does not have a server-id. Duc Chau wrote: Hi, this is my first time posting to the list. I've followed mysql replications how-tos to a tee...and I am still not able to get it to work. the master mysql is running on a sun sparc station (SunOS 2.8) with mysql 3.23.41 the file /etc/my.cnf is as follows: # The following options will be passed to all MySQL clients [client] port= 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16K set-variable= max_allowed_packet=1M set-variable= thread_stack=64K set-variable= table_cache=4 set-variable= sort_buffer=64K set-variable= net_buffer_length=2K server-id = 1 log-bin [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [myisamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [mysqlhotcopy] interactive-timeout The slave is running on a compaq prescario running red hat linux 7.1 with MySQL (Ver 10.12 Distrib 3.23.25-beta, for pc-linux-gnu (i686)) the file /etc/my.cnf is as follows: # The following options will be passed to all MySQL clients [client] port= 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] master-host=$host goes here master-user=$user goes here master-password=$password goes here master-port=3306 port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16K set-variable= max_allowed_packet=1M set-variable= thread_stack=64K set-variable= table_cache=4 set-variable= sort_buffer=64K set-variable= net_buffer_length=2K log-bin [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [myisamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [mysqlhotcopy] interactive-timeout Can someone tell me what i'm doing wrong? After reading thru all these how to's it seems so easy to get. Would the problem be cuz i'm going from solaris to linux? If that was the case though wouldnt i get errors importing the snapshots? The snapshot of the master data directory imported just fine. Another problem I noticed is if i put server-id = $any number here in the slave my.cnf i get this error /usr/sbin/mysqld: unrecognized option `--server-id=1'. Any help or direction on where i can find an answer would be great i've read through about 5 how to's. this is in my error log on the slave machine: 010904 14:05:12 mysqld started /usr/sbin/mysqld: ready for connections 010904 14:05:12 Slave thread: error connecting to master:Can't connect to MySQL server on 'sc-admin.admonitor.net' (111), retry in 60 sec Number of processes running now: 0 010904 14:05:27 mysqld restarted /usr/sbin/mysqld: ready for connections 010904 14:05:27 Error reading packet from server: Could not find first log (0) 010904 14:06:27 Error reading packet from server: Could not find first log (0) [root@dev mysql]# more dev.l90.com.err 010904 14:05:12 mysqld started /usr/sbin/mysqld: ready for connections 010904 14:05:12 Slave thread: error connecting to master:Can't connect to MySQL server on 'sc-admin.admonitor.net' (111), retry in 60 sec Number of processes running now: 0 010904 14:05:27 mysqld restarted /usr/sbin/mysqld: ready for connections 010904 14:05:27 Error reading packet from server: Could not find first log (0) 010904 14:06:27 Error reading packet from server: Could not find first log (0) 010904 14:07:27 Error reading packet from server: Could not find first log (0) 010904 14:08:27 Error reading packet from server: Could not find first log (0) 010904 14:09:28 Error reading packet from server: Could not find first log (0) 010904 14:10:28 Error reading packet from server: Could not find first log (0) - 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 -- Gerald L. Clark [EMAIL PROTECTED
FW: mysql db replication security across the internet
Can anyone tell me or point me to documentation on how to securely do database replication over the internet? I need to replicate to machines in datacenters in diffrent states. How feasible is this? Has anyone done it? What are the security concerns with doing this via the net? Thanks - 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: mysql db replication security across the internet
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 3:50 PM To: Duc Chau Subject: Re: mysql db replication security across the internet Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Can anyone tell me or point me to documentation on how to securely do data replication over the internet? I need to replicate to machines in datacenters in diffrent states. How feasible is this? Has anyone done it? What are the security concerns with doing this via the net? Thanks - 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
replication problem
Hi, this is my first time posting to the list. I've followed mysql replications how-tos to a tee...and I am still not able to get it to work. the master mysql is running on a sun sparc station (SunOS 2.8) with mysql 3.23.41 the file /etc/my.cnf is as follows: # The following options will be passed to all MySQL clients [client] port= 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16K set-variable= max_allowed_packet=1M set-variable= thread_stack=64K set-variable= table_cache=4 set-variable= sort_buffer=64K set-variable= net_buffer_length=2K server-id = 1 log-bin [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [myisamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [mysqlhotcopy] interactive-timeout The slave is running on a compaq prescario running red hat linux 7.1 with MySQL (Ver 10.12 Distrib 3.23.25-beta, for pc-linux-gnu (i686)) the file /etc/my.cnf is as follows: # The following options will be passed to all MySQL clients [client] port= 3306 socket = /tmp/mysql.sock # The MySQL server [mysqld] master-host=$host goes here master-user=$user goes here master-password=$password goes here master-port=3306 port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16K set-variable= max_allowed_packet=1M set-variable= thread_stack=64K set-variable= table_cache=4 set-variable= sort_buffer=64K set-variable= net_buffer_length=2K log-bin [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [myisamchk] set-variable= key_buffer=8M set-variable= sort_buffer=8M [mysqlhotcopy] interactive-timeout Can someone tell me what i'm doing wrong? After reading thru all these how to's it seems so easy to get. Would the problem be cuz i'm going from solaris to linux? If that was the case though wouldnt i get errors importing the snapshots? The snapshot of the master data directory imported just fine. Another problem I noticed is if i put server-id = $any number here in the slave my.cnf i get this error /usr/sbin/mysqld: unrecognized option `--server-id=1'. Any help or direction on where i can find an answer would be great i've read through about 5 how to's. this is in my error log on the slave machine: 010904 14:05:12 mysqld started /usr/sbin/mysqld: ready for connections 010904 14:05:12 Slave thread: error connecting to master:Can't connect to MySQL server on 'sc-admin.admonitor.net' (111), retry in 60 sec Number of processes running now: 0 010904 14:05:27 mysqld restarted /usr/sbin/mysqld: ready for connections 010904 14:05:27 Error reading packet from server: Could not find first log (0) 010904 14:06:27 Error reading packet from server: Could not find first log (0) [root@dev mysql]# more dev.l90.com.err 010904 14:05:12 mysqld started /usr/sbin/mysqld: ready for connections 010904 14:05:12 Slave thread: error connecting to master:Can't connect to MySQL server on 'sc-admin.admonitor.net' (111), retry in 60 sec Number of processes running now: 0 010904 14:05:27 mysqld restarted /usr/sbin/mysqld: ready for connections 010904 14:05:27 Error reading packet from server: Could not find first log (0) 010904 14:06:27 Error reading packet from server: Could not find first log (0) 010904 14:07:27 Error reading packet from server: Could not find first log (0) 010904 14:08:27 Error reading packet from server: Could not find first log (0) 010904 14:09:28 Error reading packet from server: Could not find first log (0) 010904 14:10:28 Error reading packet from server: Could not find first log (0) - 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