Re: Mixed engines within same database
Posted by:
Rick James
Date: September 07, 2010 10:38PM
Another use for slaves is readonly scaling. Suppose you have a dozen web servers -- they could need more than one slave to keep up.
Whether you use mysqldump, or stop mysqld and copy files, you must
* Prevent writes during the backup
* Read all the data off disk.
That is, either way, you are interrupting the Slave. And the amount of time is mostly a function of disk I/O, which is pretty much the same for either technique.
Subject
Views
Written By
Posted
6301
July 29, 2010 11:36PM
2138
July 31, 2010 09:13AM
2271
September 06, 2010 03:12PM
1956
September 06, 2010 09:56PM
1851
September 06, 2010 10:31PM
1793
September 06, 2010 11:51PM
1756
September 07, 2010 02:10AM
Re: Mixed engines within same database
1746
September 07, 2010 10:38PM
2399
September 08, 2010 03:35AM
1843
September 25, 2010 09:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.