O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Example 1

If the server is started with --binlog-do-db=sales and you issue the following statements, the UPDATE statement is not logged:

mysql> USE prices;mysql> UPDATE sales.january SET amount=amount+1000;

The main reason for this just check the default database behavior is that it is difficult from the statement alone to know whether it should be replicated. It is also faster to check only the default database rather than all databases if there is no need.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required