Tema: Re: MySQL Best Practices
Autorius: Nerijus
Data: 2012-05-30 14:07:32
On 2012-05-30 09:24, maiklas wrote:
> Skaitydamas šita tema radau įrankį:
>
> mylvmbackup is a tool for quickly creating backups of a MySQL server's
> data files. To perform a backup, mylvmbackup obtains a read lock on all
> tables and flushes all server caches to disk, creates a snapshot of the
> volume containing the MySQL data directory, and unlocks the tables
> again. The snapshot process takes only a small amount of time. When it
> is done, the server can continue normal operations, while the actual
> file backup proceeds.
>
> Panašu tai ko reikia.
>


	Taip bet chia tas pac kas stabdyti baze. O kas bus jei kokia lenta 
sedes tranzakcijoj puse valandos? Lauksim? O per ta laika prie jau 
uzlokintu lenteliu niekas negales prieiti. Nu nebent ta nakti daryt, kai 
nieks nedirba.

	N. M.