Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 1015 Next 30 Older Entries

Displaying posts with tag: General (reset)

ActionMessage Email Marketing – Powered by Sphinx Search
+0 Vote Up -0Vote Down
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 [...]
Dotdeb repository problems with MariaDB 5.5 (solution)
+0 Vote Up -0Vote Down

Dotdeb is a repository currently targeting Debian and Ubuntu, providing a nice set of packages for LAMP servers.

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:

  [Read more...]
Advanced Search with MySQL and Sphinx
+0 Vote Up -0Vote Down
We had a great time at the MySQL user conference (Percona Live) and now, in this post, we’d like to share the talk we gave about how to deliver ultra-fancy search with Sphinx. This year’s talk was delivered by Vladimir Fedorkov (of Blackbird) and Andrew Aksyonoff (creator of Sphinx). If you missed Percona Live (or [...]
MariaDB Client Library for C 2.0 and Maria JDBC Client 1.1.7 released
+1 Vote Up -0Vote Down

The MariaDB Foundation is pleased to announce the releases of MariaDB C Client Library 2.0 and MariaDB JDBC Client 1.1.7

The MariaDB Client Library for C 2.0 is a major release which contains more than 70 bug fixes and a lot of new functions and features, e.g.

  • SSH support
  • Dynamic Columns API
  • Support for MinGW and Objective/C
  • Read-ahead cache

…and much more!

For a complete list of all new features please visit MariaDB Client Library for C 2.0.0 Release Notes

We are very proud for getting a tremendous amount of contributions: bug reports, ports, patches and suggestions which helped

  [Read more...]
SphinxQL and the MySQL .NET connector
+0 Vote Up -0Vote Down
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. [...]
New kid on the block: MariaDB ODBC Driver 0.9.1-beta
+1 Vote Up -0Vote Down

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

Significant performance boost with new MariaDB page compression on FusionIO
+0 Vote Up -0Vote Down

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.

Download MariaDB 10.0.9-FusionIO preview

Background

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

  [Read more...]
MariaDB and WebScaleSQL
+2 Vote Up -0Vote Down

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

  [Read more...]
Merging 5.6 test cases and thoughts on feature deprecation in MariaDB 10.0
+1 Vote Up -0Vote Down

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

  [Read more...]
MariaDB Eventually Consistent?
+0 Vote Up -0Vote Down
Background

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 [13].

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 [14]. 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 [3].

A few examples of eventually consistent systems:

  • DNS
  • Asynchronous master/slave replication on an RDBMS e.g.
  [Read more...]
Installing MariaDB Galera Cluster on Debian/Ubuntu
+1 Vote Up -0Vote Down

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:

  • rsync
  • galera
  • mariadb-galera-server

As Galera

  [Read more...]
Case Study: Sphinx@Jobma
+0 Vote Up -0Vote Down
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 [...]
Reports exaggerated
Employee +1 Vote Up -0Vote Down
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 again.

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 calcify.

In the meantime here are some things I have found interesting recently :






  [Read more...]
Ghosts of MySQL Past, Part 7: PBXT
+0 Vote Up -0Vote Down

Recently, I’ve been writing based on my linux.conf.au 2014 talk, which you can watch the recording of. Also see Part 1, Part 2, Part 3, Part 4,

  [Read more...]
Auto increments in Galera
+0 Vote Up -0Vote Down

Lets start by considering a scenario where records are being inserted in a single auto-increment table via different nodes of a multi-master cluster. One issue that might arise is ‘collision’ of generated auto-increment values on different nodes, which is precisely the subject of this article.

As the cluster is multi-master, it allows writes on all master nodes. As a result of which a table might get same auto-incremented values on different nodes on INSERTs. This issue is discovered only after the writeset is replicated and that’s a problem!

Galera cluster suffers with the similar problem.

Lets try to emulate this on a 2-node Galera cluster :

1) On node #1:

MariaDB [test]> CREATE TABLE t1(c1 INT AUTO_INCREMENT PRIMARY KEY, c2 INT)ENGINE=InnoDB;
Query OK, 0 rows affected (0.07 sec)

MariaDB [test]> START TRANSACTION;
Query OK, 0
  [Read more...]
Use Sphinx with MySQL
+0 Vote Up -0Vote Down
In this blog post (which was inspired by Adrian Nuta’s recent talk about Sphinx at FOSDEM), we go through some more of the differences between MySQL fulltext search and Sphinx. People frequently ask us questions along these lines, so we decided another blog post on the subject would be worthwhile. Check it out! Introduction This [...]
jQuery and GIS distance in MariaDB
+0 Vote Up -0Vote Down

I’ve continued building on my MariaDB GIS and node.js example application that I wrote about two weeks back, https://blog.mariadb.org/node-js-mariadb-and-gis/. The application shows how to load GPX information into MariaDB, using some MariaDB GIS functionality, and making use of the node.js platform together with MariaDB’s non-blocking client.

With the GPX data converted into GIS points in the MariaDB database, I wanted to further expand a little on both the GIS aspect and also look at how some additional data could be shown in the application by using jQuery’s Ajax calls to update a piece of the web based application UI.

To start with, an interesting thing to do when you have a bunch of GIS

  [Read more...]
Ghosts of MySQL Past: Part 3
+0 Vote Up -0Vote Down

See Part 1 and Part 2.

We rejoin our story with a lawsuit. While MySQL suing Progress NuSphere is not perhaps the first GPL lawsuit that comes to mind, it was the first time that the GPL was tested in court. Basically, the GEMINI storage engine was a proprietary storage engine bundled with a copy of MySQL. Guess what? The GPL was found to be valid and GEMINI was eventually GPLed, and it didn’t really go anywhere after that. Why? Probably some business reasons and also, InnoDB was actually rather good and there wasn’t a lawsuit to enforce the GPL there, making

  [Read more...]
Ghosts of MySQL Past: Part 2
+0 Vote Up -0Vote Down

This continues on from my post yesterday and also contains content from my linux.conf.au 2014 talk (view video here).

Way back in May in the year 2000, a feature was added to MySQL that would keep many people employed for many years – replication. In 3.23.15 you could replicate from one MySQL instance to another. This is commonly cited as the results of two weeks of work by one developer. The idea is simple: create a log of all the SQL queries that modify the database and then replay them on a slave. Remember, this is

  [Read more...]
Select into outfile and load data infile are not complementary by default
+1 Vote Up -0Vote Down

Configuring the character set for MySQL is confusing. It is so confusing that there are roughly 25 different places to configure a character set. Don’t believe me? Add them up. The real number may be closer to 30. I realize a lot of this is due to the age of MySQL and the extent of it’s character set support. MySQL does support character set configuration in many different places which is usually a good thing.

I often complain about defaults that make no sense like lock_wait_timeout=1 year. In this case there is a default that makes absolutely no sense to me. The manual says that select into outfile is the complement of load data infile. It isn’t completely true. They differ in one key aspect, the default character set!. By default select into outfile now does the right thing by using binary character set and

  [Read more...]
Node.js, MariaDB and GIS
+1 Vote Up -0Vote Down

The availability of the node.js binding for MariaDB’s non-blocking client library together with the GIS capabilities of MariaDB inspired me to make an example of using node.js and MariaDB to import so-called GPX tracks to a MariaDB database and then show them on a map. GPX tracks are what are stored by many GPS devices including running watches and smartphones.

My project makes use of MariaDB’s non-blocking client library together with the node.js platform and on top of that uses the GIS functionality found in MariaDB 5.5 and 10.0.

To start with let’s go through the software and components I’m using:

  • Node.js – The popular Node.js platform built on Chrome’s JavaScript runtime. An event-driven and non-blocking
  [Read more...]
What do you want to see in MariaDB 10.1?
+2 Vote Up -0Vote Down

Last night, after my previous blog post, everyone in attendance at the SkySQL developer meeting in Barcelona gathered for dinner at El Cangrejo Loco, which, if my High School Spanish is working, translates as The Crazy Crab. After the excellent food, the tradition of singing at MySQL/MariaDB developer meetings was preserved.

Today the MariaDB developers in attendance at the SkySQL developer meeting in Barcelona got together to work on plans for MariaDB 10.1. We also paused for a group photo:

Many tasks have been identified for possible inclusion in 10.1. Some have already been marked as such in JIRA. A summary is

  [Read more...]
MariaDB Developers at the SkySQL Engineering Meeting
+3 Vote Up -0Vote Down

Several MariaDB developers are attending SkySQL’s annual engineering meeting being held this week in Barcelona. While some of the discussions are SkySQL-specific (customers, internal projects, and so on), there are, naturally, lots of MariaDB discussions happening.

Patrik Sallner, CEO of SkySQL, opened the meeting this morning with a short presentation about SkySQL’s goals for 2014. While the plan includes standard business-like things that include growing the company and sales goals, the top two goals for 2014 are:

  • Help make MariaDB into the leading open source database

  • Help increase awareness and adoption of MariaDB

  • Looking back at 2013, it was an excellent year for MariaDB. It is now the default database in

      [Read more...]
    OurSQL Episode 168: Autofailover, part 1
    +1 Vote Up -0Vote Down

    This week we discuss setting up Percona Replication Manager. Ear Candy is playing with Unicode to make seasonal pictures and At the Movies is about systems performance with lots of MySQL examples.

    Events
    DB Hangops - every other Wednesay at noon Pacific time

    FOSDEM 2014 - Sat February 1 - Sun February 2 in Brussels, Belgium.
    Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

    The call for papers for OSCon 2014 is open until Thursday, January 30th

    read more

    MariaDB 5.5.34 now available
    +0 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.34. This is a Stable (GA) release. See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 5.5? page in the MariaDB Knowledge Base for general information about the MariaDB 5.5 series.

    Download MariaDB 5.5.34

    Release Notes Changelog What is MariaDB 5.5?

    Free Webinar: Percona and Sphinx
    +0 Vote Up -0Vote Down
    Next Wednesday (November 20th, at 10 am PST), Ryan Lowe (Percona: Principle Consultant) and Andrew Aksyonoff (Sphinx: CEO and CTO) will be delivering a webinar on how to configure Sphinx for MySQL. “How to Optimally Configure Sphinx for MySQL” The discussion will center around getting started with, and seamlessly integrating, Sphinx into your MySQL-based applications. [...]
    Hong Kong (OpenStack Summit)
    +0 Vote Up -0Vote Down

    I’ll be in Hong Kong for the upcoming OpenStack Summit Nov 5-8. I’d be thrilled to talk database things with others present, especially around Trove DBaaS (DataBase as a Service) and high availability MySQL for OpenStack deployments.

    I was last in Hong Kong in 2010 when I worked for Rackspace. The closest office to me was in Hong Kong so that’s where I did my HR onboarding training. I remember telling friends on the Sunday night before leaving for Hong Kong that I may be able to make dinner later in the week purely depending on if somebody got back to me on if I was going to Hong Kong that week. I was, and I went. I took some photos while there.

    Walking from the hotel where we were staying to the Rackspace office could be

      [Read more...]
    MariaDB Foundation achivements 2012-12 – 2013-09
    +0 Vote Up -0Vote Down

    Reposted from Monty Says.

    I recently read some comments that we at the MariaDB Foundation have not been very open about what we are doing.

    We are very sorry about this. The problem is not that we are secret about what we are doing, the problem is that not many of us working at the MariaDB Foundation are very active bloggers.

    I will try to address this concern by starting a monthly blog about the MariaDB development that MariaDB Foundation employees are doing. This together with Simon Phipps’ state of the sea lion blog, which is published here, should hopefully give everyone a better idea of what we are doing.

    At the MariaDB

      [Read more...]
    Tips and tricks while working with Production DBs
    +0 Vote Up -0Vote Down

    From time to time we have to work with live environments and production databases. For some of us this is day-to-day job. And most of the time cost of a mistake is way higher than expected improvement especially on the databases. Because issue on the database side will affect everything else.

    I heard enough war stories about ruined productions and can imagine well enough speed of DROP DATABASE command replicating across the cluster. So I’m scared to make changes in production. The more loss expected if things go wrong the more I’m going to be scared planning every change. But I still love to make improvements so the only question is how to make them safer.

    This post is not intended to be a guide or best practices on how to avoid issues at all,

      [Read more...]
    MariaDB Java Client 1.1.5 Now Available
    +0 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of the MariaDB Java Client 1.1.5. This is a Stable (GA) release. See the Release Notes and Changelog for detailed information on this release and the About the MariaDB Java Client page in the MariaDB Knowledge Base for general information about the client.

    Download MariaDB Java Client 1.1.5

    Release Notes

      [Read more...]
    Showing entries 1 to 30 of 1015 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.