… and available for viewing over at percona.com. My apologies if we weren’t able to…log data being sent down to the lower-level slaves. You can also use the slave_compressed_protocol option in /etc/my.cnf… 130606 2:22:41 [ERROR] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…: [percona@db1 ~]$ ps -eaf | grep mysqld root 3137 1 0 Nov19 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… help! i setup percona cluster in vm, if in file /etc/my.cnf,i add wsrep_cluster_address=gcomm:// to fill it ,the mysql server will not running [root@mysql1 ~]# vi /etc/my.cnf [mysqld…= 192.168.14.150; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/;…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… decided to call this solution PRM for Percona Replication Manager. All the parts …params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid” \ socket=”/var/run/mysqld/mysqld.sock” replication_user…default value). In some cases, if slaves are logging replication updates, it may cause failover …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… on the database nodes. # yum -y install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client percona-xtrabackup Install haproxy and sysbench on the… first node, my.cnf should look something like this on a relatively weak machine. [mysqld] server_id=1 binlog_format=ROW log_bin=mysql…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… properly currently, I needed to change it in my.cnf and restart the nodes) wsrep_provider_options = “pc…. node clusters. We can see it in the log file: 120724 10:58:09 [Note] WSREP: evs::…then. On a third node, instead of running Percona XtraDB Cluster (mysqld) just run garbd: Currently there is no …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… 0.25 as from logs can be an issue ? A: My demo vms were …=true’. Q: Can you quickly show the my.cnf settings again? A: Sure, see this … from each other. Q: I installed Percona as cluster database working with Zabbix (innodb…should it be ok to have in [mysqld_safe] the following: wsrep_urls=gcomm://…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… /path/to/mysqld {mysqld options…} Note that ‘{mysqld options}’ could for instance include –default-file=/etc/my.cnf (if this is where your my.cnf file is…) 0x7A3CB0: my_malloc (in /usr/local/percona/mysql-5.5.28/usr/sbin/mysqld) | ->27.73% (114,084,096B) 0x7255BB: Log_event::read_log_event…
Post: Win a free ticket to RailsConf!
May 15, 2011 By 10 Comments
… the winner, I’ll give you a discount code for Percona Live as a consolation prize. Here’s the catch: you… in /etc/my.cnf # by setting the variable “err-log” # in the [safe_mysqld] section as follows: # # [safe_mysqld] # err-log=/var/lib/mysql/mysqld.log # # If the root user has a password you have to create a # /root/.my.cnf configuration file…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… machine and you forget to change the server-id in my.cnf. You change the server-id interactively, this is an action…#option_mysqld_replicate-same-server-id [3] http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates [4] http://dev.mysql.com/doc/refman/5.1/en/change-master-to.html [5] http://www.percona…
