June 18, 2013

Post: Percona Server for MySQL 5.5.31-30.3 now available

…-5615 vulnerability. This vulnerability would allow remote attacker to detect what user accounts exist on the server. This bug fix comes originally…2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently. This…

Post: Announcing Percona XtraBackup 2.1.1 GA

… backup. The new 2.1.1 GA version offers improved performance, enterprise-grade security, and lower resource usage. This release is… –remote-host has been completely removed in Percona XtraBackup 2.1. Percona XtraBackup can use XtraDB changed page tracking feature to perform… #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.0.7 for MySQL available for download

…open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases… for new MySQL 5.6 features (GTID, remote/transportable tablespaces, separate undo tablespace, 5.6-… TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and …

Post: Percona XtraBackup 2.1.0 for MySQL beta now available

…specific features are used (such as GTID, remote/transportable tablespaces, separate undo tablespace, 5.6…can use XtraDB changed page tracking feature to perform the Incremental Backups now. Bugs Fixed: Fixed… trigger a bug if the server being backed up was standalone server (neither master nor slave …

Post: MySQL Backup tools used by Percona Remote DBA for MySQL

… a good test. Store your binlogs off your primary server so you can perform point in time recovery. Store your binlogs offsite… 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: Percona Server 5.1.58-12.9

… LRU Dump/Restore patch, which provides similar improvements in restart performance and has the advantage of persisting across machine restarts. The… engine and a replication environment, its client connection to the remote server was closed leading to an unappropriated network error and stopping…

Post: Percona Server 5.5.14-20.5

… the 5.5.14-20.5 milestone at Launchpad. Improvements Performance Improvements fsync() has been replaced with fdatasync() to improve perfomance… engine and a replication environment, its client connection to the remote server was closed leading to an unappropriated network error and stopping…

Post: Using Flexviews - part two, change data capture

…: Monitor a database table, or tables for changes. Improve ETL performance by identifying the data which has changed. Maintain materialized views…. It is possible to read from and/or write to remote servers, but this example uses the local machine which is the…_demo\G *************************** 1. row *************************** dml_type: 1 uow_id: 10 fv$server_id: 999 c1: 2 c2: 2 *************************** 2. row *************************** dml_type…

Post: Percona is hiring performance experts

… who are top-level, senior experts in LAMP/Open-Source performance and scalability. Most of our work involves MySQL (at least… of work. It is not all remote DBA, nor is it all urgent troubleshooting or performance audits; it’s everything you can… problem in my application. Calculate when I’ll outgrow the server! Can you benchmark my application? Make me a new database…

Post: How Can Percona MySQL Server Development Services Help ?

… license lock-in. Performance – We’re very good helping you to get the most performance from your MySQL server via our Percona MySQL Consulting, Percona MySQL Support, and Percona MySQL Remote DBA services. With our MySQL Server