… gives me this error message: “mysql_install_db: command not found” I’m not able to find mysql_install_db anywhere on the file system either… image) but it didn’t work on either. Should I install Percona server: http://www.percona.com/doc/percona-server/5…
Comment: Making the impossible: 3 nodes intercontinental replication
March 21, 2012 By 25 Comments
… -y remove mysql-libs yes | yum -y install Percona-XtraDB-server Percona-XtraDB-client right BEFORE: yes | yum -y install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client and then the mysql_install_db will be installed properly.
Post: Percona Server 5.1.56-12.7
April 18, 2011 By Leave a Comment
…) Changes were made to the post-install messages (Ignacio Nin) Bugs Fixed Bug #631667 – The mysql binary is now built with readline… mysql_install_db after installation or upgrade, in order to avoid “permission denied” error when starting ”mysqld”. (Aleksandr Kuzminsky) MySQL bugs 56433 and 51325 – These MySQL…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… the amazing MySQL manual, especially the option and variable reference…Com_alter_dbblogpercona.commanual Com_alter_db_upgradeblogpercona.commanual Com_alter_eventblogpercona….commanual Com_insert_selectblogpercona.commanual Com_install_pluginblogpercona.commanual Com_killblogpercona.commanual Com…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
January 19, 2012 By 94 Comments
…. I have 3 servers, both have the standard mysql db‘s setup as in mysql_install_db, created a replication client on all 3, reset… “Jan 19 13:01:56 tabit mysql[818]: ERROR: /usr/lib/ocf/resource.d//heartbeat/mysql: 1313: -q: not found” No resources…. status keeps at: Online: [ tabit meissa toucan ] Failed actions: p_mysql:1_start_0 (node=toucan, call=20, rc=1, status…
Post: Rebuilding MySQL with same options
April 8, 2010 By 4 Comments
… at “Configure-Command”: Configure command: ./configure ‘–localstatedir=/var/db/mysql‘ ‘–without-debug’ ‘–without-readline’ ‘–without-libedit’ ‘–without-bench’ ‘–… ‘build_alias=amd64-portbld-freebsd7.0′ Assuming MySQL was properly built and installed these are configuration options it was …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…’s a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf… mysql 3172 3137 78 Nov19 ? 1-11:17:30 /usr/libexec/mysqld –defaults-file=/etc/my.cnf –basedir=/usr –datadir=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication… so do not work well for a lot of installations, especially as MySQL Server do not offer any enforcements – ie there is… to filter the data. There is replicate-do-db and replicate-ignore-db options which closely mirror behavior of their binlog-do…
Comment: How to check MySQL Config files
December 27, 2011 By 7 Comments
… MySQL Password you specified during the MySQL installation). MySQL Settings define(“MYSQL_HOST”, “localhost”); define(“MYSQL_USER”, “root”); define(“MYSQL_PASS”, “password”); define(“MYSQL_DB“, “test”); $conn = mysql_connect(“”.MYSQL_HOST.”", “”.MYSQL_USER.”", “”.MYSQL_PASS…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…command. In this example I’m going to install the tools in /root/recovery-tool folder… 6120 FIELDS: emp_no from_date DB_TRX_ID DB_ROLL_PTR salary to_date INDEX…: 3 Deleted: 0 Skipped: 0 Warnings: 0 mysql (employees) > select * from salaries where emp_no=10008; …
