Welcome Athens Linux Users!

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

What is CHUGALUG?

Our next meeting . . .

CHUGALUG meetings are now being held on the third Thursday of each month at 7:00 PM at Rivers Crossing

When possible, they are also streamed live over Ustream.

Meetings always begin with 15-20 minutes of introductory material intended for people who are new to the topic. After that, the presentation moves on to a more advanced discussion.

This January, we will be going to Four Athens instead of the regular meeting. Please see the top of this page for more information.

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