…/mysql/query.log h=localhost,u=root,P=3306 h=192.168.1.100,u=perc,p=perc,P=3306 –convert-to-select… –continue-on-error –base-dir /tmp/ptupgrade/ > /tmp/ptupgrade/test1 2>/tmp/ptupgrade/test1.error
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
… CentOS 6.2 32 bit. One Master name: PRM_M, IP: 192.168.163.205 One Slave name: PRM_S1, IP: 192.168.163.206…_CHECK_LEVEL=”1” \ op monitor interval=”2s” role=”Slave” OCF_CHECK_LEVEL=”1” primitive reader_vip_1 ocf:heartbeat:IPaddr2 \ params ip=”192.168.163.171″ nic=”eth0″ primitive reader_vip_2 ocf:heartbeat:IPaddr2 \ params ip=”192.168…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
….0.0.1:7000 inlist=* between=* [shard1] host=192.168.56.101 db=ontime [shard2] host=192.168.56.102 db=ontime [shard3] host=192.168.56.103 db=ontime [shard4] host=192.168.56… BETWEEN 1980 and 2011 GROUP BY dest.CityName ORDER BY 2 DESC; Finally, Shard-Query performance continues to improve when grouping…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 102 Comments
… IP=”192.168.2.201″ node db2.grennan.com \ attributes IP=”192.168.2.202″ primitive failover-ip ocf:heartbeat:IPaddr \ params ip=”192.168.2.200″ …cib-bootstrap-options” \ expected-quorum-votes=”2” \ stonith-enabled=”false” \ dc-version=”1.1.6-3.el6-a02c0f19a00c1eb2527ad38f146ebc0834814558″ \ no-quorum…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
… information_schema.user_statistics\G *************************** 1. row *************************** USER: root TOTAL_CONNECTIONS: 2 CONCURRENT_CONNECTIONS: 0 …DENIED: 0 EMPTY_QUERIES: 506 *************************** 2. row *************************** CLIENT: 192.168.10.161 TOTAL_CONNECTIONS: 41539…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… using Linux (ssh) and Windows (Tunnelier): $ ssh root@192.168.0.180 root@192.168.0.180′s password: Last login: Fri Feb 22…] y :: Retrieving packages from extra… libmysqlclient-5.5.30-1-armv6h 3.2 MiB 435K/s 00:08 [########################################################] 100% mysql-clients-5…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…_slave_threads=2 wsrep_cluster_name=trimethylxanthine wsrep_sst_method=rsync wsrep_node_name=mysql1 innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 the wrong infomaton : 130221 17:59:00 mysqld…:59:05 [Note] WSREP: Passing config to GCS: base_host = 192.168.14.150; base_port = 4567; cert.log_conflicts = no; gcache…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 1, 2012 By 22 Comments
…-server-wsrep-5.5.20-23.4 with galera-23.2.0. When starting the second node and higher we get…, donor: 0 Apr 1 14:14:27 ubuntu-server-129 mysqld: 120401 14:14:26 [Warning] IP address ‘192.168.210.128′ could not be resolved: Name or service not known Apr 1 14:14:27 ubuntu…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 3, 2012 By 102 Comments
… keepalived with Direct Routing for loadbalancing. We setup a vip (192.168.5.141) in the config, and attach 3 real servers… slaves. I can change the clone rule with clone-max=2 and set a co location “dislike” for readervip on a…, just pacemaker. I’m running everything from squeeze-backport: Pacemaker 1.1.6-2
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… going up to 98%. We have a DELL server with 2 – 4 cores CPUs means total 8 cores and 32 GB…-increment-increment = 3 #auto-increment-offset = 1 #log-slave-updates skip_name_resolve #master-host = 192.168.0.203 #master-user = replication #master….x # clients (those using the mysqlclient10 compatibility package). #old_passwords=1 # Disabling symbolic-links is recommended to prevent assorted security risks…
