MySQL - Articles

mysql

http://dev.mysql.com/tech-resources/articles/failover-strategy-part1.html
http://dev.mysql.com/tech-resources/articles/failover-strategy-part2.html
http://mysqlserverteam.com/virtual-columns-and-effective-functional-indexes-in-innodb/
http://dev.mysql.com/doc/refman/5.0/en/optimization.html
http://www.keithjbrown.co.uk/vworks/mysql/
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
http://www.artfulsoftware.com/infotree/queries.php?&bw=1280
http://www.bigdbahead.com/?p=119
http://www.mysqlperformanceblog.com/2007/10/29/hacking-to-make-alter-table-online-for-certain-changes/
http://highscalability.com/how-i-learned-stop-worrying-and-love-using-lot-disk-space-scale
http://www.pythian.com/blogs/1017/stop-worrying-use-disks-and-scale
http://blogging.compendiumblog.com/blog/blogging-techniques/0/0/amazon-simpledb-vs-google-bigtable-fight
http://h18006.www1.hp.com/storage/disk_storage/msa_diskarrays/san_arrays/index.html
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-failover.html
http://geert.vanderkelen.org/2009/10/mysql-cluster-replication-failover-some.html

http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/
http://blog.taragana.com/index.php/archive/one-mysql-configuration-tip-that-can-dramatically-improve-mysql-performance/
http://www.learn-mysql-tutorial.com/TuneMySQL.cfm
http://dev.mysql.com/tech-resources/presentations/presentation-oscon2000-20000719/index.html

http://www.sitepoint.com/cursors-mysql-stored-procedures/
http://www.sitepoint.com/mysql-tweaks-streamline-magento
http://net.tutsplus.com/tutorials/databases/visual-database-creation-with-mysql-workbench/
http://phpmaster.com/working-with-mysql-events/
http://net.tutsplus.com/tutorials/other/10-essential-sql-tips-for-developers/
http://net.tutsplus.com/tutorials/databases/sql-for-beginners/
http://net.tutsplus.com/tutorials/databases/sql-for-beginners-part-2/
http://net.tutsplus.com/tutorials/databases/sql-for-beginners-part-3-database-relationships/
http://net.tutsplus.com/tutorials/databases/quick-tip-working-with-mysql-and-sum
http://www.onextrapixel.com/2010/06/08/mysql-has-functions-part-1-date-time-functions/
http://www.onextrapixel.com/2010/06/10/mysql-has-functions-part-2-string-theory/

Unit testing:
http://dev.mysql.com/doc/mysqltest/2.0/en/unit-tests-google-test.html
http://dev.mysql.com/doc/mysqltest/2.0/en/unit-tests-tap.html
http://theory.github.com/mytap/
http://utmysql.sourceforge.net/
https://omervk.wordpress.com/2011/12/21/unit-testing-mysql-bound-code/
http://schimpf.es/unit-testing-in-mysql/
http://www.longacre-scm.com/blog/index.php/2009/04/unit-tests-for-mysql-scripts
sqlUnit

Backup, Recovery and Replication:
http://dev.mysql.com/doc/refman/5.1/en/point-in-time-recovery.html
http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html
http://bakery.cakephp.org/articles/view/load-balancing-and-mysql-master-and-slaves-2

Monitoring:
http://www.linux-ha.org/wiki/Heartbeat

Load balancing:
http://www.howtoforge.com/loadbalanced_mysql_cluster_debian
http://agiletesting.blogspot.com/2009/04/mysql-load-balancing-and-read-write.html
http://forums.mysql.com/read.php?25,180406
http://knowledgehub.zeus.com/articles/2008/07/07/building_a_mysql_load_balancing_proxy
http://www.cyberciti.biz/tips/mysql-proxy-howto.html
http://bakery.cakephp.org/articles/view/load-balancing-and-mysql-master-and-slaves-2
http://nixcraft.com/databases-servers/933-howto-load-balancing-mysql-web-server.html
http://lists.freebsd.org/pipermail/freebsd-database/2005-February/000264.html
http://northernmost.org/blog/mysql-load-balancing-with-mylbhelper/
http://serverfault.com/questions/82702/load-balancing-mysql-servers
http://theory.uwinnipeg.ca/mysql/load-balancer.html
http://www.zdnet.com/blog/open-source/mysql-to-get-dynamic-load-balancing-in-2008/1422
http://bluhaloit.wordpress.com/2009/05/11/simple-mysql-replication-cluster-with-load-balancer-on-the-slaves/
http://dev.mysql.com/tech-resources/articles/mysql-cluster-for-two-servers.html

Performance and best practices:
http://www.sitepoint.com/explain-sql-explain-queries/
http://karlssonondatabases.blogspot.com/2010/11/monitoring-mysql-sql-statement-way-it.html
http://net.tutsplus.com/tutorials/other/top-20-mysql-best-practices/
http://www.devshed.com/c/a/MySQL/MySQL-Optimization-part-1/
http://www.devshed.com/c/a/MySQL/MySQL-Optimization-part-2/3/
http://www.databasejournal.com/features/mysql/article.php/3367871/Optimizing-the-mysqld-variables.htm
http://www.mysql.com/why-mysql/performance/
http://dev.mysql.com/doc/refman/5.1/en/table-cache.html
http://dev.mysql.com/doc/refman/5.1/en/dynamic-system-variables.html
http://search.mysql.com/search?q=system-variables.html&lr=lang_en
http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html
http://dev.mysql.com/doc/refman/5.0/en/how-to-avoid-table-scan.html

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License