… that is outside the scope of this post. Similarly, reloading the data will be a very IO intense operation (redo logs, binlogs…: mysql -N -B <<'EOF' > discard-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` DISCARD TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…. Bug fixed #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack… libdbd-mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. XtraDB changed page tracking used to hold the log… changed page tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn…
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…log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log… the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…the intermediate server, thus resulting in less binary log data being sent down to the lower-level…What is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5….back end, but I think that’s probably where the similarities end. Q: What kind of …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… will show where GTIDs shine and where improvements are expected. This is the second post of a series of articles focused on MySQL 5…=10002; mysql> start slave; Those of you who have already done these operations with file-based replication know that it is usually… master has crashed before sending all writes If the binary logs of the master are no longer readable, you will probably…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… and restart it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log tells us why the… not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a… nice to be able to mix servers where gtid_mode is ON with servers where gtid_mode is OFF. This would greatly simplify the…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…to 2.1.3. My node is crashed and I have this error in my log : 07:53:55 UTC – mysqld …. You can use the following information to find out where mysqld died. If you see no messages after this, …:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…is actually a form of Eventual Consistency where the client is forced to correct the problem before it can commit. It is… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…relaxing the fsync: set innodb_flush_log_at_trx_commit to something …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order…16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file… force key (primary) select count(*) from sbtest$i WHERE k like ‘%0%’ SysBench-0.5/lua: POINT…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… the entire cache is cleared (think restarting a memcache node). This is where a persistent cache can be invaluable. Enter MySQL 5.6 with the memcached plugin… As part of the standard MySQL 5… disk. However, there is write activity stemming from the fact that this is using InnoDB under the hood (redo logs, etc). Based on…
