… a client that asked about using Percona Xtrabackup to take a snapshot of a particular MySQL schema and then reload it with…. However, given the import/export functionality of Xtrabackup combined with Percona Server (Exporting and Importing Tables), it did seem possible. Further…/orig/*[.exp|.ibd] /var/lib/mysql/orig_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… had to take was to extract the offsets for the Percona Server version I was using for the test (5.5….sock #audit_json_socket=1 audit_json_log_file=/var/lib/mysql/audit.log audit_record_cmds=connect,Quit Notice the audit… that I mentioned had to be extracted due to this Percona Server version not being included in the binary. And here…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… may fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size=52428800…: NOT_KILLED You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information… file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I have three nodes on VM with percona-xtrabackup-2…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
After compiling Percona Server with TokuDB, of course I wanted to compare InnoDB … malloc-lib=/usr/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql…_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 29, 2013 By 26 Comments
Building from either Percona‘s patch above, or TokuDB for MySQL or TokuDB for MariaDB, I consistently get failure in ./configure: … are set and tested correctly in the CMake files: TOKUFRACTALTREE_LIB linked by target “tokudb” in directory /data/tmp/mariadb-5.5.30-tokudb-7.0.1/storage/tokudb TOKUPORTABILITY_LIB linked by target “tokudb” in directory /data/tmp/mariadb-5…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
To recover a dropped or corrupt table with Percona Data Recovery Tool for InnoDB you need two things: media … the latest revision of the recovery tool bzr branch lp:percona-data-recovery-tool-for-innodb 1. Compile the dictionary parsers… 2. Split ibdata1 with page_parser ./page_parser -f /var/lib/mysql/ibdata1 3. Recover SYS_TABLES, SYS_INDEXES, SYS_COLUMNS and…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 25, 2013 By 26 Comments
… look a bit broken though 130425 15:07:00 Percona XtraDB (http://www.percona.com) 5.5.30-tokudb-7.0.1…-7.0.1-tokudb-7.0.1-tokudp� ‘ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MySQL Community Server (GPL)
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
… when you can simply yum -y install Percona-Server-server or apt-get install percona-server-server? Using OS specific packages comes… specialized repositories and package providers like the ones provided by Percona, MariaDB and Oracle fills this gap with updated versions. On… not prevent you from installing other MySQL packages on the server for other dependencies i.e. mysql-libs dependency for postfix, crontab, etc…
Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
With our newest release of Percona XtraDB Cluster, I would like to highlight a very nice …:45 [Note] WSREP: wsrep_load(): loading provider library ‘/usr/local/mysql/lib/libgalera_smm.so’ 130129 23:01:45 [Note] WSREP: wsrep… joins cluster. You may try it with the latest release Percona XtraDB Cluster 5.5.29
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…_format=ROW log_bin=mysql-bin wsrep_cluster_address=gcomm:// wsrep_provider=/usr/lib/libgalera_smm.so datadir=/var/lib/mysql wsrep_slave_threads…: Running: ‘wsrep_sst_xtrabackup ‘joiner’ ’10.195.206.117′ ” ‘/var/lib/mysql/’ ‘/etc/my.cnf’ ’20758′ 2>sst.err’ 120619 13:20… connections. Version: ’5.5.24-log’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Percona XtraDB Cluster (GPL), wsrep_23.6.r340 120619 13…
