binary bin problems on HPUX 11.0
Hi, we are using mysql 3.23.33 on HPUX11 and every time we reboot the machine, it overwrites the binary log and starts from 001 again. This is only happening on a couple of machines. It doesn't do this if i manually restart mysql, only when the machine is rebooted. On one of the machines, mysql receives signal 10, dies and restarts, this once again only occurs when the machine is rebooted. Any help is greatly appreciated, William - 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
Running multiple MySQL servers on one machine
Hi, I was wondering if anyone has any opinions on the advantages and disadvantages of running multiple servers on one machine. Each server would be used to access different databases. Note also that these databases will both be replicated and there shall be multiple machines. Possibly some machines would be replicate one database but not the other. would it be more desirable given these circumstances to run multiple servers on the master, to facilitate the synchronisation of the two databases? thanks in advance, William - 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
Backups, Replication and the binlog
Hi all! I have been attempting to set up a system that involves replication and have run into some minor problems. I am only replicating one database but not all of the tables in the database. So when changes are made to the replicated dataase, it is logged to the binary log even if it is from a table i do not want to replicate. This causes problems because if i take the binary log from one machine to another and try to use it to update that machine, won't it also update the tables i explicitly wanted to not replicate. Basically in my config file i have set binlog-do-db=replicated_db replicate-do-db=replicated_db and in the slaves replicate-ignore-table=replicated_db.table1 replicate-ignore-table=replicated_db.table2 replicate-ignore-table=replicated_db.table3 what i basically wanted to knwo is if there was an option like binlog-ignore-table so that when i take the binary log over to the replicated machine and pump it in to update it, it won't change the tables which have been defined as not to be replicated? Is there any way of doing this? Thanks in advance! William - 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
