Oracle’s MySQL Tech Tour – Portland
December 11, 2013, Portland
Please join us in Portland for our tech event hosted by Oracle’s MySQL experts and learn more about Oracle’s strategy and continued investment for MySQL.
More details and registration »
Oracle’s MySQL Tech Tour – Seattle
December 12, 2013, Seattle
Please join us in Seattle for our tech event hosted by Oracle’s MySQL experts and learn more about Oracle’s strategy and continued investment for MySQL.
"It is better to keep silence and be thought a fool, than to say 'tuple' and remove all doubt."
But recently people have been using the word "tuple" more frequently. Doubtless all those people know that in relational databases a tuple (or a tuple value) is a formal term for a row of a table. It's possible to know a bit more than that.
Pronounced Tyoople, Toople, or Tuhple?
The Oxford Dictionaries site says Tyoople. Other dictionaries are neutral about the terms from which Tuple was derived (sextuple, octuple, etc.), for example Merriam-Webster says they usually end in Toople but Tuhple is an accepted alternate, and the Oxford Canadian Dictionary says …
[Read more]
Heads up that Friday (6th December) is your last chance to submit
a 30 minute session proposal for next year’s MySQL & Friends
Devroom at FOSDEM. I presented last year and I was really
impressed by the number of attendees, the organisation and the
positive reception (I’ll be there again next year – hopefully
presenting). If you’ve got a MySQL-related topic that you’d like
to present to an enthusiastic open-source community then this is
a agreat opportunity.
Submit your proposal(s) for a 30 minute session here.
FOSDEM 2014 is free event running in Brussels over the weekend of 1st & 2nd February, with the MySQL content aimed for the Saturday. This is a huge event (5,000+) and has a great, …
[Read more]I get a lot of questions about Percona XtraDB Cluster 5.6 (PXC 5.6), specifically about whether such and such MySQL 5.6 Community Edition feature is in PXC 5.6. The short answer is: yes, all features in community MySQL 5.6 are in Percona Server 5.6 and, in turn, are in PXC 5.6. Whether or not the new feature is useful in 5.6 really depends on how useful it is in general with Galera.
I thought it would be useful to highlight a few features and try to show them working:
Innodb Fulltext Indexes
Yes, FTS works in Innodb in 5.6, so why wouldn’t it work in PXC 5.6? To test this I used the Sakila database , which contains a single table with FULLTEXT. In the sakila-schema.sql file, it is still designated a MyISAM table:
…[Read more]In recent time, MariaDB 10 has been getting many new storage engines. We’ve seen TokuDB, CONNECT, SEQUENCE, SPIDER, CassandraSE for various use cases. For a long time, MariaDB shipped OQGRAPH, but it was disabled in MariaDB 5.5. It will make a come back as OQGRAPH v3 has been worked on actively by Andrew McDonnell. Keep track of this via MDEV-5319.
Another engine being worked on by Kentoku Shiba & team is the mroonga engine, which allows you to do full text search. It is optimised for CJK languages, and is supposedly very fast. To track this, follow …
[Read more]Thousands of people have testified to the value of the Oracle Certification Program as follows:
You have until December 21st to take the new MySQL Server 5.6 Certification exams in their beta form. A reminder of what is on offer:
Until December …
[Read more]Another month has come to an end. If you’re looking to be updated on MariaDB content on a regular basis, don’t forget to be on Twitter (@mariadb), Facebook (MariaDB.dbms), or Google Plus (+mariadb).
There was a question on Quora – Is Facebook considering ditching MySQL in favor of MariaDB like Google did? The best answer really comes from Harrison Fisk, so I’ll leave you to it to read. The older link made its way on social media about Wikipedia_$ mv MySQL MariaDB. …
[Read more]This is an incomplete fragment from 2011. Figure its worth publishing this now, considering MariaDB is likely to get groonga in the near future. The groonga team have released MariaDB 10.0.6 binaries as well. This is all part of the mroonga project.
These were my quick notes from the groonga talk at the O’Reilly MySQL Conference & Expo 2011. I haven’t tried it yet (and don’t know if it really is faster than Sphinx), but its something I definitely want to play with. Maybe even get a MariaDB tree going.
groonga is a fulltext search library for cloud & web.
groonga is easy to embed & is scalable. It is written in C.
Highly precise search for …
[Read more]
For my 25 readers (Italians would know better, citing The Betrothed by Alessandro Manzoni): if you are a techie and you
do not know me , you can stop reading. No tech tips inside, nor 5
gazillion queries per second improvement in this post,
sorry!
On the other hand, if curiosity is what drives you through the
posts of PlanetMySQL you may find bits in this post
of some interest, or even helpful.
Few days ago I opened my blog and found the last post, dated April 2013. It was a
reminder for the readers that the OpenStack Summit …
Using disk snapshots to perform MariaDB backups has become more and more
common, but this seems to have been limited to Linux and Cloud
environments. There seems that there has been a notion that
Snapshots cannot be done on native Windows, the way we can do
snapshots using LVM on Linux for example. This is actually False,
if you use the NTFS filesystem snapshoting is built in and has
been so for a long time, the base for it is the Volume Snapshot
Service (VSS) which was introduced as far back as Windows
XP.
Using Snapshots to backup on Linux or Windows works well,
assuming that the storage engine you use can recover on startup,
the backups created this was are physically consistent but not
logically, but InnoDB will recover this. Also note that any
warnings about using snapshots with MyISAM also applies to the
mysql database, i.e. the database metadata. Usually
though, this …
