Hello everyone and good evening. My name is Brittany Faber, the reigning 2011 Shiboyne County Fair Soul Affair. I currently manage a thousand cow dairy at Soaring Eagle up in Newton. My past consists of showing cattle and pigs at the Shiboyne County Fair for multiple years. I'm here this evening with two special guests at the Shiboyne County Fair Soul Affair Gala. With me this evening is Alice in Dairyland in the Wisconsin State Fair Soul Affair. First up is Alice in Dairyland, Rochelle. Rochelle, can you tell me a little bit about yourself? Sure. Well, I'm the 65th Alice in Dairyland and I grew up on my family's dairy and cash crop farm in Lodi. So not too far, right in the center of the state, and I grew up raising animals, being active on my family's farm, involved in 4-H, and I went to school at the University of Wisconsin Platteville, majoring in agribusiness. Great. Thank you for coming this evening as well. Can you tell me a little bit about the process it took to become Alice? It's a very long process to become Alice. The application is actually due in January and then an interview happens in February and the finals are in May. So it's several months and the finals itself is a three-day process where you do TV interviews, radio interviews, one-on-one interviews with a selection panel, and you tour a lot of agribusinesses to learn about our state's rich agriculture history and heritage and be able to share that in a short speech at the finals as well. Great. Thank you very much. So what does the rest of your schedule as Alice look like? I am busy. I started officially last Monday, so I've been on the job for one week and have been active. I've been traveling to Dairy Breakfast. June is Dairy Month, and I've also been invited to attend baseball games and speak on behalf of dairy producers at these dairy themed events. So Wisconsin agriculture is $59 billion strong and our dairy industry itself generates $26 billion worth of that $59 billion. So we've got a lot to be proud of here in America's Dairyland and I look forward to the many adventures to come this year. Great. Thank you. So is there anything else that you would like to tell us about Wisconsin's agricultural industry? Well, like I mentioned, Wisconsin agriculture is so diverse. We have a very strong dairy industry, but we also have a lot of other commodities that we're number one in. Cranberries, for example, are, you know, Wisconsin's a leader in cranberry production, mink production. We've got Christmas trees, vegetables, you know, the list goes on and that's something that we should really be proud of and enjoy because that is part of our Wisconsin way of life and you know, something that you and I can appreciate and it ends up on our food tables a lot of the time. Great. Thank you very much, Rachelle. Our next special guest this evening here at the Gala in Johnsonville is Rachelle Cassinson from the Wisconsin State Faires to the Faires. Rachelle, welcome. Hi, Brittany. Thank you so much for having me tonight. I'm so excited to be here. Glad for you to attend. Can you tell me a little bit about yourself and your basic backgrounds? Sure. My name is Rachelle Cassinson. Like you said, I am the 2012 Wisconsin Faires to the Faires. I grew up on a cash crop farm in Union Grove, which is located in Racine County. I'm currently a senior attending the University of Wisconsin Whitewater where I'm studying to earn a bachelor's degree in elementary education with a minor in special education and I'm excited to graduate in this coming December. Great. Thank you very much. Can you tell us a little bit about where you were crowned and the process it took to become State Fairest? I was crowned the Racine County Fairest of the Fair last July and ran for the state position in January and my title started then and I will go until this coming January where I will crown the 2013 Wisconsin Fairest of the Faires. In the process of becoming the Fairest of the Faires I had to go through a variety of interviews both individual and group, sit with judges at dinners and basically represent the fair industry in the best that I can. So it was a great process and I met a lot of great girls through the process. Great. Thank you very much for your input. Can you tell us a little bit about your schedule and what you look forward to for the rest of your years, Rain? So far I've been able to hit a variety of fairs crownings like tonight's festivities. I have also been able to go to Dairy Breakfast, the cheese exposition held in Milwaukee, as well as cows on the concourse where I was able to talk about the dairy industry in the fair industry. And so it's a really great way to meet people. I look forward to attending as many county fairs as I can. There are 76 county district and state fairs in Wisconsin. So I'm going to try to hit as many of those 76 as I possibly can, as well as be the official hostess to the 2011 Wisconsin State or 2012 Wisconsin Fair. Great. Thank you. Can you tell us what's new and upcoming at the Wisconsin State Fair this year? Definitely. This year at the Wisconsin State Fair you can see a shark show where a live person will jump into the tank to feed the sharks. There will also be a fair museum where you can go see the 161 years of the state fair. There is also a new carnival amusement area. So that's really great. Bring the kids out. It's going to be such a great time in a Disneyland like atmosphere. And also new this year is you can buy fair tickets at any festival of foods in Wisconsin. And you just simply go to the cashier and ask for a $5 ticket and that goes through June 30th. Great. Thank you very much. We'd like to thank everyone for joining us this evening here at Black's Hall in Johnsonville. Good evening. Welcome to the 2012 Sherwoite County Ferris of the Fair Gala. I am Heather Leipang and I'm so honored to have been asked by the Ferris committee to be here again with you this year, serve as your NC, and share in this exciting evening where we will learn about more amazing young women in our community and celebrate Sherwoite County agriculture along with the traditions of the Sherwoite County Fair. Sherwoite County is truly a special place that I know I couldn't be happier or more proud to be from and happier to call home with my husband Joe and raise our three children, Andrew, who's five, William, who's three, and Lucy, 18 months. And like all of you, I have many fond memories of the county fair. As a child, I enjoyed walking through the barns and sharing sweet treats with my grandparents. Cream puffs, of course, they were my grandma Lucy's favorite. And hopefully as Joe and I enjoy the fair with our children, we are creating special memories for them as well. And speaking of unique memories, our 2011 Sherwoite County Ferris of the Fair has had a great year. Brittany Faber is 21 years old and the daughter of Dennis and Rebecca Faber. She is a graduate of Plymouth High School and Lakeshore Technical College, where she received a technical diploma in dairy herd management. She is currently employed at Soaring Eagle Dairy as assistant hermit's person. Let's give a warm welcome to our 2011 Sherwoite County Ferris of the Fair, Brittany Faber. Thank you Heather. Hello fair goers and enthusiasts. Welcome to the 2012 Sherwoite County Ferris of the Fair Gala. My name is Brittany Faber and tonight is my final moment as a 2011 Sherwoite County Ferris of the Fair. It doesn't seem like all of us here competing at this very event. It was one busy year but boy, it was worth it. And it really went by fast. Tonight I am pleased to say that we have four very qualified contestants that are inviting for this position. Leading up to the gala, the ladies have to send in an application and resume. Then, contestants, committee members, and myself attend the Dale Karney training course to better prepare us for this position and other life endeavors. Throughout today, each individual contestant went through individual interviews, workshops, and group interviews and attended workshops with the Wisconsin State Ferris, Alice in Dairyland, and myself. Tonight you will witness this stage performance and speaking skills by presenting their self-introduction and radio advertisement. I am proud to say that I have a slight connection with each of these ladies from showing pigs and fairing sows late in the morning with Liz Lippert, being a part of a fair going to school with Abby, working with Vanessa and the rest of the Van Will family with Taylor's Memorial Raffle, and getting to know Steph at Lasher's Gala and Dale Karney training course. I am very confident to say that any of these ladies will do an outstanding job representing our county and our fair. I would like to thank all the committee members, fairer members, and various program sponsors for your continuous support throughout the years. And a special thank you goes to Lax Hall for hosting our gala again this year, the judges for judging our event, and the 4-8 youth for the entertainment this evening. Good luck to all of the contestants, and thank you all for attending the gala, showing your support for the contestants of the Sheboyne County Fair. Enjoy the evening, and thank you all once again. I'd like to recognize the men and women in service to our great country, and those that have given their lives. Please rise if you are currently serving in our military, and those veterans who have served and are able, so we may thank you all for your sacrifice for our freedoms. A supreme rush in the Spring Valley 4-H Club to lead us in our Pledge of Allegiance. I pledge allegiance to the flag of the United States of America, and to the Republic for which it stands, one Nation, under God, indivisible, with liberty and justice for all. And now we'll begin with our candidate introductions. Each candidate will introduce herself, and we will welcome them in alphabetical order. First let's meet Abby Gainser. I'm Lisa Dairy Farm. I'm currently working as the parlor manager. I'm also employed at Kellogg's Foods, part-time merchandiser. My fair experience started off with Farmer Bud and progressed into 4-H Dairy Kellogg, showing estate and county fairs. In my free time, I enjoy playing softball in the fall and summer leagues, and I also enjoy experimenting with different foods and making meals for my family and friends. My goals are to buy registered holstings and continue my education. Thank you. Next we'll meet Stephanie Kahn. From Plymouth, Wisconsin, where I have lived with my parents, Mary and Joff Kemp, for my entire life of 20 years. I'm currently attending the University of Wisconsin, River Falls, studying biology to become a doctor of veterinary medicine. Over the years, I have participated in numerous leadership activities that could help me fulfill the very important role of Ferris's affair. Thank you. My name is Elizabeth Lindbergh. I grew up on a small dairy farm in the town of Briebush. I'm currently attending Carroll University as a biology major. In the future, I hope to accomplish my dream of becoming a large animal veterinarian. As many of you already know, Swine has always been a passion. I want to continue being a mentor and share my knowledge to all 4-H and F thing members. Thank you. I have been attending Lakeland College and this will be my sophomore year. I'm currently majoring in history with the goal of working in a museum and helping them with their archives. I also am employed at Pine Haven Nursing Home as a dietary aide and I love doing that and working with the residents there. I also enjoy snowmobiling, being with my family, cows and traveling. Thank you. Many special guests join us this evening and first we'll meet the 2012 Wisconsin Ferris of the Ferris, Rachelle Cassinson and siblings Tom, Tia and Callie Jo. She's a 2008 graduate of Waterford High School and currently a senior attending the University of Wisconsin Whitewater. She's studying to earn a bachelor's degree in elementary education with a minor in special education and plans to graduate in December this year. Outside of school, she enjoys advising the Racine County 4-H Ambassadors as well as helping other families meet processing facility. Please help me welcome to Sheboygan County, your 2012 Wisconsin Ferris of the Ferris, Rachelle Cassinson. Thank you, Heather. For coming out this evening, I am so excited to be here as well as find out who will be the 2012 Sheboygan Ferris of the Ferris. In my position as the Wisconsin Ferris of the Ferris, I have the opportunity to represent the 76th County District in State Ferris in Wisconsin as well as the official hostess to the 2012 Wisconsin State Fair. I had so much fun already and look forward to my summer representing the fair industry in Wisconsin. Thus far, I have attended a variety of events, some of which include Ferris of the Ferris County like tonight's facilities, as well as dairy breakfast and a cheese exposition held in Milwaukee and a cow's-on-pack horse in Madison representing the fair industry and talking about the series behind the fair industry. I look forward to continuing my travels this summer around the state as I try to attend as many of the fairs as I possibly can and I will be coming back to Sheboygan County. The fair has always been a big part of my life. At the fair, you can experience so many different activities and events and what is even great is that each fair is different from one another. So I can't even imagine something better than the fair and experiencing all these different activities that you can participate in. It's a great way for you to make memories and start traditions with loved ones, friends and families. So whether you attend the fair for the carnival, the evening activities, or trying to find that food on a stick, I encourage you all to go out and visit the fairs this summer. Not only Sheboygan County, but the other fairs located in Wisconsin. I also encourage you to attend the Wisconsin State Fair presented by U.S. Cellular August 2nd through the 12th. This year at the State Fair, we have a variety of new events, some of which include a shark show where they will have a live person diving in and feeding the sharks, a fair museum depicting the 161 years of the state fair, as well as a new carnival amusement area held in the same place but with a new atmosphere. So really great things happening down at State Fair. I also would like to encourage you to go purchase your state fair ticket at any festival food for five dollars. You can purchase a ticket at any cashier when you're checking out and that is now through June 30th. So make sure you all go out and buy those State Fair tickets. Lastly, I just want to congratulate all the contestants on how far you've made it. I've had the opportunity to get to know the contestants today and any one of them would make such a great contribution as well as asset to the Sheboygan County Fair. And I look forward to seeing whoever is crowned and I will be nervous for you. So again, thank you so much for having me tonight and I look forward to seeing you all this summer. The selection team started at three o'clock this afternoon doing individual interviews and a group interview and had a light dinner with the candidates so far. Their jobs aren't over yet as the candidates are still being evaluated on their professionalism, speaking ability and fair knowledge. I will ask that they please stand as we recognize them for their commitment to the program. Amy Ryan. Amy is a public relations and freelance writer for several agricultural publications. She graduated from the University of Wisconsin-Madison with degrees in agricultural journalism and dairy science. Amy and her husband Chad are dairy producers at Ryan View Paul scenes and reside in fond life with their two active children. This singular is from Manitowoc and the co-owner of Irish Acres. Actively involved in Farm Bureau, Brent and his wife Becky are past winners of the State Achievement Award and former State Young Farmers Chairs. Brent is a graduate of the Farm Bureau Leadership Institute. Brent and Becky have three children, 15, 8, and 6. Welcome Brent as well. It's a cash crop operation with her husband, State Representative Keith Riff. Laurier is actively serving on the Fair Board of the Lodi Agricultural Fair and Co-Chairs Affairs Committee. A mom of three children, Laurier experienced one of her proudest moments as a parent when her daughter Rochelle was selected as a 65th Alps in Dairyland. Please join me in thanking the selection panel for this time. If you have any special guests you would like to introduce, please, I'm here for the podium. So we've already met our 2011 Fair, so the fair will be a favor. Rochelle, you have to appear for me. Pretty, pretty favor. Please stand and I'll introduce our special guests. With Alison Dairyland, who we will learn more from later, Rochelle Riff. So the fair is again, Rochelle Cassison. Hersh of White and County Fair is joining us this evening. Brianna Wimler, two foundation sponsors, Bill and Pauline Jens. And he's right here with the tie-up for Leslie Gladden, photos by Leslie Faye. And by the Johnsonville Hustlers 4-H Club. Our videographer from WSCS-CVN Sherwigan, C. Reiner, who provides an extra special touch and our presages this evening in some of our floral arrangements for tonight's program. Thank you, everyone. Okay, now we'll continue with the candidate program. At this time, we're ready to move into the applicant's radio advertising and impromptu questioning. We'll be here on stage. The women drew in order this afternoon for this component of the contest. And our first will be Abby Gazer. Oh, I'm sorry. I guess I would excuse the other candidates, please. Before we get started. Thank you. Abby is 22 and from Plymouth, and a daughter of Brian and Jean Gazer. She's a graduate of Plymouth High School and a tenant of Rock Valley Technical College. She is currently employed at her family's dairy farm, Gazer Dairy, as the parlor manager. She is also employed by Kellogg's as a part-time merchandiser. Her future goals include going back to college to finish her culinary arts degree. Her long-term goals include owning her own registered animals and saving money to travel and see the world. At the Shiboyne County Fair is only a few weeks away. There's fun for everyone. The children can't wait to hop on rides, e-con candy, visit animals, and laugh with forever credit. The adults are already toe-tabbing as they await their favorite poker country and rock performers. Then it's off to the pig races, spring car races, and track poles. So if you see me, say hi. Abby Gazer, your fairs to the fair. See you there. August 30th through September 3rd at the Shiboyne County Fairgrounds in Plymouth. Okay, we have our impromptu question. A neighboring county is considering developing a Ferris of the Fair program. They contact you as Ferris and ask for your opinion. How do you respond? For it, it is a great opportunity for the young girls and even boys to get involved in their community and teach them about your fair and showing all the great aspects of going to a county fair and all the projects that the little four-agers, even the educational building with the school surrounding, are involved. And then all the great just four-age projects that showing animals, all the woodwork, crafts, and school projects in the educational building where they get to show off their children's artwork. And I think it would be a great opportunity for your county to get a fairs program. People, welcome Stephanie Cannon. Stephanie is 20 years old in Plymouth and the daughter of Jeff and Mary Cannon. She's graduate of Shiboyne Lutheran High School and is currently attending UW River Falls, majoring in biology with a minor in animal science, Pre-Vet. This summer, she will be working at the Plymouth Aquatic Center as a lifeguard and lessons instructor and Athena's manufacturing company. Her future goals include obtaining her bachelor's degree in biology. She would then like to apply to veterinary school and then the master's international program through the Peace Corps. Her long-term goals include opening her own small and large animal veterinary clinic and continue with volunteer work. What you must do is pack your car full. It's a Shiboyne County fair, so take some notes. You can sell the rabbits, sheep, cows, and goats. But that's just the beginning. Think of all the games you could be winning. 4 H milkshakes and hot Wisconsin cheese and a food to make you more than pleased. With bands like 76 Juliet, you'll have on singing and dancing, I'd like to bet. I'll see you there at the Shiboyne County fair this August 30th through September 3rd, so go out and spread the word. A neighboring county is considering developing a fairest of the fair program. They contact you as fairest and ask for an opinion. How do you respond? If a neighboring county decided to develop a fair to the fair program, I would highly encourage it. The opportunity that is given to me now is one that I can take a lot of stuff from, a lot I've learned, a lot of interactions I've had with people. I've learned so much about Shiboyne County itself and I would highly, highly recommend anyone to do this. Thank you. Vanessa is 18 and from Waldo, the daughter of Jay and Cindy Vanderbilt. She's a graduate of Usford High School and currently attending Lakeland College, majoring in history with a minor in Spanish and non-profit management. She is currently employed as a director of Aida Pine Hanna Christian Home. Her future goals include graduating from college. After graduation, she would like to become archivist at a historical society or company and attend UW-Milwaukee for her master's in museum studies. Vanessa Vanderbilt, 2012's fairest of the fair and I would like to personally invite you and your family to the Shiboyne County Fair August 30th through September 3rd. This year we have entertainment for your entire family, including lumberjack shows for the little ones and we have some awesome demolition derbies for those that are more into adventure in your group. We'd like to have you check us out online at www.shabco-fair.com and I look forward to seeing you and your family at the Shiboyne County Fair. Thank you Vanessa. Now I have a question for you. A neighboring county is considering developing a fairest of the fair program. They contact you as fairest and ask for your opinion. How would you respond? Saying that it would be an awesome idea for another county to consider a new a fairest of the fair program. Now only does it help them find a good representative for their fair and what they're looking for to promote it. They're also helping girls in the community be able to learn new skills like public speaking communication and things like that and it works really well for them to be able to have someone to promote them in a positive manner. Liz is 19 from Lemula, the daughter of Jerome and Barbara Lindbergh. She's a graduate of Plymouth High School and currently attending Carroll University majoring in biology with intent to free veterinary medicine. She's currently employed at Dairy Doctors Veterinary Services and during the school year is a phonophone supervisor and planning with Carroll University. In three years her goal is to apply to the UW School of Veterinary Medicine. Her long-term goals are to become a large animal veterinarian and own a happy farm. The Sheboygan County Fair is a lot of fun for age to see. Animals, bands, cotton, candy, demolition, entertainment, farmer bugs, grandpa crutches, horses, ice cream, judging contests, kettle porn, lumberjack show, motocross racing, night lights, oil can harry, project rides, quotes, sales tractor pull, udders, banners, winners, excitement, yo-yo-loon and the zipper. Join me at the Sheboygan County Fair from August 30th to September 3rd where it's fun from A to Z. Question for you. A neighboring county is considering developing a Ferris of the Ferris program. They contact you as Ferris and ask your opinion. How would you respond? If the neighboring county would ask me to help them start up a new Ferris the Ferris program, I would help them by first encouraging them to do so because having an Ambassador of the Fair definitely helps with promotion, education, and being a role model. So if there is someone who would want to do that, I'd definitely help them with their candidates, their applications, and everything they need to become a Ferris of the Ferris County. Thank you. Use our judges. We're to this point already in the evening. So thank you. Thank you, judges. Like to meet another special guest, Rochelle Riff is our 65th Alice in Dairyland. She's from Lodon, Wisconsin and raised in her family's Dane County Dairy and Cash Crop Farm. She graduated from UW-Platteville in 2009 and is an associate marketing manager for Madison-Faith's Pellet and Parking. Let's welcome to Sheboygan County, Rochelle Riff. This is the four young women here who just gave it their all, and I hope you can read now. I remember sitting in those seats as a Ferris of the Fair for the Lodon Agricultural Fair a couple of years ago now. So great job. I look forward to seeing you guys out there active, continuing to promote the fair industry and our agriculture industry. Welcome, all of you, to the Sheboygan County Ferris of the Fair Gala. My name is Rochelle Riff and I am the 65th Alice in Dairyland. I was selected on May 19th, and in that moment, my life changed. This is a one-year contract position through the Department of Agriculture, Trade, and Consumer Protection. And in my role, I get to travel across the state of Wisconsin, putting on over 40,000 miles in one year. That's more than enough to circle the globe. Pretty amazing. First week, I already put on over 1,000 of those miles attending dairy breakfast, as well as dairy game baseball games to cheer on the Wisconsin Timberriders and the Milwaukee Brewers, where I have been educating consumers of all ages on the importance of including three servings of dairy products per day in their food choices. June is Dairy Month, a time to celebrate our high-quality products, outstanding care of the animals, and our dedication to preserving our natural resources. To appreciate how far we've come, we need to take a step back to look at our agriculture heritage. The original pioneer farmer grew enough food to feed their family. Today's American farmer produces enough to feed 155 people. I was lucky to have one dairy cow. Today's Wisconsin farmer has an average of 100 cows, driving our $26 billion dairy industry. Cooper's President, George Washington, was also an innovative farmer. He used new fertilizers, prop rotation, and equipment, in fact, Washington invented a tool to make planting crops easier. His design was a foundation to modern day planters that we see in the fields today. Look how Wisconsin pioneers have cultivated the way toward modern agriculture. W.T. Hoard founded the Wisconsin Dairyland Association, a trendsetter in his time, hoards us to design ideas on farm and communicate with his findings by publishing Hoard's dairyman magazine. His passion to share ideas continues to inspire dairymen across state to keep our competitive edge as America's Dairyland. Alice in Dairyland shares a similar passion to educate and engage consumers. Modern technology allows each farmer as well as Alice in Dairyland to tell agriculture story and communicate directly with today's consumers. Farmers like consumers access online information wherever they are, even from their fields. And if you enjoy a cold, sweet treat in an ice cream cone like I do, we can thank our pioneer, Dr. Stephen Batta from his invention. The butterfax tester helped farmers measure how much butterfax was in their cow's milk, which is still used today. Measuring butterfax, a key ingredient to creating those quality, delicious, and nutritious calcium treats. Let's not forget that ice cream is the perfect pairing with other tasty Wisconsin products such as mint, strawberries, tortures, and many, many more. These commodities are part of Wisconsin's diverse agriculture industry, which generates $59 billion annually. While our agricultural pioneers have paved the way for progress, it's our consumer demand that continues to inspire upcoming pioneers to produce enough high-quality products to feed a growing world. It's that pioneer spirit that I shared across Wisconsin that is truly something special from Wisconsin. Thank you for the support of the fair program here in Sheboygan County. As you heard, these young ladies are ready to get promoting the county and the fair program that you have here. And they are the future, the voices of our agriculture and our fair industry. And I think they will do an excellent job. So thank you for having me, good luck to the girls, and thank you all for your support of this program. An update of this year's fairs activities, representing the Sheboygan County Fair Association's board president, Gary Vanderken. We all know how important and appreciate all the work that they do, and so we'd like to take another moment to thank him and the board for everything that goes into the fund that we have and the positive impression their work brings to Sheboygan County. That's all from Gary for an update. Good mess up with the forages, jizz. Followed out the scenario, I am. Thanks a lot. Hop in on the Sheboygan County Fair. Okay, I think things are kind of on the down hill right now. We started looking at entertainments right after the fair last year in October. We had most of it booked probably by December. What we didn't have booked, we probably booked at our convention in January. And we're feeling very good about our fair. We are the second third largest fair in the state, and we're proud of that. If you go by our grounds right now, the grounds are beautiful. We are really proud of that. We're kind of tweaking things right now. I'm going to follow that for a second. I'm about 20 times better than I speak at home. Yeah, so yeah, good at this. But now, so far this year, we've been very involved in the recent, and we're having a record year this year, every Saturday night, the Fair Association runs the fair, runs the races with the help of various volunteer groups, which are all the Tony, which would pay a certain amount, only a thousand bucks a night to help us off, because it's just getting so big we can't handle it ourselves. So we've been doing that for years. But to the fair and not Thursday night, and the fair is the fair.  We start Thursday night with the meat animal sale, and um, I also got Thursday night. Thursday night, wristbands, tractor pull, a local tractor pull. I'm sorry, yeah. Friday night, we're going to go racing with the IRA, Sprint Paris. Saturday night, we're going to have, I don't know if I got the name straight or not, we're going to have the monster trucks on Saturday night. And on Sunday night, on Sunday, during the day, of course we have the maturity show, which has been very well received, and people really put a lot of work into that. And Sunday night, we're going to try something new. We have a different kind of board now. I'm the oldest. But we have a younger board coming on now, and bringing new ideas. And we want to try a motocross. I guess this is a hot thing right now. And if you want GSB in this motocross, it's hot. So, they brought in 600 yards of topsoil, which is sitting in the North parking lot right now. They have to go on the track. Saturday night has to come off. Monday morning, the demolition derby. We have Monday afternoon. So all in all, right now, I think we're in pretty good shape. All the entertainment is pretty much hired, which is a little clean to do, not a lot, but we hope to see you at the fair. Thank you very much. And once again, I would like to thank Courtney and her Ferris and the Ferris Committee for what great job they do. They did a lot of work, a lot of effort into this, and they keep smiling. I don't know how to do it. Thank you. Thank you. The entertainment tonight's entertainment is brought to us by the hardworking 4-H Club members and parents of the Johnsonville Hospital 4-H Club. They will be presenting Accidental Discoveries, a lesson in just being yourself. Don't they look great? Ladies and gentlemen, Accidental Discoveries, a lesson on just being yourself. This musical was written by Logan Schreiber, a member of the Johnsonville Hustlers 4-H Club. Discover the message in the musical that we should all look beyond what we see on the outside of people. People may surprise you when they have more in common with you than you think.  Don't be sheep. Exchange students from Germany mistake their English and accidentally attend Betsy Ross Elementary School. During their stay, they may saw an unexpected discovery. And gentlemen, we find to play football without American friends. Our schedule says that in science class we learn fun facts about plugs. I wonder if they'll be in a music class. Yeah, maybe we can scare them with the plugs. Luke, here we are. Discovery number one, in all girls' school, hearts get dirty and bugs are smiling creatures. Girls are about frills, lace, makeup, dresses, sparkles, and worst of all, pink. But knowing that they didn't want to go back to Germany, they decided it would be easier to try to fit in red and rather be so different from everyone else. This might survive today. This won't be the last time that you see me around the fair or attending fair events. It's in my passion and it's here to stay. I had many memorable moments as Ferris from meeting new people and participating in different events, the list goes on and on. So I'm not going to babble on the different events that I did. That's what my scrapbook is for. I'm here to talk about the connections I made and the lessons I learned along the way those to observe and to think outside the backs. I have a huge thank you to the committee members for teaching this to me and you probably didn't know you impacted me as such. Each committee member has also taught me something, something different. The Courtney and she taught me no matter what is going on to always have a smile on your face and present yourself positively. You never know whose life you can impact. Not once have I ever seen her with a smile on her face and that has rubbed off on me and made me a happier person. One that has shown me tremendous strength and to be proud of who you are and represent yourself well is Brenda. One face, be five foam foam, enough said. Verla, our committee, but with her modern unique fashion and style, she taught me to express myself in stand-note. It's important to leave a lasting positive impression on people no matter if it's kids or the media. You and John taught me hard work and to work towards what you strive to achieve. You must be in the farmer's blood. Barb taught me to get involved and participate in many events as possible to widen my knowledge of my community and my faith. All of this taught me to push myself and get outside the box. There was a lot of help in the Bill Carnegie class, but she demonstrated that acting foolish to get a point across may not be so foolish in the end. Kara, she was always laughing and giggling. She always learned to embrace every opportunity and make the best of it. Verla, you showed me that my family is important and to value their support. No matter how many activities are going on and how crazy my year got, I always had my family to fall back on and for that I am thankful. This was learned and many more to come, I'm sure. This evening, because we all share one passion, the Chihuahua County Fair. And that wouldn't be possible if it wasn't for the Fair Board and the Fair Employees. I had an amazing week fun with all the office ladies and the other members. When I wasn't being shoveled around on a golf cart and being rushed here and there and pulled here and pulled there, the office ladies always made it known if I ever needed anything or needed a place to rest that I had somewhere to go. Thank you so much for making my 2011 Fair Week lots of fun and entertaining. Those ladies were a hoot. The events of the Fair from opening up for various fans and slipping in the mud in my formal dress to welcome the sold out audience to the monster truck show. One of my highlights was walking around the Fair, talking with other fairgoers and children. My goal was to speak to as many children and youth as possible and what helped me accomplish that was having a baby to eat foodies. I learned so much about my fellow community and other interests at the Fair. I have not just widened my knowledge about the Chihuahua County Fair or the county in general but found out a lot about myself as well. I have very thankful for this opportunity that I was given and I have truly grown as an adult and grown as an individual. I thank you all along that have supported me along the way drove me in grades and helped fix stresses which was almost a full-time job. I also wanted to thank Lauren Bobot the 2011 Chihuahua County Fair's attendant who has helped me through so much this past year multiple events she attended for me and with me. I can't thank her enough for all of her dedication to this program and to the Fair. I was truly blessed to have her at my side seeing how we've known each other since we were diapers. I want to thank everyone once again for coming for all their effort and supporting that has put into this program. Thank you very much and I was truly honored to serve as the 2011 Chihuahua County Fair slip fair. Thank you very much and enjoy the rest of the evening and good luck to the contestants. Representative Steve Castell and State Senator Joe Leihman to the stage Thank you Heather welcome everybody it's good to be back here at Locks Hall you know thinking about how many times we've been here over the years and actually this is the ninth time that we've been together consecutively at Locks Hall to select the Fair slip fair and this will be the eighth fairs that we'll be recognizing and it's obviously a great thing I want to point out in all those years there's never even been an attempt to recall the fair slip fair Senator Michael and I are very, very happy to have an opportunity to participate in the small way by recognizing with the citation from the Wisconsin legislature the outgoing fair slip fair and it's really you know we've always been so proud of the young ladies who represent us representing Boyke County it's an opportunity every time I've had an opportunity to meet one of the new fairs after they've begun their reign I'm reminded of just how lucky we are not only to be living in Wisconsin but the cherry on top is to be living in Boyke County, Wisconsin it's really wonderful so let me begin and whereas Ms. Brittany favor of Plymouth, Wisconsin USA has successfully completed her honorable tenure as the Boyke County fairs of the fair and whereas Brittany with her accomplishments as fairs of the fair proudly displays and represents the very best that Boyke County has to offer whereas Brittany favor has worked diligently to strengthen Wisconsin's agricultural sector and raise public awareness about the positive impact agriculture has on our economy and our daily lives and whereas Brittany represents the bright future of Wisconsin agriculture and the Boyke County community wishes her well as she works to advance her career and dairy her management therefore State Senator Joel Iblum and State Representative Steve Costel hereby recognize and congratulate Brittany on her dedication to the promotion of Wisconsin agriculture and her service as Boyke County's fairs of the fair I'm going to sneak up here and do an extra special presentation tonight as well I want to congratulate Brittany and Anchor for a great service over the past year but Representative Costel also recognized Locke's Hall and I would like Carl to join us up on the stage here at this time if he can't hopefully he's not serving come on up everybody the whole Locke's family presentation that I expect tonight we're going to have Courtney start us off here in a special presentation for Locke's Hall Ladies and gentlemen it's an honor for the fairs of the fair committee and all the fairs that are here tonight to be celebrating and celebrating the fairs that are here tonight to be celebrating 100 years with the Locke's family and Locke's Hall for the past eight years we've had the pleasure to work with each of you as we prepared for this wonderful event to support our young people and what reminds me so much of our program is so much of what I feel your family lives by and that is faith, family, and friend throughout the years you've not only touched us the last eight years but for the last 100 years Locke's Hall and this family have contributed to the community by all that they do because they love the Lord and they love their family and the friends that they've made over the years so on behalf of the fairs committee we've put together this bouquet it's an artificial arrangement that will last for hopefully another 100 years and it has on here a certificate that says congratulations Locke on 100 years Sherwin County Ferris to the Fair and it has each one of our past eight ferris that have been selected here at Locke's Hall so congratulations I can remember being in 4-H and we just had a wonderful experience when we were in it as a family and we would hope that every parent would bring their children into the 4-H program our grandchildren because there's so much to be learned by being involved in 4-H thank you for you from the state of Wisconsin thank you Courtney 100 years think of these walls to talk just imagine imagine all of the fun serious and emotional times that have been had in this facility over the past 100 years including this great event focusing on the Ferris to the Fair but the Locke family has been focused on that 100 years as Courtney said and as we all know I'm really treating their customers like family and working to make our experiences here the most fun and enjoyable and just kind of family kind of based as they can be and on behalf of the citizens of the area Representative Castell and I wanted to recognize the Locke family on their 100 years of committed service to this facility and I mean 100 years of being in the restaurant business that is just amazing it's just awesome that you're all still smiling wanting to be here tonight and wanting to continue to serve so we wanted to recognize them I know you had a great festivity a couple of months or a couple months ago and we weren't able to be there but we wanted to recognize the Locke family on their 100 years of excellence in running locks, tavern, and ballroom let's give them a congratulations and congratulations we would like to offer our sincere thanks to the numerous businesses and individuals who were generous in their donation to the Ferris to the Fair program so if you would please turn with me to the back of your program all pouring of support for the Ferris program I would like to very briefly wonderful sponsors support those businesses if you can throughout the year again to each and every one of you that are here tonight thank you for being a sponsor we look forward to working with you again next year well the Ferris committee is standing with me here on stage and we started planning the Gallant in early spring with the goals of getting a great group of candidates and having a great turnout at Locke's Hall do you think they did a good job it's committed, it's hard working and we're fun we all believe that our efforts are making a difference in the lives of young candidates and the Shaboyi County Fair we all take our role very seriously but we very much enjoy our time together so thank you ladies for joining me up here on stage I would like to introduce them if you'd step forward here at Abraham's our treasure Kelly Bindel Leanne Black Sue and John Bourne Elizabeth Gibbs and Barb Spulton and she'll be joining us here she had another meeting that she had to go to for a second thank you so please join me in extending a heartfelt thank you and congratulations to the Ferris committee the Ferris committee we thank you very much for the great job that you did as our 2011 Ferris of the Fair you are very hard working professional and talented we all respect you and we ask for a mile for our program great job Brittany congratulations and best wishes for the future for the next Ferris of the Fair we enjoyed working with you today we wish you all the best of the lot tonight we look forward to working with you in the future our next group to be recognized is the Ferris Selection panel oh my goodness and they're not back yet they are really working we'll have to appreciate them later I also would like to thank Ms. Rochelle Kastenson our Wisconsin Ferris of the Fair and our 65th Alice in Maryland the girls enjoy our workshops and we're honored to have you the best this evening to brighten our evening and share your positive messages congratulations great numbers who took time to be here and it was great because there was so much laughter in the crowd and we're just looking forward to great things from you in the future we also wanted to say thank you to our agency Heather Lydon for giving up her evening to join us tonight she has nine talents among us being a great mom working with WeE Energy and she also was a past Miss Wisconsin so let's bring her back out here right ladies and gentlemen all for joining us again this evening and for supporting our talented down leaders the best to all of our candidates and please stay after the gala this evening for the winner's dinner donated by our generous sponsors thank you again have a great evening ladies and gentlemen oh it's the exciting conclusion of our night it's time to invite all the candidates to come forward on stage and to go to reminders as Courtney mentioned everyone's invited to stay after the gala celebrate and enjoy the delicious products donated by our sponsors and a reminder to the median family photos will be taken after the event in front of the stage please come forward at that time today's we'll be receiving gift baskets worth several hundred dollars for my generous sponsors as well actually maybe our Alice will come up and talk just a little bit about her schedule our Alice and Daria are going to join us on stage one more time to talk about her busy week selected the next morning I signed a contract right at 9 am to make sure that I was committed to doing this job for one year and they handed me several pages of events to do so my first week like I mentioned I've been going to dairy breakfast and baseball games I got to throw the first pitch of the brewers game yesterday and they came home with a win thank goodness they survived I have lots of events coming up this is the week of the Wisconsin State FFA convention so I will be there in attendance and hopefully inspire some young agriculturalists to continue pursuing a future in agriculture you know the average consumer is now three to five generations removed from production agriculture so there's definitely a need for them to be heard and represented here in Wisconsin I know that you guys have your county breakfast on the farm coming up for this next weekend and this is not my most updated schedule but I hope to be there and our selection panel is back so thank you the candidates will be receiving a special gift basket from some of our generous sponsors and I'll describe what we have been forward the third runner up will receive a $50 cash prize from the Ferris program the second runner up also receives $50 cash from the Ferris program the first runner up will be active filling the shoes of the Ferris in areas where she is not able to attend first runner up will receive a $200 cash award from new scholarship sponsors Bill and Pauline Jens family their granddaughter Erin Jens who is the 2008 Sheboygan County Ferris of the Fair is with us tonight and is representing the family this evening thank you Jens family the 12th Ferris of the Fair will be responsible for serving their official host Labor Day Weekend as well as participate and represent Sheboygan County in a state competition in January the winner this evening will be receiving the Jean and Kathy Kassner family foundation scholarship of $500 thank you Kassners $50 scholarship award from a grant provided by the 2006 farm technology days in Sheboygan County may I have the envelope please I'm going to ask you to move to the front of the group when your name is called good luck to all of you, thank you and we look forward to supporting you wherever your path leads in the future okay here we go our third runner up is third runner up is Abby Gaser Vanessa Van Der Wiel third up is Stephanie Kapp thank you so much


Hello everyone and thank you for staying from the last presentation today and So my name is Aston Gavill and I work for the alababa cloud And I'm here to talk about the polar DB Which is a database architecture for the cloud So before working for alababa I used to work for Oracle in the MySQL optimizer team for 10 years and I've been working on databases for 25 years or so so At alababa we have a lot of databases. I'm not sure how much you know about alababa, but you can think of it as the Chinese version of Amazon PayPal and eBay and YouTube and what name it you combine So there's a lot of so it's the biggest e-commerce site in in China we also have a cloud offering that is the biggest in China so The So the e-commerce of alababa they have like Sales sales for one trillion trillion US dollars a year. I believe that is something like It's 70 Luck or you would call it or something like that and There's a lot of data petabate of Data and on average there's like 100 million transactions a day But that is not even over the year or every day someday days of the year. There's much more There's a special day in China. They call the singles day because it's all 11 11 all once Where the where the total alababa sales is Many times higher than what you get on Amazon on cyber Monday or Prime day now the numbers for a for cyber Monday is for the entire US sales so you can see that then just the sales for alababa is much higher and When November 11 arrives we need to be able to handle a load that is 100 times higher You see that when you go here You see the load as approaching midnight and then it goes up then all the people have already have put all their Goods in their sales baskets and they're just ready to push on order on this day. So We need to have a set of where we can keep the latency for the all these customers Stable they should not experience any slower a Process than they used to and one thing good thing about the cloud is that you don't have to buy all the Hardware that you need if you are some some in Chinese company for example that need preparing for November 11 You don't need to buy All the hardware that you to be able to handle this loud you can if you use the The cloud instead then you move your capital expenses to variable Operational expenses so you can actually just pay for extra computers compute when you need it and The forecast says that by 2020 like eight eighty three percent of the enterprise workloads will be in the cloud And it's not only about loud We see that the amount of data that people store store becomes higher and higher And One of the main reason for that is that it's no longer just humans that enters data into the database You have the internet of things. There's a lot of things sensors and so out there that Stores a lot of data into the databases that so the storage needed is increasing in spot exponentially so We want to have a database that is specially tutored or tailored for for the for the cloud It needs to be scalable needs to scale automatically when you get more load You notice you need to scale both on load and on storage It needs to be highly available You need to have multiple copies of the data. So if there's one copies are not available. You still are able able to serve your Customers you need to be able to fail over to another Machine if the current machine is failing and the user should experience. So downtown downtime And we want this database to integrate with all the other cloud services. You have cloud services for security for monitoring for Artificial intelligence and so on. So here's where PolarDB comes in which is Is Alibaba's Alibaba clouds answer to these or solutions for these requirements So PolarDB will use a special hardware in order to provide The good performance for the database It's using auto scaling. You have the usual you pay with how much you use and so on as in cloud You you get all the security from the cloud and there's a lot of Automation in there that's people are used to from the cloud So first, I will talk about the storage part of this architecture And so and PolarStore is our It's a specialized distributed storage Layer So used by the PolarDB So PolarStore has a lot of chunk servers. Each chunk contains some gigabytes of data and each chunk will be in several copies across the storage and the database will connect to this storage by embedding a special library that Communicate with the database storage So this PolarSwitch component and now it knows which chunk should have which Know which chunk server should have each chunk so so the PolarDB does not Just see the storage as if it was a local storage All the magic happens in the layers the PolarSwitch and Special hardware is here used to get the good performance. We used the RDMA network, which is a protocol where you actually Can write into memory on another computer And this is used both from the database down into the chunk servers and to communicate between chunk servers the chunk server has both obtained disks and NVME SSD the obtained disks are used obtained memory. I mean it's used to which is a non-volatile memory it used to get a Short latency a low latency. So When you write The chunk server will have a wider head log, which it it writes to the obtain and then it can acknowledge back to the Client that the storage has been Stored and then the actual chunks will go into the SSDs But that is not inside the critical patch. You don't have to wait for that to happen before Acknowledging the write. Let's see. I think I lost my speaker note there, but I think I've said what I Yeah, the slides I have uploaded on Slide share so if you go to the rootconf Schedule and click on my presentation you will see the links to the slides Yeah, and as I said mentioned earlier, you have the the lib polar FS library that does the actually That interfaces to polar store and this runs in user space. So you don't have the overhead of context switching for for Going to storage and also there's no no system calls no Data copying you know when you do the IO so this polar store and Architecture was presented in our system article up the real to be conference last year then we go on to the next Point there in the architecture and that is the stop separation of storage and compute You want to separate storage from computation so that you can scale these independently so that you don't have to If you need more compute as we do for example for the city for the November 11 You don't have to add a lot of extra disk At the same time because you don't necessarily need more storage and This is a principle that are used by many of the cloud specific databases if you look at Amazon's Aurora for example They also separate the compute and the storage and in a sure that you have the same Good height for scale. I think it's the name of that database So the architecture is that they have the polar store and you have the polar DB On top of as I already mentioned I use is the polar fight system and on top of that we have a intelligent proxy that will wrote the request to different Replicas of the polar DB. I'll show more details on on this and this Architecture you can use with a different databases MySQL, PostgreSQL and so on. I will talk about MySQL here since that's what I know About and What we have done most work on so so Polar DB is actually a modified MySQL and mostly a modified storage engine in a DB storage engine in MySQL So what is the difference between Polar DB and a traditional? MySQL the big difference is that this When you have when you are replicating in MySQL you are sending the binary log to different Notes and they will all store their data in local storage While in Polar DB a shared storage is used There's one single master that does all the writes and then the replicas can read from From the shared storage There's several advantage of this one is the past scaling because If you need to add another replica you can just add it in a short time because you don't have to copy any data All the data is here in the state shared storage if you need to provision a new replica in my traditional MySQL architecture You would do have to copy all the data over to the local storage of the of the new replica And also since we are adding replicas, we don't have these machines we are using for the replicas don't have to have The amount of storage that you need in MySQL So as you are adding more and more replicas you see that the cost saving will increase because we can use cheaper Machines or the user can buy Machines or rent machines in the cloud with the lower capacity and still Be able to serve the replicas another difference is That in Polar DB we use physical replication if you know about MySQL replication I've heard you have heard about the bin log The jacket is actually a logical representation of the changes you are made row by row if you use row by row based replication, which you should so but that means that a Master in MySQL will do a lot or more rights because it needs to write the data to local storage It needs to write the bin log to local storage and needs to write the redo log of inner DB the physical log that you need to have to do recovery of your data and Then it sends the bin log over to the slave and the slave writes the data The bin log it received and the bid log it generates and redo log to storage So there's a lot of rights here that we can optimize by using a physical log instead because Using the redo log instead because then the master just write the data and the redo log to shared storage And the slave can just read What it needs from shared storage and one another advantage of using physical replication is Around if you do data dictionary changes and one No problem with the MySQL replication is that if you for example do an alter table that takes very long This example shows add column Then Your load it will take one hour for example to do this operation and then you send it to the to the slave and then the slave will need one hour to do the operation because the Operation is not sent to the slaves before it's completed on the master and while the slave does the operation No other load can happen on the slave because it needs to the new version of the table first But if you have shared storage, then actually The change on the slave is just a metadata update You just need to tell the slave to use the new version of of the Data files in the shared storage this example that add column is kind of a moot in 8.0 because in 8.0 MySQL added Instant add column, but there are other other The data schema change your operation that still takes a long time and that will block the the slags from Continuing so how does this actually work? I will look at the changes. We do have done to inodibi in this case so on the Let's see, you know, so this shows just one out and In inodibi, there was will be a lot of small transactions that represent each operations that are done to The the physical layout of the database that is not the same as the transaction that you have in a in At the user level it was like it's more like one time section can be to change some data in some page Sometimes some transaction will have multiple log records because for example if you do a B3 split Then you have one log record to make a new page one log record to copy data from the old page to the new page Log records to change the pointers between pages and so on So all these redo log records they are written to the redo log so and That has to happen before You commit the transaction that is what is called writer had logging and Traditionally what you do is in order to get better performances you do so-called group commit you group transaction together so that you can write multiple transaction to disk in one In one white Otherwise you if you have to write one transaction and then wait for the IO to complete and under the white another transaction It takes too long time and then the data is it's flushed asynchronously to this so if if if the node crashes then All the data pages are not necessarily up to date So when you come back up again, you have to do redo and the redo is to Take the log and then redo it on the data so it becomes up to date Because the real you have all the day log But you don't necessarily have up to date data in in the physical image on your disk when the crash happens So the idea of our physical application is that the slave or replica basically is continuously doing redo the Master works as before it writes to redo log records to Before commit writer had logging a flushes the buffer pull a console asynchronously Then on the slave the slave Will read the log records apply them To the pages Continuously what actually happens there is that there is a hash table. So you will hash on page ID for each log record And put it in because then you can do each bucket of your hash tables can be performed in parallel so you can actually do a Have efficient redo by doing all these log records in parallel because you know if they are Log records for different pages. They do not conflict. That is also the advantage of physical replication because if you have the normal bin log Replication in my scale what you know is that all the transactions that are that are in the same group commit They can you can do in parallel But you cannot then for the next group unit you have to wait until those are completed before you Do in parallel so the parallel safe session is is less with the group commit than but actually parallelizing every operation that goes to different pages so and one basic thing here is that we say that this The status of the slave is or the snapshot of the slave is the latest log record past so here the slaps state is the snapshot of T4 because T4 has been passed and Put into the hash table T5 has not yet been passed by the By the slave there's some things we need to take care of when we do it like this We have to change the inner DB to take to make sure that The master and the slaves are synchronized for example One thing I forgot to mention is that these log records They are only applied for pages that are in memory For pages that you do is referred in the redo log record But which is a slave does not have in memory. It just ignore the redo log record for now Because hopefully when it if it may later needs the page These updates have already been applied to the page on the master and flush to this so it actually sees The updates and if not, it will still have the log records and can redo it at that point In order to get it up to date to the snap T4 snapshot in this case So if for example, it read a new page from this care and it has log records Early from earlier than T4 that is not applied and it has to redo them at that point but that means that there will be a lot of log records and that are In queue here on the slave and sooner or later you will need to delete them and what you do then is That the Slave the master tells the replicas the checkpoint LSN Then a master then a database does checkpointing it writes all the dirty pages before a certain point to disk so it knows that Every every record before the log record before the checkpoint LSN. It's no longer necessary to keep because It's the pages has been written to disk so you can delete all log records that it That are earlier than the checkpoint and also There needs to be some synchronization between this the master and the slave because and The database has an underlog or rollback segments, which means that it It needs to if a transaction are in flight and then you need to roll it back It needs to find the operation so it can actually undo them and And the master must not delete and the master will delete the underlog record when it Thinks that it's not needed anymore So the replicas have to make sure that it does not delete too old Now two new two new underlog before they are finished with it because this underlog In in MySQL and Polskast and many databases uses so-called multi-version concurrency control, which means that This underlog is not only done only used for rollback It's only used to find an earlier version of a pay over page because You are a you can if you when you start a transaction You want to see this snapshot of the of the reality for the rest of your transaction So if someone later does some updates, you will actually Undo these updates for this particular transaction so that it sees a consistent view So the replicas needs to tell the master the oldest View of the current contract con con con transaction, so it doesn't a delete underlog that is newer than this So so the title of the sliver's page from the past that is that you when you read in one page And it's not up to date. You have to find the log records and and and redo them What about pages from the future? what if you there You have the snapshot of T4 is the state on on the replica here the read-only node What is the primary has written some newer version of the page to? this already and The Read-only node would read this page That is newer than a snapshot How can it get back to the old snapshot it actually need and the answer? That we need that is should not be possible. We just prevent that from happening So the all the read-only load will tell which version of the page It actually is on and to the master so the master will hold on and flushing To these pages to this gun to Their replicas are up to date So that's some of the details of the changes we are made to in or to make this for work in a shed store Physical replication So what will happen? What the set table? No more will be is that you have will have an application an Approxies and then you have a single master here and Then you have multiple replicas and you can need add as many replicas as you need And the the proxy will then do load balancing it will do read-wide split Which means that it was it can send the rise to the master and the reads to the replicas it can Do load balancing so that each replica has about the same amount of no load if if the master goes down it will be able to switch to another replica will become the master and the the the approximately make sure to vote the The update load to the new master But we also want we do read-wide split, but we also want the application to be able to see its own updates So we have to for example if we If we send the rights to the master and then we send the read a letter read for the same transaction from the same connection to to the read replica then you Must make sure that the update from the master has already been applied so that you see this see with your own updates For example here's an example that first someone updates the name of a user to Jimmy and then he commits the update and then it later Selects the name for this user ID, and then it needs to the The Application expects to see Jimmy and not some other the previous name So what we do that then is that when you do that on the master you return the log sequence number the number of the log record for this update and the real replica will make sure that You actually have this log record applied before you Respond to the To the read request and also the load balancer can be smart And if some replicas is lagging behind it can Send it to a more fresh replica So the delay in order to reap get to the right version is not that big as I said We currently only support single master But the goal is to be able to have multi multiple master because then now the update load is limited with what with what one node can process and The idea of what we are working on then is to have Multiple Availability service in multiple Availability zones and there will be a master for each availability zone and there will be redo log sent between Availability zones to update the different Database servers We also were Addressing what has during your last and I'm not sure how many of you have heard about htap Before it's kind of been popularized the last few years It stands for hybrid transaction and analytical processing The ability to do both OLTP and all that on your same system both transaction processing and analytics on your same the same system and The idea has to have special Read only loads where you do your all up Low queries so that they do not interfere with the online transaction processing But still can access the same data But assumption here with this year's storage is that the lay of the bandwidth of this source is so big that it can actually serve both purposes And This is a big advantage because you know in many systems you actually have one OLTP system Then you have to copy all your data over to some Analytics system for example, you copy it over into Redshift or through some other systems that can do your complex queries But if you can do complex queries on the same Shared storage, then you don't have to do this copying you will also get more up-to-date Data to work on because you don't have the lag of refreshing your analytics system But in order to support the OLAP with my SQL since the shell storage would have data in the inner DB Format so we actually we need to use something that understand the inner DB format here. That is my SQL okay, and So What we want to do is to be make it my SQL better to do analytics one of the problems today is that my SQL You can only have one that use a thread or one thread per user connection. So so When you get to open a connection to my SQL you get a thread and then that does all the work for this user except some IO and that the main worker of the system So what we are working on is a parallel query for but project for actually You can have multiple threads Executing a single query So then we what we do is we have one leader which is the original thread and then we use multiple worker threads that will read parts of our table or index in parallel and We are able to push down Joins aggregation filterings to these worker threads so they can do these operation on parts of the database in parallel And we see the result so far is a Pretty scaly scale Ling for some of queries like TP to feed query six, which is a single table query where you aggregate information And we see that there's some almost linear scaling here if you use 32 Workers on our 32 core machine And for pretty big data volumes like the biggest one here is TPC forum is is like 40 gigabyte Database of There's a dbt-3 is a open source version of the TPCH benchmark, which is a standard benchmark for analytic queries So the goal is to be able to do this on the same system as the old And we can also scale linear for some join some of the we have some issues with inno db and scaling on Secondary indexes in parallel. This is a known problem that has been reported by other people to that if you scan inno db secondary indexes in parallel you there's Not the linear scale so for example if you have a Secondary index or join that using secondary indexes, but the scaling is more in the order of 15 instead of 30 That you see for this query So to sum up What advantages give is that we give this architecture for databases in the cloud is first point Is that we can independently scale the storage and the compute we don't we can have Nodes that are good on compute but does not have much storage for the processing part And then you have the back end that does the storage for you and that means lower cost than adding more read replicas The shared storage has high throughput To multiple nodes low latency through the obtain Hardware you get high availability through multiple copies of the same data and Scaling fast scaling We saw that the physical replication give you less I how you don't have to write the binary log and so on You get non-blocking DDL and you got get efficient parallel redo on slaves So since you can do each page in parallel and with parallel query execution We will also get lower latency for the complex queries In this architecture So that's all I have thank you any questions, so how we handle the Split brain problem when you have the shared storage shared between master and slave both So let's say with three replicas two guys assume it like they become master and They start sending the same data to the shared storage. How we how that situation is handled in polar TV I Think you need a column and now I'm not the expert on the storage layer But as far as I understand you need a column. So if you don't have two of the copies you I don't think you can But I'm not sure how within a cluster if two guys There is a gap in communication and two guys assume as a master at some point of time because of lack of communication and the quorum went in like two guys at the same time assumed as a master then how we handle the Something like data will get corrupt in that case But if you have three nodes and you need to have connection to at least one other in order to be a master then Doesn't that solve your problem? Let's say I have five nodes and then two nodes assumed as a master in a cluster There is a communication gap within within the Within the cluster and then two master at a time assumed as a two nodes in a cluster assumed as a master I don't know the details there, but the one thing I was on the slide But I didn't mention that the graph protocol is used in order to coordinate this at the storage level and There's and they in fact they implement their own parallel raft because the original raft protocol was not efficient enough for this purpose Is there any other math? Is there any method of let's say if you are shared storage got corrupt because of some reasons How we can recover other than the snapshot way With automated backups do you take backups of the storage? Yes Yes, I think that's yeah, you take the backup of the storage level So you don't really have as a database user. I don't think that's It's visible to you. I don't have any experience in that but I don't think so because There should be sufficient Capacity in the storage layer for this. I have a question here. Yeah, so what's the largest deployment that you have in production? What's the data size? Details there, but I think there's a couple of petabytes Because one them I think so far the major motivation for moving from RDS to polar DB has been to get Around the limitation of what you can store on a single Single machine so so many of the first customers to go. It was actually to get a bigger storage for their I don't think I mentioned that part that Polo DB is was made originally for my school five six We have been up the up again merging it with eight my school eight of zero So there's a better lead release coming out soon with my school eight of zero Also, but since because of the extra hardware it has only been available in China so far But as far as I understand they are moving it to all the data centers Not sure there to Alibaba have two data centers here in India, but I don't think they it's available there yet So the scaling on my scale is to add more read replicas So that's for the read road load, right? How about the right load? Okay, so that's as I said, that's the limitation is that you only can write as much as one master can handle So if you need to go beyond that you have to shard currently the goal is to be able to support multi-master, but that I think that's That's Need some work to do also Amazon Aurora they only until recently they support the only one master in their System to they have some activity on multi masters. I'm not quite sure what they stated So would that mean that polar TV scales very well for read sort of queries and less for write sort of queries So, yeah, for why did the scale have to work one? No, but often if you can split off all the read what I read load that is often sufficient So in polar DB cluster it writes to only one master. Is it yes? Yeah, there's one master and the right school to this master and that's the only one who writes to the chair storage Okay Do we I mean polar DB handles isolation levels? Yes, that's a no difference from Usual I'm not but if you if you require for example serializability you would all your load would have to go to the master I would think but the for the lower levels you will have you can use multi-version concurrency control to actually make sure that you see the the right version of The data and then I guess you can use the synchronization I show between master and slaves Make sure that you have the same Thank you