If you're new to Linux this is the group for you!
Beginners are very welcome!

Welcome Athens Linux Users!   Join Group


Local Linux Resources

World Wide Linux links

Fun with MySQL 5

Date: February 19th, 2009

This meeting was the most well-attended that we have had in recent memory

Brandon Checketts spoke about some interesting things he had worked with recently using MySQL 5 including Circular Replication and MERGE tables.

He started off with two vanilla installations of MySQL server, and configured a standard Master/Slave environment. Then converted that to circular replication where updates made on either server were propagated to the other server as well.

Note that this might not be suitable for all environments or all types of data. It is important to understand your unique circumstances

He also demonstrated some of the useful concepts using MERGE tables. They can be used to split up large tables into smaller sections to avoid having huge tables. In the example, his data was split up by month, but any other logical way works as well. Merge tables can then be created on the fly to query just part (or the entire) subset of tables