… I need for my setup (I still can have synthetic auto_inc PK, but in that case I still will need SECONDARY…=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-requests=0…
Post: Webinar: Best Practices for MySQL Scalability on May 1
April 30, 2013 By Leave a Comment
…=”attachment_12964″ align=”alignleft” width=”285″] “Best Practices for MySQL Scalability.”[/caption] If you have not already done so, I encourage… providing a high-level look at the components of MySQL scalability: application architecture, MySQL version and configuration, choosing hardware and operating…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
The link http://www.codership.com/en/content/benchmarking-write-scalability does not work anymore? I am running mysqlslap against a… –csv=/tmp/mysqlslap_3index_innodb.csv –engine=innodb –auto-generate-sql-add-autoincrement –auto-generate-sql-load-type=mixed –number-of-queries…
Comment: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
Which of the open source flashcache solutions are most popular? * https://github.com/stec-inc/EnhanceIO * Linux dm-cache * Facebook flashcache
Comment: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 15, 2013 By 2 Comments
… why this could be happening? how does the master’s auto detection takes place? TIA don’t know what went wrong…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… with autocommits, you can rely on wsrep_retry_autocommit to auto-retry the transactions for you. However, each autocommit is retried…
Post: How to create a new (or repair a broken) GTID based slave with Percona XtraBackup
May 9, 2013 By 3 Comments
….0.1.1″, master_user=”msandbox”, master_password=”msandbox”, MASTER_AUTO_POSITION = 1; 5- Check the replication status: slave1 > show slave…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
Vadim, can you confirm negative scalability with InnoDB compression and multi value inserts ?
Post: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 6, 2013 By 2 Comments
… added to pt-table-checksum: cluster. This method attempts to auto-discover cluster nodes, alleviating the need to specify cluster node…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… simply cannot replace in short term. Control Your Auto-Incrementing Columns PXC/Galera controls auto-incrementing values internally within the cluster, this….0 though, you can workaround this by turning off wsrep_auto_increment_control from the Percona XtraDB Cluster nodes as workaround…
