… gives us more flexibility by allowing users to extend the server‘s functionality with their own code, and this is what…, these are the lines I had to add to my config file for the plugin to work (plus one commented line… has been an important missing feature on the server, which has made using MySQL in PCI or SOX compliant environments, to name…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2 ] Now we can upgrade all servers…Starting fenced… [ OK ] Starting dlm_controld… [ OK ] Tuning DLM kernel config… [ OK ] Starting gfs_controld… [ OK ] Unfencing self… [ OK ] …
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… a separate line in your config. If we already have a …mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql… the default IP of the server. I could not find a…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… this benchmark for MySQL Server 5.5.30, 5.6.11 and Percona Server 5.5.30 and check how these servers will handle… IO-bound scenario. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate…=root -D port=3306 -D password= -D maxid1=100000001 -c config/MyConfig.properties -csvstats final-stats.csv -csvstream streaming-stats.csv…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… if it’s done automatically, for instance when restarting the server without the skip-slave-start option), replication may start again… (0.04 sec) mysql> show slave status\G Empty set (0.00 sec) mysql> start slave; ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… Percona Server showed fairly close results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to… rerun tests on several our boxes. You can find setup/config details at the very end of this post. Hardware: HP…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…here is how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; In…// Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600, ‘automatic_serialization’ => true ); $memcacheOpts = array( ‘servers‘ =>…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. Each test… C (shown in the graph as the blue line – SSD config) which shows the most consistent performance. The others all have…_word_len = 4 thread_stack = 192K tmp_table_size = 64M serverid = 101 key_buffer_size = 8M read_buffer_size = 1M…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… way and server will be back to old value upon restart. MySQL also does not have option to re-read config file without restarting as some other software so approach to change config file and when instruct server to re… easily because MySQL Server does not seems to have an easy way to check what was the default value for given Server Variable…
Post: Debugging MySQL SSL problems
November 8, 2012 By Leave a Comment
… server key, and this was already working on an existing environment with the same MySQL version. I had already added the relevant config options in the ‘mysqld’ section of the my.cnf: [mysqld] ssl-key=/etc/mysql/ssl/server-key.pem ssl-cert=/etc/mysql/ssl/server… MySQL server outside the chroot and confirm SSL worked fine there. MySQL worked fine outside the chroot, and so did the basic openssl server…
