… market is now great for MySQL Consulting. The number of MySQL users is growing rapidly thanks for MySQL Marketing and Sales departments and… resolved. If you think you know MySQL well and would like to work in young and active company let us know. Growth… time DBAs for some projects helping to secure MySQL setting up backup policy and monitoring and make sure it is running healthy…
Page: Consulting for MySQL
July 31, 2006 By
… your application needs using MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL Replication consulting including chained… setup backup procedures, pro actively monitor server to avoid downtime. Customized Training for MySQL Want your developers to learn MySQL best practices ? How to…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
The MySQL Master-Master replication (often in active-passive mode) is popular pattern used by many companies using MySQL for scale out. Most… load balancing without worrying about TTL and similar things. If Active server fails in the pair both its READER and WRITER… will be taken over by passive node and depending on monitoring configuration it can happen within few seconds. Such IP based…
Post: Getting use of Slave in MySQL Replication
February 14, 2007 By 15 Comments
… causes problems if you would like to use MySQL Slave as it can contain stale data. It … can be used in Master-Master replication in Active-Passive mode, just think about passive node as … method you’re using you should not forget to monitor if replication is running properly and if replication …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… large MySQL web MySQL installations using Sharding or replication IO needs are typically rather predictable. There are also often nice monitoring tools available… to using SAN based active-passive clusters for availability purposes and they look to do the same with MySQL. This works though…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… Somewhere in 6.x series proper performance monitoring instrumentation and semi-synchronous replication is …the speaker kept quoting benefits of MySQL Enterprise from MySQL Marketing Materials . There is not …normally takes part in all Storage Related activities. There were some Q&A about various …
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
… too dynamic in development (nothing stops you from starting to actively break old code though). Indeed there are some problems which… Semi-synchronous replication, advanced Monitoring and scaling features some users need other features than MySQL adding in newer MySQL releases. In other cases…
Post: Why do we care about MySQL Performance at High Concurrency?
February 26, 2013 By 9 Comments
…possible resulting in hundreds or even thousands concurrently active queries. The question is how common is …than low tens with normal load. Many have monitoring set up to kick in if number of…do not really run MySQL with high concurrency does it really matter how MySQL performs with high concurrency…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… transactions which require a lot of complications and performance overhead. MySQL has to do several fsync() calls per transaction commit to… joining PBXT and Innodb tables. Operations Things like backup and monitoring becomes a lot more complicated plus you have to deal… very actively because of potential complications involved. Now lets think what we could have if we have a version of MySQL Server…
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
…mysql> SELECT * FROM INFORMATION_SCHEMA.USER_STATISTICS WHERE USER=’#mysql_system#’\G *************************** 1. row *************************** USER: #mysql… the slave thread was actively processing statements. If the slave…true, especially if you’re monitoring Seconds_behind_master instead of…
