… at least 2 sets of scripts to manage NDB startup, ndb-initializer and from Johan configurator www.severalnines.com. If all the… been added to Pacemaker recently, a Clone resources set, that allows an optional startup if only one of 2 similar resources starts…”>
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… Query Cache works with query text and want full result set at once. In prepared statements there is query with placeholders… comes from modification statements which you can calculate by (Com_insert+Com_delete+Com_update+Com_replace)/Qcache_hits . These are some numbers you… query wiping your all query cache option query_cache_limit was implemented which limits result set which can be stored in query…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…19 Percona XtraDB (http://www.percona.com) 1.1.8-rel25.3 started… | Value | +——————–+——-+ | wsrep_cluster_size | 3 | +——————–+——-+ 1 row in set (0.00 sec) When all nodes…log global mode http option tcplog option dontlognull retries 3 option redispatch maxconn 2000 …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…. I won’t give you a full rundown over every option in the file. But again, you learn quickly if something…_sent | 7796961 | | Com_admin_commands | 11893 | … snip … Then I format the second set of values up beside the first set for ease of… | | Bytes_received | 38563413074 | 1708212 | | Bytes_sent | 216162991863 | 7796961 | | Com_admin_commands | 255868807 | 11893 | | Com_alter_db | 0 | 0 | …snip This output is…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…the resource agent from here: https://github.com/y-trudeau/resource-agents/raw/master…reader_vip_3 property $id=”cib-bootstrap-options” \ dc-version=”1.0.11-a15ead49e20f047e129882619ed075a65c1ebdfe” \ cluster-infrastructure…should match the my.cnf pid_file setting. socket: The MySQL unix socket file …
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… treatment. DNS TTL Settings The system was using DNS based load balancing, using something like img23.domain.com to serve some of… different tasks and should not be mixed. Use noatime mount option Serving images you rarely need last access time tracked for… is in OS cache. Simple solution is use noatime mount option for your static content partition. Some web servers also support…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… to consider using it in production. Especially if you’re comming from “traditional” databases you’re likely to be shocked by… LOW_PRIORITY to adjust that or you can simply set low_priority_updates option. Anyway default behavior means any UPDATE statement which… enable this option – globally, for table or for set of statements (by using LOCK TABLES/UNLOCK TABLES) be careful. This option may improve…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…set (0.00 sec) mysql> SHOW INDEX_STATISTICS LIKE ‘hosting2%’; +——————————————–+———–+ | Index | Rows_read | +——————————————–+———–+ | hosting2.wp_options.option… in this article, then Bluehost.com CEO, Matt Heatton, has published …
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…download in a url like this: http://www.percona.com/get/
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… (~$20 on eBay) Total cost: ~76.5 AU$ (= ~79 US$). Optionally, if your screen has a DVI port, you can get… could also assign a permanent DNS name (like pi.yourdomain.com) by binding the reserved IP to a DNS name in…… OK Filling help tables… OK [...more setup information, please read...] [Optional] Set Percona server to startup at boot time [root@alarmpi ~]# systemctl…
