… using Linux (ssh) and Windows (Tunnelier): $ ssh root@192.168.0.180 root@192.168.0.180′s password: Last login: Fri Feb 22… :: Retrieving packages from extra… libmysqlclient-5.5.30-1-armv6h 3.2 MiB 435K/s 00:08 [########################################################] 100% mysql-clients-5.5…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
Post: Avoiding SST when adding new Percona XtraDB Cluster node
August 2, 2012 By Leave a Comment
… use a backup for this purpose, we have 3 prerequisites: use XtraBackup >= 2.0.1 the backup needs to be performed with….recv_addr (ex: wsrep_provider_options = “ist.recv_addr=192.168.70.2;”) if you don’t use yet the magic wsrep_node… [Note] WSREP: async IST sender starting to serve tcp://192.168.70.2:4568 sending 24-27 120802 13:05:15 [Note] WSREP…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
…0 ACCESS_DENIED: 0 EMPTY_QUERIES: 506 *************************** 2. row *************************** CLIENT: 192.168.10.161 TOTAL_CONNECTIONS: 41539 CONCURRENT_… | article119 | forum_id_3 | 1855 | | art84 | img_out84 | from_message_id | 8363 | | art115 | article115 | forum_id_2 | 6 | | art61…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… wsrep_cluster_address=gcomm:// binlog_format=ROW wsrep_slave_threads=2 wsrep_cluster_name=trimethylxanthine wsrep_sst_method=rsync wsrep_node….so’ 130221 17:59:05 [Note] WSREP: wsrep_load(): Galera 2.3(r143) by Codership Oy loaded succesfully. 130221 17:59:05…:59:05 [Note] WSREP: Passing config to GCS: base_host = 192.168.14.150; base_port = 4567; cert.log_conflicts = no; gcache…
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…=newcrmdb #auto-increment-increment = 3 #auto-increment-offset = 1 #log-slave-updates skip_name_resolve #master-host = 192.168.0.203 #master-user… # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). #old_passwords…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 3, 2012 By 102 Comments
… Routing for loadbalancing. We setup a vip (192.168.5.141) in the config, and attach 3 real servers to it (.74, .95… slaves. I can change the clone rule with clone-max=2 and set a co location “dislike” for readervip on a… so it’ll skip the master and set the other 2 nodes with a readervip (more of a hypothesis, but i…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
….1 498.9 1078.5 67.3 224.3 | 180.3 4.5 448.2 647.6 45.3 | 43.9 0.1 439.5….1 168.7 2581.4 192.8 | 124.7 0.1 121.5 2471.1 203.7 310.3 | 248.7 6.2 321.2… 326.1 595.8 61.2 | 61.5 10.0 331.3 579.2 61.1 313.3 | 251.2 4.9 319.0 503.5 60.2 | 62.1 12.8…
