Replication
I saw this in the manual comments on http://www.mysql.com/doc/R/e/Replication_Options.html: : Note that if you client does not do a USE dbname, binlog-do-db=dbname will not :binlog a query like: update in dbname.foobar set foo=1 You explicitly have to do a :USE before a query in order to have your query binlogged, it looks like. Replication on the slave side can do wildcard matches .. but the master cannot (a la binlog-wild-do-table=dbname.%). So make sure your clients do a use, if you plan to replicate those tables it updates. Is this still true in the latest version of MySQL? Is this behaviour by design? Cheers, Ollie -- Oliver CookSystems Administrator, ClaraNET [EMAIL PROTECTED] 020 7903 3065 - 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: Running a private copy of mysqld
On Sun, Apr 22, 2001 at 12:09:24PM -0400, Bernie Cosell wrote: how to get it there... I'd appreciate a 'howto' [or a ptr to the docs or whatever] for what I need to do to get the new datadirectory set up. THANKS! mysql_install_db.sh it's in the /path/to/your/mysql/source/scripts directory Ollie -- Oliver CookSystems Administrator, ClaraNET [EMAIL PROTECTED] 020 7903 3000 ext. 291 - 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] adding new slaves
From my reading of the manual it seems that for every time a new slave it to be added, the master will need to be locked while the snapshot is taken. Is this really necessary? Can another slave be somehow setup by taking the data from another slave instead, thereby avoiding downtime on the master database server? Thanks, Ollie - 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
Limiting Connections (per host)
Is there any way to limit connections to MySQL server on a per-host basis? There are the: max_connections and max_user_connections options for mysqld on the command-line, but I cannot see any way of limiting them on a per-host basis? Is there any way? Thanks, Ollie -- Oliver CookSystems Administrator, ClaraNET [EMAIL PROTECTED] 020 7903 3000 ext. 291 - 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