 Welcome Athens Linux Users! |
If you're new to Linux this is the group for you! |
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 |
Fun with MySQL 5Date: 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 |