…-redirect port=percona1 [root@percona1 ~]# ccs -f /etc/cluster/cluster.conf –addfenceinst pcmk percona2 pcmk-redirect port=percona2 [root@percona1 ~]# ccs -f /etc/cluster/cluster.conf –addfenceinst pcmk percona3 pcmk-redirect port=percona3 Encrypt the cluster…
Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
… do it all, create a new file called 91-mysql.conf in limits.d, but it no work. mysql soft nofile… processes 1024 385850 processes I put file 91-mysql.conf contents into limits.conf and get same 1024 value. What do i…
Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
…Pavel– After you added the 91-mysql.conf file, what did you do next? Did you just restart … mysqld process and then your changes in the 91-mysql.conf should be picked up next time you SSH into the…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
In your my.cnf conf I don’t see barracuda file format and did you create your table using row_format = compressed with InnoDB which enables tablespace compression ?
Post: The write cache: Swap insanity tome III
… not important we add “vm.swappiness = 0″ to “/etc/sysctl.conf” and run “sysctl -p” and we are done. Swappiness solves…
Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
… only for the mysql user. Add this to 90-nproc.conf (or some other file in /etc/security/limits.d): root…
Post: linux.conf.au 2012 roundup
… the software stack. For those that don’t know: linux.conf.au is one of (if not the) most awesome technical… helping people admin machines – go and watch those talks. linux.conf.au (for me) is one of the cannot-miss events… few (err… only) talks that is repeatedly accepted into linux.conf.au. Why? Because Jon manages to compress a whole year…
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
… changes that you may have made to /etc/security/limits.conf! So even if you’ve properly adjusted /etc/security/limits… nproc/nofile limits in /etc/security/limits.conf or even this new 90-nproc.conf file is that these files are used… server’s limits are sufficient. Edit 90-nproc.conf (or create 91-mysql.conf) to set the desired process/thread limits to…
Post: Lighttpd as reverse proxy
… file lighttpd-1.4.XX/doc/lighttpd.conf and put to /etc/lighttpd/lighttpd.conf Create directory to store log files, e… actual directory with web documents Uncomment next lines in lighttpd.conf server.modules = ( … “mod_auth”, “mod_status”, “mod_proxy”, … ) mod_status… protect access to /server-status put next lines to lighttpd.conf auth.backend = “htpasswd” auth.backend.htpasswd.userfile = “/var/www/.htpasswd…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
…_comment | Initialized (0) | | wsrep_cert_index_size | 2 | | wsrep_cluster_conf_id | 18446744073709551615 | | wsrep_cluster_size | 1 | | wsrep_cluster_state_uuid…_comment | Initialized (0) | | wsrep_cert_index_size | 2 | | wsrep_cluster_conf_id | 18446744073709551615 | | wsrep_cluster_size | 1 | | wsrep_cluster_state_uuid…

