…MySQL 5.1+ row based logging (binlog_format=1) unique server_id in the my.cnf log_slave_updates=1, if this is a MySQL…logging not being enabled) it will exit with an error. It will exit with a message “setup completed” otherwise. Verify installation The binary log…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…enable…error log too. After the SSTs are done, you should check if you have a 3 node cluster. mysql…mysql> grant process on *.* to ‘clustercheckuser’@'localhost’ identified by ‘clustercheckpassword!’; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql…query log remained enabled – probably it caused so little overhead because there were no slow queries…
Post: Percona Server 5.1.52-12.3
December 13, 2010 By 2 Comments
…- The false error “innodb_extra_undoslots option is disabled but it was enabled before” was sometimes reported after upgrading from MySQL 5.0. (Yasufumi…reported for some queries when hits were actually occurring. (Oleg Tsarev) Bug #676146 – The development environment test of log_slow_verbosity=…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…errors and message like this one: make[1]: Leaving directory `/home/macko/work/mysql-5…mysql-5.0.51a) % su root Password: First you should apply the changes to the database configuration, specifically you need to enable slow logging…
Post: How to know if you're updating Slave you should not ?
April 11, 2010 By 8 Comments
…log_slave_updates is enabled which makes slave to write all updates to binary logs…mysql-bin.000002 | grep “server id 101″ | grep Query #100411 19:11:22 server id 101 end_log_pos 360 Query…error_code=0 #100411 19:24:45 server id 101 end_log_pos 1007 Query thread_id=5 exec_time=0 error_code=0 Any query…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql…port = 3306 back_log = 50 max_connections = 2500 max_connect_errors = 10 table_cache…size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_… is used. With WT cache enabled, single thread performance improvement …
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…mysql> insert into percona values (0,’percona1′,’vadim’); Query OK, 1 row affected (7.77 sec) percona1 mysql…30 [ERROR] WSREP: Local state seqno (6) is greater than group seqno (5): …We can see it in the log file: 120724 10:58:09 [Note…exactly like when ignore_sb is enabled. And if the local state…
Post: read_buffer_size can break your replication
June 6, 2012 By 12 Comments
…Error: Got fatal error 1236 from master when reading data from binary log: ‘log…logs of both masters. MasterA: masterA> mysqlbinlog data/mysql-bin.000004 | grep block_len #Begin_load_query…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…MySQL for binary backups mydumper for logical backups mysqlbinlog 5… master’s bin logs –compress option, compresses …queries to avoid nasty problems with “FLUSH TABLES WITH READ LOCK” –compress, compresses tables per file and should typically be enabled… If backups throw an error and are aborted, …
