Correction on the INSERT DELAYED
In slide
20 I have mentioned that the INSERT DELAYED statement can
increase performance on the slave. This is wrong, since the
DELAYED keyword is ignored by the SQL thread on the slave server.
The INSERT DELAYED statement can increase the overall performance
of an application since the control is returned to the client as
soon as the row is queued into the list of inserts to execute.
The INSERT DELAYED can be used with MyISAM, MEMORY and
ARCHIVE.
Q from Filip: Does master & slave have to be the same
db-version, and the same Operative system?
Not necessarily, you can have different versions and operating
systems
Q from Danilo: Is there a way to load a backup from the
master without locking tables or shutting down the master
database?
Using Innodb, you can use mysqldump to
produce a consistent backup without locking …
The slides are available in PDF format here.
Thanks to all of you who have participated to the webinar!
-ivan
Tomorrow at 10.00 CET we will present the second webinar of the
Online Solutions series.
We will talk about MySQL Replication and we will see some of the
advanced techniques. We will set up basic, circular and
multi-master replication on the fly, for those of you who are not
yet familiar with this technology.
There are also hints, tips and tricks for advanced users and
DBAs, with suggestions on hardware, storage engines and
performance considerations, plus real examples from some big
names - Yahoo, Flickr and Wikipedia to name few.
Thanks to everybody for the interest! This is the most successful
set of webinars ever presented in Europe so far...
...and there's much more to see!
Stay tuned and see you tomorrow!
-ivan
P.S. The registration to the online
webinar is …