Alpha
Share and Organize Code
login register
HotNewTop
F.A.Q.
1. To begin adding code first register.
2. Create your own tags for code that you add.
3. To see your own code click Me, to see all code click Everyone, or filter by people rob.
4. To follow a user, click on their username, rob and hit follow.
5. Add other code to your library by clicking the
button near the code titles (note that you can not edit these codes).
6. To create a copy of a code that you can edit use fork.
7. If you can't find your code, double check your filter settings as you can filter by Category, User and Tag simultaneously.
8. Add comments to a code by clicking on it's title or the comments link underneath it.

Change BinLog Format on Live Master DB (plain)

1
2
3
4
5
6
FLUSH TABLES WITH READ LOCK;
FLUSH LOGS;
SET GLOBAL binlog_format = 'MIXED'; /*possible values: STATEMENT, ROW, MIXED*/
FLUSH LOGS;
UNLOCK TABLES;
RESET MASTER; /*This starts the Master over again with new bin log format*/
[+] (2) more...
comments (2) flag fork
WARNING: If you have MEMORY tables (Storage Engine = Memory) this will wipe them out!!! Nonetheless Memory tables wouldn't be replicating anyway... however if you do have memory tables and they are ignored in replication, ensure you back them up first. - prdgreene 5 Years ago
This assumes you have a Master Slave Replication set up. Also changing this value changes how your servers replicate! - prdgreene 5 Years ago