There is no reasonable way to catch and diagnose errors on server side. It is nearly impossible to know exactly what went wrong. To illustrate, consider the following query: INSERT INTO my_table (my_column) VALUES (300); What could go wrong with this query? We might hit a UNIQUE KEY violation Or a FOREIGN KEY violation my_column […]
What is the difference between the following three syntaxes? SELECT * FROM film JOIN film_actor ON (film.film_id = film_actor.film_id) SELECT * FROM film JOIN film_actor USING (film_id) SELECT * FROM film, film_actor WHERE film.film_id = film_actor.film_id The difference is mostly syntactic sugar, but with a couple interesting notes. To put names, the first two are […]
MySQL's Row Based Replication (RBR) succeeds (though not replaces) Statement Based Replication (SBR), as of version 5.1. Anyone who is familiar with replication data drift -- the unexplained growing data difference between master & slave -- might wish to look into row based replication. On multiple servers I'm handling the change to RBR has eliminated […]