Someone asked me what applications were good/bad for MySQL Cluster. As I’ve now actually had experience with a Cluster setup and a real-life application of it, and dug through the manual, I present a few characteristics of applications that will work with Cluster, and why they are so (so that if you have an [...]
Play or download the podcast here: http://technocation.org/content/oursql-episode-24%3A-sun-shining
OurSQL Episode 24: “The Sun is Shining”
Sun Microsystems recently announced the purchase of MySQL. In this interview the day of the announcement, OurSQL asks Brian Aker about what this means for customers, community, Sun and MySQL.
Tell us what you think of Sun buying MySQL by calling the [...]
At 2 pm EST (-5 GMT), OurSQL will be interviewing Brian Aker, MySQL’s Director of Architecture, about today’s announcement that Sun Microsystems bought MySQL.
If you have a burning question (about the purchase), please comment here. If you’d like to be identified, please leave your name and where you’re from in your comment [...]
SUN Microsystems just bought MySQL, see the announcement at http://www.sun.com/aboutsun/pr/2008-01/sunflash.20080116.1.xml
Now, MySQL isn’t going away any time soon; there are just way too many people that use it. And while Postgres is not actually owned by SUN, they do employ some great folks to develop on it, and those folks are the the “known” Postgres [...]
I was writing up some notes about a client’s status variables, and I’d had to remind myself of Handler_read_first. Handler_read_first is a counter that increments when the first entry in the index is read, which may indicate that a full index scan is being used.
With this particular client, I ran a SHOW [...]
The listing of Dynamic System Variables on the MySQL Reference Manual’s page is supposed to show those variables you can change on-the-fly.
innodb_data_home_dir is listed there as a dynamic variable, but it is not one, and trying to change it on-the-fly doesn’t work:
mysql> set global innodb_data_home_dir="/data/mysql/data";
ERROR 1193 (HY000): Unknown system variable 'innodb_data_home_dir'
mysql> set session innodb_data_home_dir="/data/mysql/data";
Patrick Galbraith, former MySQL employee who helped write replication, came to the November 2007 Boston MySQL User Group and did a fantastic presentation on replication, including showing how to set up replication and walking us through the steps in real-time, setting up an example server.
ShmooCon is an annual East coast hacker convention hell-bent on offering three days of an interesting atmosphere for demonstrating technology exploitation, inventive software & hardware solutions, and open discussions of critical infosec issues. Technocation has started the year off right by granting a FREE Shmoocon membership to a lucky high school student.
Garrett is a Junior at Maumee Valley Country Day School in Toledo, Ohio. His avid fascination with technology began at an early age, starting with an amateur radio license at 12 which was followed by a self-built computer shortly after. He has also always been interested in electronics and the like, and has the soldering iron burns to prove it. Garrett's enthrallment with computer security started in late 2005 when he became interested with wireless security practices, which spawned an unhealthy love for Linux.