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 [...]
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]
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!
The project eventually wants to move the 10.0, 5.5, 5.3, …[Read more]
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.
where we talked about Oracle toolsmysqldbcompare and
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.
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.
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 [...]
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]
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.[Read more]
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 [...]
Recently, MySQL 5.6 was added to the dotdeb repository. On the surface, this is a very harmless addition. MariaDB is a replacement for MySQL and it should be possible for applications designed for MySQL to easily switch to MariaDB. Therefore MariaDB also includes the libraries that applications using MySQL depend upon, such as libmysqlclient18 and mysql-common. The dpkg package manager looks at the MySQL 5.6 packages in dotdeb and assumes that 5.6 is a higher version than 5.5, which results in it removing or replacing libraries during normal apt-get installation and upgrade procedures.
The problems appear in the following scenarios:
- apt-get install mariadb-server-5.5 …