… HDD storage configuration? After creating a vCache device with the default configuration, I started with a baseline HDD configuration for MySQL (configuration A, listed…-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… driver you’ve already had to install, and then further configuration requires modification to assorted sysctls. I would also argue that… FlashCache due to configuration flexibility, but if the GA release of vCache added some of FlashCache’s additional configuration options and exposed…
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 16, 2013 By 10 Comments
@Ricardo, What kind of tables? Can you create a new thread in the forums and post your configuration and wsrep_* status there.
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
… have been added in MySQL 5.6, go over the configuration and spend most time showing how you can use the…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… to do. See also http://mysqlha.blogspot.com/2013/05/configuring-innodb-for-mysql-56.html
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… issues around mutexes and Percona Server shows much better results Configurations and how to run benchmark: [mysqld] user=root port=3306…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… by log copying thread is now configurable by innobackupex –log-copy-interval. Making the interval configurable allows to reduce the time between…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… by log copying thread is now configurable by innobackupex –log-copy-interval. Making the interval configurable allows to reduce the time between…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… possible while still getting it copied amongst your nodes. Configuring Galera The configuration here is quite easy: wsrep_provider_options = “socket.ssl….pem; socket.ssl_key=/etc/mysql/key.pem” We simply configure the wsrep provider with our certificate and key files on… some have SSL and some do not. This is best configured when you are setting up a new cluster, but if…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… few settings that are relevant here, and they are all configured via the wsrep_provider_options global variable. gcs.fc_limit… allow replication to resume as soon as possible. An example configuration tuning flow control in a master/slave cluster might be…
