… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…_size=10G # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
…(PXC) replication can be encrypted via SSL for secure transfer of your replicated data. Setting this up…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…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… use a secure (https) connection over the web, else it will use a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options No more “pt-stalk — -h db1 -u me”. pt-stalk 2.2 and pt-mysql-summary 2.2 have all the standard MySQL options built-in, like other tools…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… providing unique features for MySQL backup. The new 2.1.1 GA version offers improved performance, enterprise-grade security, and lower resource…. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB…
Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
April 16, 2013 By 12 Comments
… called 91-mysql.conf in limits.d, but it no work. mysql soft nofile 10240 mysql hard nofile 40960 mysql soft nproc 10240 mysql hard nproc 40960 I still get [root@security]# cat /proc/31715/limits Limit Soft Limit Hard Limit Units Max processes 1024 385850 processes I put file 91-mysql.conf…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
Hi,Peter Boros Thanks for your good idea ! I have a security misgivings with use mysql -e,which need user and password because procedure box must be setted.
Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
April 17, 2013 By 12 Comments
… set only for the mysql user. Add this to 90-nproc.conf (or some other file in /etc/security/limits.d): root…
Post: Percona response to recent MySQL security bugs
December 6, 2012 By 2 Comments
… vulnerabilities in MySQL and closely related projects such as MariaDB and Percona Server. Usually we have inherited security fixes from MySQL when we have updated Percona Server to be based off a new Oracle MySQL release. In… affect current Percona Server versions and will shortly be making security releases and more information available (we wish to ensure what…
Post: Clarification on MySQL security vulnerability
June 19, 2012 By 2 Comments
… Percona XtraDB Cluster binaries, similar to other MySQL variants, are susceptible to the security vulnerability in MySQL/MariaDB sql/password.c: 64bit Ubuntu… version of Percona Server, Percona XtraDB Cluster, or any common MySQL variant to minimize security vulnerabilities.
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… opinion MySQL Security should be treated the following way – if you do not allow any access to MySQL Server you are reasonably secure. There… valid MySQL account and they have been normally treated very quickly by MySQL. The moment you give someone access to MySQL Server, all MySQL Security…
