Here are a few videos those of you who are just getting started with Sphinx may find useful. The first video demonstrates a very simple implementation with Ubuntu, PHP, and MySQL. The second video is also about installing on Ubuntu. And, the last video discusses fulltext query syntax. Check ‘em out. Quick Start with Ubuntu [...]
Jun
26
2014
Jun
21
2014
If you would like to see how to set up autocomplete and correction suggestion with Sphinx, PHP, MySQL, and jQuery, take a look at this. This quick video will walk you through the steps of setting up the autocomplete example that we wrote about a while ago. For details on how the whole process works, go [...]
Jun
03
2014
The following sentence is brought to you by IBM Legal. The postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions.
Okay, now that is out of the way….
If you’re the kind of person who follows the MySQL bugs database closely or subscribes to the MySQL Internals mailing list, you may have worked out that I’ve spent a small amount of time poking at MySQL on modern POWER systems.
Unlike Intel CPUs, POWER CPUs require explicit memory barriers to synchronize memory state between different CPUs. This means that when you’re implementing synchronization primitives, you have one extra thing to get …
[Read more]
May
27
2014
Today marks a milestone in terms of the MariaDB project – going forward, the MariaDB project plans to use Github and git for source code management. The migration happens from Launchpad and the bzr tool.
The 10.1 server development (under heavy development now) will happen on Github. You can check it out here: https://github.com/MariaDB/server. Feel free to watch, star or even fork the code, and send us contributions!
Previous maria-captains should now provide their Github IDs so that they can be accorded similar status. Send the IDs to the maria-developers mailing list.
The project eventually wants to move the 10.0, 5.5, 5.3, …
[Read more]
May
20
2014
This week we discuss pt-table-checksum for keeping data in sync. Ear Candy is a rational look at why one company chose MySQL; At the Movies is using MySQL in a practical way for Big Data.
pt-table-checksum
pt-table-checksum
pt-table-sync
Episode 151,
where we talked about Oracle toolsmysqldbcompare and
mysqldiff
Options discussed:
--replicate, --no-create-replicate-table
May
12
2014
This week we discuss more Percona tools: pt-online-schema-change and pt-slave-find. Ear Candy is using the CONNECT storage engine to read GPX files, and At the Movies is Performance at Scale with TokuDB.
Events
DB Hangops -
every other Wednesay at noon Pacific time
OSCon 2014 at the Oregon Convention Center in Portland, Oregon from Sunday July 20th through Thursday July 24th.
Training
SkySQL Trainings
May
07
2014
Many Sphinx users utilize MySQL as a data source. Divendo is one of them. This blog post will relay the story of how Divendo got going with Sphinx after MySQL fulltext search became unwieldy. Enjoy! Divendo Divendo is a meta-search engine for classified ads serving the following continents and countries: Europe: Spain, Italy, Portugal, United Kingdom Americas: Mexico, Argentina, Brazil, Chile, Colombia, Peru, Venezuela Asia: India Australia [...]
May
06
2014
This is the blog of the MariaDB Foundation in particular and the MariaDB project in general. It is used to announce new MariaDB versions, for posts from MariaDB developers about new features, and for news from or about the MariaDB Foundation itself, among other things. For many this is the MariaDB blog, and on behalf of the MariaDB Foundation, welcome! We’re glad you’re here. Thanks for stopping by!
What you may not know is that there’s another MariaDB blog over at https://mariadb.com/blog run by the fine folks at SkySQL (full disclosure: I work for SkySQL, but my posts here are on behalf of the MariaDB project and the Foundation). This other MariaDB blog contains posts about SkySQL’s commercial MariaDB offerings (naturally) but also a lot of other …
[Read more]
Apr
29
2014
In January I wrote my first post about node.js and MariaDB . In February I continued with a second post about using jQuery and some GIS calculations. Now it is time for the third and this time the main focus is not so much on GIS functionality, but instead on the capabilities MariaDB has for handling piles of unstructured data. In this case I’ll be focusing on crunching a pile of XML files without importing the XML data itself.
MariaDB 10.0, which had its GA launch in early April, includes the Connect engine. It has been developed to dynamically access all …
[Read more]
Apr
21
2014
This blog post features a quick and interesting story from James (from ActionMessage), an early adopter of Sphinx. We met him at Percona Live: the MySQL User Conference, a few years back. This year, we asked if he would like to share his story with our community. Here it is. Enjoy! “I’m James Briggs from ActionMessage [...]