Posted by Baron Schwartz |
For the last couple of months, we’ve been quietly developing a MySQL protocol parser for Maatkit. It isn’t an implementation of the protocol: it’s an observer of the protocol. This lets us gather queries from servers that don’t have a slow query log enabled, at very high time resolution.
With this new functionality, it becomes possible for mk-query-digest to stand on the sidelines and watch queries fly by over TCP. It is only an observer on the sidelines: it is NOT a man in the middle like mysql-proxy, so it has basically zero impact on the running server (tcpdump is very efficient) and zero impact on the query latency. There are some unique challenges to watching an entire server’s traffic, but we’ve found ways to solve those. Some of them are harder than others, such as making sense of a conversation when you start listening in the middle. In general, it’s working very well. We can gather just about every bit of information about queries that mysql-proxy can, making this a viable way to monitor servers without the disadvantages of a proxy. In theory, we can gather ALL the same information, but in practice we are going for the 95% case.
[read more...]
Posted by
Baron Schwartz @ 9:10 pm ::
tools ::
Posted by Aleksandr Kuzminsky |
Dear community,
The release 0.8 of the opensource backup tool for InnoDB and XtraDB is available for download.
Key features:
tar4ibd is made to be sure that read of InnoDB page is consistent. Before we had some complains what in stream mode some pages are getting corrupted, and we suspect tar can do read of pages in time when they changed. So we patches libtar to make read consistent.
Export is added to support moving .ibd tablespaces between servers.
The list of other features in the release includes:
- Support of ARCHIVE tables
- Addded incremental option to innobackupex-1.5.1 script
- Rollback XA PREPAREd transaction automatically at –prepare
- To extend tablespace size, if needed after –prepare
- Data page corruption check is added to local backup mode
- innobackupex can pass –export option
- Bug #389360: innobackupex-1.5.1 accepts scp options
Fixed bugs:
- Bug #388062: Update to innobackupex to include incremental
- fix error handling of tar stream
The binary packages for RHEL4,5, Debian, FreeBSD as well as source code of the XtraBackup is available on http://www.percona.com/mysql/xtrabackup/0.8/.
The project lives on Launchpad : https://launchpad.net/percona-xtrabackup and you can report bug to Launchpad bug system:
https://launchpad.net/percona-xtrabackup/+filebug. The documentation is available on our Wiki.
For general questions use our Pecona-discussions group, and for development question Percona-dev group.
For support, commercial and sponsorship inquiries contact Percona.
Posted by
Aleksandr Kuzminsky @ 8:09 am ::
Backups ::
del.icio.us
digg