Ruby on Rails is hot technology. Its got the essence of Web 2.0 written all over it, right?

Seeing that it supports MySQL out of the box, we like it. We of course want to enhance our support of the Ruby on Rails team, and make sure the RoR users have a rocking time.

As a consequence of this, I’ve been playing with RoR, and will definitely write up more thoughts here at some stage. This is just a quick note to mention that I’d be going to the Silicon Valley Ruby Conference, from April 22-23 2006. Anyone else plan on being there?

We’ve published the first few episodes of the weekly MaxDB series in .pdf form. Please take a look and let us know what you think!

MySQL AB :: The MaxDB series on PlanetMySQL.

© cjcollier for C.J.'s WordPress of studlyness, 2006. | Permalink | No comment

Add to del.icio.us

Search blogs linking this post with Technorati

Want more on these topics ? Browse the …

No, we didn’t forget about Make MySQL 5.1 Rock contest. We were just migrating our bugs database, and going through a little teething problems everytime a Monday hit! (yes, I’ve not been taking them for myself in the last two weeks!) The good news is that, you get an additional fortnight to win yourself an iPod Nano.

This week’s winner is none other than Mike Kruckenberg. He’s submitted a bunch of bug reports, in relation to MySQL Cluster (another hot topic these days), and one that caught my eye was a critical server crash (mysql#18603). He also blogs about his day spent with MySQL 5.1, which is a fun read.

If …

To find a list of tables in a schema:

$ sqlcli -u TEST,TEST -d SYNCMANA "SELECT * FROM TABLES WHERE SCHEMANAME = 'TEST'"

To find a list of triggers on a table:

$ sqlcli -u DBSERVICE,SECRET -d SYNCMANA "SELECT * FROM TRIGGERS WHERE TABLENAME = 'T'"

To describe a table’s structure:

$ cat me && echo "-----" && 
   loadercli -d SYNCMANA -u TEST,TEST -b ./me && echo "-----" && 
   cat tabledef.txt
dataextract for dataload table T
outstream file 'tabledef.txt'
outstream file 'idontcare'

-----
Loader protocol: '/home/cjcollier/.sdb/loader/log/loader.prt'
Loader packages: '/home/cjcollier/sdb/loader/packages'

User TEST connected to database SYNCMANA schema TEST on local host.
dataextract for dataload table T
outstream file 'tabledef.txt'
outstream file 'idontcare'
Successfully executed

-----
//
CREATE TABLE "T"
(
        "I"  Integer  NOT NULL,
        "C"  Varchar (32) UNICODE,
        PRIMARY …

Earlier this week, I wrote about the Synchronization Manager and gave a step-by-step tutorial on getting an initial scenario implemented. In this article, I’ll expand on the previous tutorial by introducing the concept of uni-directional synchronization.

Uni-directional participants act as destinations for replicated data. These participants are sometimes called “slaves,” because they are not capable of replicating changes to other members of the synchronization scenario. Theoretically, any RDBMS that provides an appropriate JDBC interface can participate as a replication destination with little effort on the part of the DBA. As an example of this, I have documented my experience creating a uni-directional MySQL participant.

One situation DBAs might use databases synchronized as uni-directional participants is when they want to provide information to clients …

This is a follow-up to my earlier article on the MaxDB Synchronization Manager. In the months since my prior article, the Synchronization Manager has proved itself production ready and capable of replicating real-world databases in demanding scenarios.

Take the following as theoretical and emperical examples of such scenarios (not necessarily in that order):

i) For its yearly trade show, a company needs to process user registration. Because of the high volume of attendees, there must be more than one system through which registration takes place. Therefore, the registration software is to run on multiple separate laptops. At the end of each day, the laptops synchronize their registration information with each other and a master registration database.

ii) In order to reduce human error and increase efficiency, a grocery store …

I spent a bit of time today organizing myself for a bunch of trips next month.

Contrary to my blog posting earlier, I will be at the MySQL Users Conference 2006, which is on the 24th-27th April. But I’m getting into San Francisco in the week before, so if you’re up to meeting me, don’t hesitate to drop me a line. I have a feeling that I’ll actually be staying in Santa Clara as opposed to San Francisco proper, but there should be public transport, right?

I should also be with my colleague, Arjen, who’s speaking at the Free OSS Forum Day, organized by Open Source Tasmania. He tells me that Pia should also be there, which should rock. So Hobart, here I come on …

Yes, MySQL 5.1’s new Partitioning feature definitely is a hot topic. Last week’s iPod Nano winner won thanks to interesting partitioning happenings, and this week’s one wins for the same reason.

With that, here comes a hearty congratulation to Jeremy Cole, who’s won himself an iPod Nano!

Jeremy’s been a long-time MySQL user, a one-time employee, and a great help on the mailing lists. In trying out new features in MySQL 5.1, he stumbled upon several bugs, one of which has been fixed. Again, the idea of repeatable bug reports is tantamount to how quickly a developer can fix a problem. (mysql …

This was an honor, but I must decline. We already have such an "ambassador." Thank you, Miguel.

14:15 <@miguel2> What is MaxDB?
14:15 <@tjfontaine> http://en.wikipedia.org/wiki/MaxDB
14:16 < cj> miguel2: it was written in pascal in the mid 70s.  it's a
            pre-relational database with all sorts of features [added] on
14:16 <@miguel2> Wait, is that a different DB?
14:16 < cj> miguel2: yep
14:16 <@miguel2> So its not MySQL?
14:16 < cj> miguel2: nope
14:16 <@miguel2> That is crazy talk
14:16 <@miguel2> crazy
14:17 <@miguel2> I dontbelieve you
14:17 < cj> miguel2: heh, okay.  MySQL doesn't have *any* pascal code
in the
            kernel, afaik
14:19 <@miguel2> Who uses that?
14:19 <@miguel2> So why dont they pay you to hack on Mono?
14:19 < cj> miguel2: that's something I'd like to know :)
14:19 <@miguel2> We need a firm MySQL commitment to Mono
14:19 …

I'm pretty excited about this event, and I'm really disappointed that I'm not going to be able to go. :(

http://mysqluc.com/

Tim, I really will meet you in person one of these days...