Home MySQL Tipricks
MySQL Tipricks
MySQL performance and security

MySQL HA options PDF Print E-mail
Written by xqube   
Wednesday, 01 April 2009 08:39

Tuning and using a single node MySQL setup is very simple and easy, but the fun starts when we challenge the big boys, claiming that MySQL can provide telco quality uptime i.e five nine up time. Five nine uptime means that a system will provide availability of service for 99.999% of the time it is given power and connectivity.

Last Updated on Wednesday, 01 April 2009 08:52
Read more...
 
MySQL table types PDF Print E-mail
Written by xqube   
Friday, 27 March 2009 07:38

An advantage with MySQL is that you have a choice of different storage engines (table types) in your Database. The different table types have different advantages and disadvantages. We will go through the two most popular table types, InnoDB and MyISAM in this article.

Last Updated on Wednesday, 01 April 2009 07:20
Read more...
 
Simple MySQL Replication PDF Print E-mail
Written by xqube   
Wednesday, 25 March 2009 12:51

Simple replication between a single master and slave

In this tutorial we set up simple replication with one master and one slave. The hostnames of the both machines are

Last Updated on Thursday, 26 March 2009 05:23
Read more...
 
MySQL Performance Tuning PDF Print E-mail
Written by xqube   
Wednesday, 25 March 2009 11:57

MySQL Performance Tuning Tips

In this article we will go through some changes in Schema, Queries and Server Parameters that can be changed to bump up performance.

Last Updated on Thursday, 26 March 2009 05:23
Read more...