Want to use C#/.NET with Sphinx? This blog post will tell you how to do it. Check it out. Sphinx with C#/.NET Here are your options: use SphinxSE. This option makes sense only if you already use MySQL server and you want to use Sphinx via the MySQL server… It has it’s advantages and disadvantages. [...]
The MariaDB project is pleased to announce MariaDB ODBC Driver Beta – the start of the public beta testing phase of MariaDB ODBC Driver
MariaDB ODBC Driver is a standarized database driver for Windows platforms. It supports ODBC Standard 3.5 and can be used as a drop-in replacement for MySQL Connector/ODBC.
Maria ODBC Driver is licensed under the LGPL license. It is compatible to MySQL Connector/ODBC and supports both Unicode and ANSI mode.
MariaDB ODBC Driver is build on top of the MariaDB LGPL C library and uses binary prepared statement protocol for client server communication.
For more information please visit the MariaDB ODBC Driver page
The MariaDB project is pleased to announce a special preview release of MariaDB 10.0.9 with significant performance gains on FusionIO devices. This is is a beta-quality preview release.
The latest work between MariaDB and FusionIO has focused on dramatically improving performance of MariaDB on the high-end SSD drives produced by Fusion-IO and at the same time delivering much better endurance for the drives themselves. Furthermore, FusionIO flash memory solutions increase transactional database performance. MariaDB includes specialized improvements for FusionIO devices, leveraging a feature of the NVMFS filesystem on these popular, high performance solid state disks. Using this feature, MariaDB 10 can eliminate some of the overhead within the InnoDB storage engine …[Read more]
On Thursday MySQL technology saw a huge boost. It’s hard for anyone now to argue that MySQL isn’t in the game of extreme scalability and performance, which some NoSQL vendors have been using as a tagline for the last years. To see four of the largest MySQL and MariaDB users come together to bootstrap a branch of MySQL for extreme scaling needs is simply fantastic. The improvements done inside these companies will now be available to the rest of the community. In all fairness Facebook and Twitter, in particular, have been making their improvements publicly available also before. Google has also made some improvements available publicly over the years and have lately been active in the MariaDB project with code reviews, bug fixes and other patches. But broadening the public contributions further and combining it all, is new.
Engineering of MySQL technology happens in many places. Aside from Oracle and the companies behind WebScaleSQL, …[Read more]
MariaDB 10 is nearing GA, and it makes sense to make sure that the test suite from MySQL 5.6 is merged into MariaDB 10. Svoj is doing a lot of this work, and then we like to look at features, especially ones that are deprecated upstream. We don’t do that on blogs, but on the maria-developers mailing list.
I bring to your attention: Intermediate status for test cases merge. We see that INSERT DELAYED and SHOW PROFILE for example are deprecated in MySQL 5.6. The only way for feedback to the MySQL team seems to be comments on Morgan’s blog. However with MariaDB, especially with the feedback plugin enabled, we have an additional layer of …[Read more]
Eventual consistency is a consistency model used in many large distributed databases which requires that all changes to a replicated piece of data eventually reach all affected replicas; conflict resolution is not handled and responsibility is pushed up to the application author in the event of conflicting updates .
Eventual consistency is a specific form of weak consistency; the storage system guarantees that if no new updates are made to the object, eventually all accesses will return the last updated value . If no failures occur, the maximum size of the inconsistency window can be determined based on factors such as communication delays, the load on the system, and the number of replicas involved in the replication scheme .
A few examples of eventually consistent systems:
- Asynchronous master/slave replication on an RDBMS e.g. MariaDB
- memcached in front …
A MariaDB Howto authored by: Erkan Yanar.
This is a Howto about installing MariaDB Galera Cluster on
Debian/Ubuntu. Because a lot of people were having problems
installing MariaDB Galera Cluster, elenst from
#maria on freenode forced me to write this Howto
Installing MariaDB Galera Cluster is in fact quite easy and actually kind of boring in the end. This Howto is written for (and tested on) on Debian 7.1 (Wheezy) and Ubuntu 12.04 (Precise).
What we need
In our setup we assume 3 nodes (node01, node02, node03) with one interface each. We assume following IP addresses: 172.16.8.5, 172.16.8.6, and 172.16.8.4. We need three packages installed on all nodes:
As Galera does not ship with the distribution repositories, go for the …[Read more]
In this blog post, we’ll talk about how Jobma improved search for their users by switching from MySQL fulltext search to Sphinx. Enjoy! What is Jobma? Jobma is a new job portal based solely on Video Resumes, which permits job seekers to quickly and directly reach potential employers. The hiring process is easier with the help [...]
I've been letting the blog rest recently, and not so recently as
well. The problem is not a lack of subjects, but a lack of
time to do them any justice. However it is quite sad to see
that my last entry was in September 2012, so it is time to post
Of late I have been pondering what I have to say about :
- Distributed MVCC and write-scaling
- Different approaches to eventual consistency with replicated RDBMS
- Various MySQL Cluster related topics
- Various general rambling and unstructured topics
However, these will take some time to percolate and
In the meantime here are some things I have found interesting recently :
You Some Erlang for Great Good
I actually rediscovered this online book after watching some …