Entries by Solomon K. Chang

By Solomon Chang

Table partitioning is a data organization scheme in which table data is divided across multiple files according to values in one or more table columns. Each data partition is stored separately and may even exist on separate block devices in the same server.

Many databases implementations generally don't give the administrator much control over which records are stored on a specific partition, but a user-defined partition in MySQL (5.1.6 and later) will let you specify exactly which partition a record is stored by default, based on a specific value.

In this talk, Solomon will cover:
- In which situations Table Partitioning would increase performance
- How to set up a basic Partition on a single server
- Organization schemes: hash vs. range
- Managing Table Partitions
- Determining Partition usage

Solomon Chang is a MySQL-certified DBA, and currently a Senior SysAdmin at Sosbuzz Inc., a social marketplace centered around helping people. SOSBUZZ connects buyers, sellers and causes for the benefit of all.

By Solomon Chang

Synergy is a software application for sharing a keyboard and mouse between multiple computers. It is used in situations where several PCs are used together, with a monitor connected to each, but are to be controlled by one user. The user needs only one keyboard and mouse on the desk — similar to a KVM switch without the Video.
Once the program is installed, users can move the mouse "off" the side of their desktop on one computer, and the mouse-pointer will appear on the desktop of another computer. Key presses will be delivered to whichever computer the mouse-pointer is located in. This makes it possible to control several machines as easily as if they were a single multi-monitor computer.

Synergy is able to integrate Unix, Linux, Macintosh and Windows machines, even down to the clipboard and synchronization of screensavers. Released under the terms of the GNU General Public License, Synergy is free software.

By David Rolston

In this session, Dave will walk through everything needed to create a self contained Centos based LAMP (Linux, Apache, MySQL, PHP) server which you can run on your development workstation or notebook computer. This allows you to develop for your target server platform (assuming that’s a RHEL or Centos based server) whenever you want, with or without an active Internet connection. Another advantage of virtualization is that you can set up multiple virtual servers to test out clustering and configurations that would difficult if not impossible to simulate using one server. Dave will cover prerequisites, gotchas, and walk through the building and setup of the VM.

David Rolston is a Los Angeles based system developer who has worked for a variety of entertainment and game companies including Paramount Pictures, Broderbund software, and Vivendi Universal Games. He has focused most of his recent efforts on LAMP and is one of the founders of LampSIG. He contributes to a number of open source projects including Joomla, and is the project lead of a popular Joomla gallery component called PonyGallery.

This meeting will be for the discussion of booth topics for SCALE 8x.

By Solomon Chang

MySQL Replication has been a standard practice of scaling and failover for a long time, but what happens when you need to set up replication that routes through an insecure network? You have two options: you can either eliminate everyone you do not trust on that insecure network in the messiest way possible, or you create your own home grown SSL certificate and use that to encrypt all database traffic. In this talk, Solomon will teach the boring way that doesn't send you to jail, while providing an overview of setting database replication for those who may have missed it in earlier LAMPSIG meetings.

When he is not deliberately scheduling LAMPSIG meetings to conflict with Rosh Hashanah *and* Shabbat, Solomon is a professional DBA in Glendale and bears the guilt of being a co-author of the MySQL Cluster Certification Study Guide. He is MySQL-certified, although his mother really wishes he would have become a doctor or a lawyer instead, and settle down with a nice Jewish girl.