…, given the import/export functionality of Xtrabackup combined with Percona Server (Exporting and Importing Tables), it did seem possible. Further discussion… needing to import from a remote server. This can allow for more targeted restores, easier comparison, and allow remote users to compare on a live system without needed to grant access to another “backup” server. As noted…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…-io devices. This feature implementation is considered BETA quality. Percona Server has introduced innodb_read_views_memory and innodb_descriptors_memory…-5615 vulnerability. This vulnerability would allow remote attacker to detect what user accounts exist on the server. This bug fix comes originally…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… = array( ‘caching’ => true, ‘lifetime’ => 3600, ‘automatic_serialization’ => true ); $memcacheOpts = array( ‘servers‘ =>array( array( ‘host’ => ’192.168.57.51′, ‘port’ => 11211, ‘weight… client libraries. The only change between runs is on the remote server (stop/start memcached, stop/start plugin). As expected, there is…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… implemented full support for new MySQL 5.6 features (GTID, remote/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool… is restored buffer pool dump can be loaded by the server either automatically on startup or on demand. Time interval between… imported by ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… from Percona XtraBackup. After being deprecated in previous version, option –remote-host has been completely removed in Percona XtraBackup 2.1… position. This could trigger a bug if the server being backed up was standalone server (neither master nor slave in replication) and… #1175860. xtrabackup –stats option would not work with server datadir if the server isn’t running and logs were in a separate…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… implemented full support for new MySQL 5.6 features (GTID, remote/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool… is restored buffer pool dump can be loaded by the server either automatically on startup or on demand. Time interval between… imported by ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide…
Post: Percona XtraBackup 2.1.0 for MySQL beta now available
April 22, 2013 By Leave a Comment
… XtraBackup has implemented basic support for MySQL 5.6, Percona Server 5.6 and MariaDB 10.0. Basic support means that… no 5.6-specific features are used (such as GTID, remote/transportable tablespaces, separate undo tablespace, 5.6-style buffer pool… position. This could trigger a bug if the server being backed up was standalone server (neither master nor slave in replication) and…
Post: Percona XtraBackup 2.1.0 for MySQL alpha now available
April 2, 2013 By Leave a Comment
… backups. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support… XtraBackup for MySQL. After being deprecated in previous version, option –remote-host has been completely removed in Percona XtraBackup for MySQL…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… on the fly It can backup a server at approximately the maximum rate the server allows, given it’s IO system It… another server using “mysqlbinlog … –read-from-remote-server –raw –stop-never” Useful to mirror the binlogs on the master to a second server. Allows… work Tips/Tricks: –add-header=x-amz-server-side-encryption:AES256 to use the server side encryption feature which helps with some…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
….com/2009/06/08/impossible-possible-moving-innodb-tables-between-servers/ is now available in our latest releases of XtraBackup 0… information. Both files should be copied to remote server. Now on remote server you have to run MySQL server ® with XtraDB6 storage engine, you can… empty table with the same table definition as on old servers: CREATE DATABASE “testimport”; USE “testimport” CREATE TABLE `order_line` ( `ol…
