…’s a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file. The way…| | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 468 | | Bytes_received | 1708212 | | Bytes_sent | 7796961 | | Com_admin_commands | 11893 | … snip … Then I format…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… node, my.cnf should look something like this on a relatively weak machine. [mysqld] server_id=1 binlog_format=ROW log_bin=mysql-bin wsrep_cluster_address=gcomm:// wsrep_provider=/usr/lib/libgalera_smm.so datadir=/var/lib/mysql wsrep…_sst_xtrabackup ‘joiner’ ’10.195.206.117′ ” ‘/var/lib/mysql/’ ‘/etc/my.cnf‘ ’20758′ 2>sst.err’ 120619 13:20:19 [Note] WSREP…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… up a dedicated MySQL slave which has log_slave_updates=1 and binlog_format=row to process SBR changes from a MySQL master. I…: 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 slave… log stores it progress in a metadata table: $ mysql -e ‘select * from flexviews.binlog_consumer_status\G’ -uroot *************************** 1. row *************************** server_id: 999…
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 socket=/var/run/mysqld/mysqld.sock … = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M … and you don’t want or can’t format the file system. One thing to note however – …
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… My.cnf ========== freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql/charsets… # binary logging and replication binlog_cache_size=1M binlog_format=MIXED log-slave-updates log-bin=mdmp_freehold_binlog sync_binlog=1 relay-log=mdmp…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… /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] wsrep_provider=/usr/lib/libgalera_smm.so user=mysql wsrep_cluster_address=gcomm:// binlog_format=ROW wsrep_slave_threads…
Comment: How to start a Percona XtraDB Cluster
February 28, 2013 By 10 Comments
…my.cnf file for my 3 nodes: [mysqld] wsrep_provider=/usr/lib64/libgalera_smm…rsync/xtrabackup binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1 I could run /etc/init.d/mysql start –wsrep-cluster-address=”…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… MySQL Enterprise Server (Commercial) my.cnf: [mysqld] server-id = 2 port = 3306 basedir = /usr/local/mysql datadir …_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp… 100M default_table_type = MYISAM log_long_format # Innodb innodb_status_file = 1 innodb_file…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… MySQL Enterprise Server (Commercial) my.cnf: [mysqld] server-id = 2 port = 3306 basedir = /usr/local/mysql datadir …_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp… 100M default_table_type = MYISAM log_long_format # Innodb innodb_status_file = 1 innodb_file…
