BIO: Andrew Aksyonoff is a Russian geek who created Sphinx back in 2001 and has been working on the code base ever since. Fluent in C++, less so in human speak, but keeps trying. He lives in Russia.
TOPIC: Sphinx Just how do you implement keyword search through that 10-million-row InnoDB table? Meet Sphinx, a blazing fast open source engine that makes it a breeze. We'll talk about what it is, how it works, and when and why use it.
INTERESTING FACT: Meetup search is powered by Sphinx.
NOTICE: Andrew will be in Los Angeles for a couple of days around this event. If your site needs robust search, send an email to the organizers of this meetup to make an appointment to meet Andrew in person if you are interested to learn more.
BIO: Giuseppe Maxia is the MySQL community team lead. A system analyst with 20 years of IT experience, he has worked as a database consultant and designer for several years. He is a frequent speaker at open source events and the author of many articles. He lives in Sardinia (Italy).
TOPIC: Make your own database testing machine with MySQL Sandbox MySQL Sandbox is an open source project created in Perl, designed to install painlessly and quickly several instances of MySQL database server and tools. Using the Sandbox, you can install one server in just a few seconds, a complex replication system in less than 20 seconds, and dozens of database instances, on the same server, independent from one another. If you need to compare the behavior of a replication system in[masked] against[masked] and 6.0.9, fear not. Installing the replication systems is a matter of seconds. Using them is as easy as to say “use”, without need of remembering complex command line options. The Sandbox is a toolkit creator that gives the user all the handles to manipulate data quickly and securely. Advanced users can recreate complex configurations with simple options. Circular and standard replication, nested master/slave tree structures, group of mixed version servers, all are at your fingertips with MySQL Sandbox. This session will explain how the Sandbox works, and will illustrate with examples how to test simple and complex database cases with ease.
BIO: Sheeri K. Cabral Sheeri K. Cabral has a master’s degree in computer science specializing in databases from Brandeis University. She has background as a systems administrator; has worked with Oracle, Sybase, DB2, Solaris, RedHat/Fedora, AIX, and HP-UX. Unstoppable as a volunteer and activist since age 14, Cabral founded and organizes the Boston, Massachusetts, USA, MySQL User group, and co-wrote The MySQL Server Administrator’s Bible, to be published in May 2009.
TOPIC: Ready for the death defying leap from MySQL 5.0 to 5.1? What’s new in MySQL 5.1? This version introduces features that can change your database usage experience dramatically.
- Partitions can improve performance of large tables up to 20 times;
- Row-based replication offers more stability and reliability to most applications;
- The event scheduler offers a portable and easy way of setting recurring tasks;
- Dynamic logging makes the administrator life easier.
In short, MySQL 5.1 is a mature product that waits to be exploited. Released in November 2008, it is now quickly becoming the database of choice of most MySQL users. To take advantage of the new features, you should know where and how to use them. This session will guide the users through the new features, explaining how they work, when to use them, with real like examples. PARKING:
1. The meeting room is called "Martinique". 2. Try to arrive on time as a Sun badged employee will need to operate elevators to get you up to the 10th floor. 3. If you do arrive late, call Joe at[masked] so we can have someone come down and escort you up. 4. There is a visitor's parking lot. Last couple of times the parking was free but we can't guarantee it. In case you absolutely don't want to pay, there is free parking on the street.