…How do you monitor MySQL to determine when it’s not responsive? A: The easiest way to do this is to simply connect to it and attempt to…mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql…load growth and need to have system handle another 1000 of such queries per second ? I will need to do…balance of CPU vs IO utilization as well as as simple as how much does it cost to…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…load by half through the load balancer did not restore proper response time, so it wasn’t load… for Daniel figuring out how to make mk-query-…to catch in action as it happens, but we’re thinking about ways to do just that. Catching a server…’s where improvements to the MySQL source code are necessary…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…I’d like to share my experience. The article does not cover MMM installation nor how to do this …masters Once standby servers (only db2 in our case) have caught-up, we are ready to upgrade …. you must change application to use different IP for MySQL or ensure some load balancer/proxy does this, …
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
…your load balancing/application to write to any single node in the cluster. Q: Are adding/updating mysql user …Galera limitation. Q: In the haproxy example, how do you specify with xtradb cluster the different…on the monitored MySQL server in question. It should be easy to use this tool to monitor at…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
…servers, application servers etc. We can put these behind some simple load balancer…how Synchronous Replication solutions such a Percona XtraDB Cluster and MySQL Cluster are different. Synchronous replication essentially allows you to…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
…load balancing and fall back I would like to be able to pass list of servers system can connect to and let it handle load balancing…to be able to run multiple queries for multiple MySQL connections at once. For scale out applications data to…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…server, so you can use DNS for load balancing without worrying about TTL and similar things. If Active server…to remove READER role from the server if it gets too delayed with replication (or if replication breaks) so you do not have to do…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…how to handle it, or be able to learn it. It is also important to adjust processes as required to…doing is wisely. It complicates operations tasks (backups, balancing, performance analyzes) as well as it exercises not so common paths in the MySQL server…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
…load balancing, using something like img23.domain.com to serve some of the images. I’m not big fan of purely DNS based load balancing…to using some server modules for access control or hacking one if you need some special functionality, few people however have skills to do…
