PlanetMysql.ru — информация о СУБД MySQL

Been asked a few times in the last few days about where my slides are from my MySQL keynote from *last* year.

Ooops.

Um, yeah.  Sorry about that.  Here’s a link to ‘The SmugMug Tale’ slides, and you can watch the video below:

Sorry for the extreme lag.  I suck.

The important highlights go something like this:

• Use transactional replication.  Without it, you’re dead in the water. You have no idea where a crashed slave was.
• Use a filesystem that lets you do snapshots.  Easily the best way to do backups, spin up new slaves, etc. I love ZFS.  You’ll need transactional replication to really make this painless.
• Use SSDs if you can. We can’t afford to be fully deployed on SSDs (terabytes are expensive), but putting them in the write path to lower latency is awesome.  The read path might help, too, depending on how much caching you’re already doing.  Love hybrid storage pools.
• Use Fishworks (aka Open Storage) if you can.  The analytics are unbeatable, plus you get SSDs, snapshots, ZFS, and tons of other goodies.
• Use transactional replication. This is so important I’m repeating it.  Patch it into MySQL (Google, Facebook, and Percona have patches) or use XtraDB if you use replication.  We use the Percona patch.

Holler in the comments if something in the presentation isn’t clear, I’ll answer.  Apologies again.

Shameless plug - we’re hiring. And it’s a blast.

PlanetMySQL Voting: Vote UP / Vote DOWN

In line with my prediction from few days ago, Larry Ellison is announcing the new Database Machine — the new version is targeting OLTP workloads and is based on Sun hardware. Looks like I just got the date wrong. Oh well, now is the announcement, hype and demo is at the Oracle Open World and shipments are to start upon Oracle-Sun acquisition completion.

So what’s new in Exadata that I didn’t mention in the previous blog post? Ah, right — Sun FlashFire technology. It’s no surprise that the new OLTP version of Database Machine is boosting the IOPS (IO’s per second) capacity by introducing the flash drives. Nothing prevented Oracle to place flash disks into the original Exadata, not from technology perspective.

You should also know that Sun has been investing a lot in its Open Storage concept. This is very similar to what Oracle did with Exadata Server except that Sun initiative is a universal storage solution with ZFS in its core while Oracle Exadata is specialized for Oracle databases leveraging Oracle ASM. What does it tell me? Two leading companies have the opportunity to merge storage technologies. I’ll take that!

I might have underestimated Oracle on how quickly it can leverage Solaris SPARC for the database servers in the OLTP Database Machine (Mark, you might be right). SPARC platform has been an excellent fit for high throughput OLTP systems. Again, we already saw Larry’s commitment to develop SPARC technology so within a month, Sun customers’ mood should be rising higher and higher these days.

I will excuse myself for self-quoting from half a year ago:
… it does look like Sun failed to make money on a number of great technologies and products such as Solaris and Java. Why is another story — there were great deal of speculations from people who must know it much better than me. My conclusion is that IBM is a great money making machine while Sun is the technology making machine.

What about Oracle? Well, I think that so far they have excelled in both - money making and technology making. Isn’t that a wonderful combination?

I must say I’m excited to see that Oracle is picking up all the juicy pieces of Sun technologies and targets to make money on them and not sell them off in bits.

PlanetMySQL Voting: Vote UP / Vote DOWN

The following links load a flash file that will report what version is installed for Adobe Flash and Adobe Shockwave.

Source: Version test for Adobe Flash Player

Source: Test Adobe Shockwave & Flash Players

PlanetMySQL Voting: Vote UP / Vote DOWN