… TCP for replication. Because synchronous replication needs to replicate to all nodes at once, this means 1 copy of your replication…_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql]# service mysql start We can see that a multicast node still needs to bind…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… to the amazing MySQL manual, especially the option and variable reference …: an option and variable reference for all three sites in one! abort_slave_….commanual basedirblogpercona.commanual big_tablesblogpercona.commanual bind_addressblogpercona.commanual Binlog_cache_disk_useblogpercona….
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…] Crash recovery finished. 120619 13:21:19 [Note] Server hostname (bind-address): ‘(null)’; port: 3306 120619 13:21:19 [Note] – ‘(null)’ resolves… all the threads are going to hit the c1 server. # sysbench –test=oltp –db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… MySQL, in a space not much bigger than your mouse, with the power consumption of only a smartphone charger, fully networked, all… list all IP addresses it assigned, usually together with a host name. While there, you could also assign a permanent IP address (still assigned via DHCP) by binding a MAC address to a reserved IP in your router…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
… the user-data script, we need to put our IP address in if [ "$OUR_IP" == "" ] then echo “Error getting Our IP… the user-data script, we need to put our IP address in if [ "$OUR_IP" == "" ] then echo “Error getting Our IP… -e ‘s/bind-address/#bind-address/g’ /etc/mysql/my.cnf sudo service mysql restart sleep 5 /usr/bin/mysql -u root -proot -e “grant all on *.* to…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…mysql.sock #tmpdir =/mysql_tmp/ # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock bind-address…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… in an ascending order of the file address, then InnoDB schedules the read of all the 64 pages of the extent where… additional throughput? HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG… using couple of MySQL Servers on single node. You can make them to use different hard drives and bind to different CPUs…
