… IP=”10.2.2.162″ primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid….170″ nic=”eth0″ \ meta target-role=”Started” ms ms_MySQL p_mysql \ meta master-max=”1″ master-node-max=”1″ clone-max… bringing all the nodes to a consistent level. Also, the security around the solution should be improved, a fairly easy task…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
…, the MySQL packaging team does not always include with every release the latest and greatest, simply, select bug fixes especially security bug… be as easy as stopping MySQL, updating symlinks or your my.cnf basedir, starting MySQL and running mysql_upgrade. Unlike package managers, you… simply keeping package folders on unique directories. Lastly, running your MySQL server from pre-built binaries does not prevent you from…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… a cadre of the core MySQL developers to submit talks about what is new in MySQL, the MySQL roadmap for the future, and… those session and tutorial proposals on DRBD, partitioning, community toolkits, security, using MySQL with NoSQL, geospatial functionality, cloud computing, Cluster, search, sharding…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… to troubleshoot MySQL Crashes yet it is not always easy to get, especially with recent Linux distributions which have security features to prevent core files to be dumped by setuid processes (and MySQL Server is most commonly…/sbin/mysqld[0x516a61] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you…
Post: What's the recommended MySQL version?
August 15, 2011 By 24 Comments
… upgrade should really be about features, not bug fixes or security patches; those critical fixes should be applied to the previous…, and now I’d even say use MySQL 5.6. For older applications running MySQL 5.0, I’d say upgrade to… the near future. At this point, MySQL 5.1 is starting to get old, and MySQL 5.5′s new releases have…
Post: CVE-2012-4414 strikes back in MySQL 5.5.29 (and what we're doing in Percona Server 5.5.29)
January 13, 2013 By 4 Comments
… released, but soon), I filed MySQL bug 68045 (is marked private as it’s a security bug). This bug is in relation… very important, it means that anyone can verify if their MySQL server is vulnerable, after all, many people run their own… your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘`) SET…
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
… first first part of my analysis focused on testing specific MySQL functionally with Infobright’s storage engine. A lot of my… of results of queries over the large data set Basic security aspects The report that I produced may be found here… some of the queries. ICE supports almost all of the MySQL aggregation functions. Notably, GROUP_CONCAT is not supported, which is…
Post: Black-Box MySQL Performance Analysis with TCP Traffic
February 23, 2012 By 2 Comments
… they arrive and depart from a system. This works for MySQL as well as a lot of other types of systems… easy to get access to this data even in highly secure environments. I’ve finally written up a paper that shows…’s available from the white paper section of our website: MySQL Performance Analysis with Percona Toolkit and TCP/IP Network Traffic
Post: MySQL Training in Frankfurt, Germany
December 27, 2011 By Leave a Comment
We will be holding our highly acclaimed MySQL workshops in Frankfurt, Germany the week of February 13th. Early registration is open; enroll today and secure your seat. Detail and enrollment can be found here.
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 10 Comments
… / threads available to the MySQL user, typically by adding a line like this to /etc/security/limits.conf: mysql soft nproc 4096 followed up by a restart of MySQL in a fresh user session… a new file in /etc/security/limits.d with a higher number (e.g., 91-mysql.conf) and set your limits in…
