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 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 1026 Next 30 Older Entries

Displaying posts with tag: General (reset)

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...]
    OurSQL Episode 151: Tooling Around, Part 1
    +1 Vote Up -0Vote Down

    This week we start talking about the Python MySQL Utilities. Ear Candy is a pitfall when importing a mysqldump export and At the Movies is "Deploying MySQL in AWS and OpenStack" by Mark Riddoch of SkySQL.

    Part 2 of MySQL Utilities
    Part 3 of MySQL Utilities
    Part 4 of MySQL Utilities
    Part 5 of MySQL Utilities

    MySQL Utilities
    MySQL Utilities documentation

    read more

    OurSQL Episode 149: Trolling
    +0 Vote Up -0Vote Down

    This week we continue our interview with Noam Kritzer of Bakos & Kritzer, talking about patent case law and patent trolls. Ear Candy is temporary table ghost files, and At the Movies is Manipulating JSON with MariaDB and MySQL.

    defensive vs. offensive patents

    Patent trolls

    Trademarks and domain names

    Copyright.gov, a resource written for lay people.

    read more

    OurSQL Episode 148: Intellectual Property
    +0 Vote Up -0Vote Down

    This week we interview Noam Kritzer from the law firm of Bakos & Kritzer about copyright, patents and trademarks. Ear Candy is about SUBSTRING_INDEX and At the Movies is Colin Charles presenting a panel on MariaDB.

    Events
    DB Hangops - every other Wednesay at noon Pacific time

    Oracle is having a MySQL OTN Virtual Developer Day August 31st.

    FrOSCon - Aug 24-25th, 2013 in St. Augustin, Germany.

    read more

    MariaDB 5.5.32 Now Available
    +3 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.32. 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 AskMonty Knowledgebase for general information about the MariaDB 5.5 series.

    Download MariaDB 5.5.32

    Release Notes Changelog

      [Read more...]
    From MySQL Fulltext Search to Sphinx
    +0 Vote Up -0Vote Down
    MySQL fulltext search (FTS) is old and well known. It has a simple setup and requires only small changes for querying. For many people it’s more than enough to provide fulltext search. So, here’s the question: why add a new variable – Sphinx – into the system when the database already has the basic functionality? [...]
    MariaDB patches for Random Query Generator
    +3 Vote Up -0Vote Down

    My fellow testers and others who run RQG tests on MySQL flavors might be interested in some additions that are being used for MariaDB testing. While none of them is a major breakthrough, maybe they will make somebody’s life a little easier.

    RQG Introduction

    A quick introduction for those who have never heard of RQG, but are still curious what this blog post is about.

    RQG stands for Random Query Generator, also known as randgen — an open-source product, available under the GPL v2 license. Quoting its home page on Launchpad, it is a “pseudo-random data and query generator that can be used to test any Perl DBI, JDBC or ODBC-compatible SQL server, in particular MySQL, but also JavaDB and PostgreSQL”.

    The framework was created by my former

      [Read more...]
    MySQL man pages silently relicensed away from GPL
    +7 Vote Up -3Vote Down

    It has recently been brought to our attention that the MySQL man pages have been relicensed. The change was made rather silently going from MySQL 5.5.30 to MySQL 5.5.31. This affects all pages in the man/ directory of the source code.

    You can tell the changes have come during this short timeframe (5.5.30->5.5.31). The old manual pages were released under the following license:

    This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.

    The new man pages (following 5.5.31 and greater – still valid for 5.5.32) are released under the following license:

    This software and related documentation are provided under a license agreement containing restrictions on use

      [Read more...]
    MariaDB 10.0.3 alpha Now Available
    +3 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.3. This is an alpha release. See the release notes and changelog for details.

    Download MariaDB 10.0.3

    Release Notes Changelog What is MariaDB 10.0?

    APT and YUM Repository Configuration Generator

    About this  [Read more...]

    MariaDB 5.5.31 Now Available
    +3 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of the MariaDB 5.5.31. 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 AskMonty Knowledgebase for general information about the MariaDB 5.5 series.

    Download MariaDB 5.5.31

    Release Notes Changelog

      [Read more...]
    The MySQL Cluster storage engine
    +2 Vote Up -0Vote Down

    This is one close to my heart. I’ve recently written on other storage engines: Where are they now: MySQL Storage EnginesThe MERGE storage engine: not dead, just resting…. or forgotten and The MEMORY storage engine. Today, it’s the turn of MySQL Cluster.

    Like InnoDB, MySQL Cluster started outside of MySQL. Those of you paying attention at home may notice a correlation between storage engines not written exclusively for MySQL and being at all successful.

    NDB

      [Read more...]
    On performance of JDBC drivers.
    +4 Vote Up -1Vote Down

    Back when the first version of the MariaDB Java Client was released, someone asked in the comments about the performance characteristics of the driver compared to ConnectorJ. I answered with hand-waving, saying that nobody does anything stupid, the performance of the drivers would be roughly the same, but I promised to measure it and tell the world one day. And now that day has come. The day where three MySQL JDBC drivers (ConnectorJ, MariaDB JDBC, and Drizzle JDBC) are compared against each other. Unlike the server, which gets benchmarking attention all the time, there is no standard benchmark for connectors, so I needed to improvise, while trying to keep the overhead of the server minimal. So I did something very primitive to start. I used my two favorite queries:

    • DO 1 — this one does not retrieve a result set, and thus can be seen as a small
      [Read more...]
    Percona Live Conference Notes
    +3 Vote Up -0Vote Down

    This is the required post about things I observed during this years MySQL conference.

    Things that are awesome:

    • The tables in sessions. I think these were here last year. They are still awesome this year.
    • The new style power plugs. They solved the problem of people tripping over daisy chained power strips and the strips being accidentally turned off.
    • Massive quantities of coffee and real cream.

    Things that can be improved:

    • Lunch tickets. I overheard the same conversation a dozen times about people not being able to find their lunch tickets or not really knowing about them.
    • Make badges reversible. A badge under observation will be facing the wrong way.

    Things that just bumped me:

    • The music is different this year. Now it makes me feel like a teenager struggling with a breakup.
      [Read more...]
    MariaDB Java Client 1.1.2 Released
    +4 Vote Up -1Vote Down

    The MariaDB project is pleased to announce the immediate availability of the MariaDB Java Client 1.1.2. 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 AskMonty Knowledgebase for general information about the client.

    Download MariaDB Java Client 1.1.2

    Release Notes

      [Read more...]
    Database Master-Slave Replication in the Cloud
    +1 Vote Up -1Vote Down
    This is a guest post from Jelastic.

    Many developers use master-slave replication to solve a number of different problems, including problems with performance, supporting the backup of different databases, and as a part of a larger solution to alleviate system failures. Traditionally, master-slave replication is done with real servers, but it can also be done with cloud database servers. This guest post from Jelastic (originally published here) describes how to set up MariaDB master-slave replication using their Jelastic PaaS (Platform as a Service).

    Replication Overview

    Master-slave replication enables data from one database server (the master) to be replicated to one or more other database

      [Read more...]
    OurSQL Episode 137: Playing in the Sandbox
    +2 Vote Up -0Vote Down

    This week we talk to Giuseppe Maxia about MySQL Sandbox. Ear Candy is about table_open_cache, Open_tables and Opened_tables, and At the Movies features MariaDB.

    MySQL Sandbox
    MySQL Sandbox

    Examples:
    MariaDB slave of a master:
    make sandbox mysql-tarball --master
    make sandbox mariadb-tarball --slaveof master-port=foo

    Exporting:
    ./my sqldump instancename

    Remote mysql sandbox deploy:
    deploy remote sandboxes -m MySQLVer -l list,of,servers

    Get MySQL Sandbox on Launchpad

    read more

    MariaDB Introduces Atomic Writes
    +7 Vote Up -0Vote Down
    Sysbench OLTP, transactions per second

    When dealing with high performance, low latency storage devices, such as SSD cards, one finds bottlenecks in new places. This is a story about such a bottle neck and how to work around it.

    One unique feature of InnoDB is the double write buffer. This buffer was implemented to recover from half-written pages. This can happen in case of a power failure while InnoDB is writing a page (16KB = 32 sectors) to disk. On reading that page, InnoDB would be able to discover the corruption from the mismatch of the page checksum. However in order to recover, an intact copy of the page would be needed.

    The double write buffer provides such a copy. Whenever InnoDB flushes a page to disk, it is first written to the double write buffer. Only when the buffer is

      [Read more...]
    The MERGE storage engine: not dead, just resting…. or forgotten.
    +0 Vote Up -0Vote Down

    Following on from my fun post on Where are they now: MySQL Storage Engines, I thought I’d cover the few storage engines that are really just interfaces to a collection of things. In this post, I’m talking about MERGE.

    The MERGE engine was basically a multiplexer down to a number of MyISAM tables. They all had to be the same, there was no parallel query execution and it saw fairly limited use. One of the main benefits was that then you could actually put more rows in a MyISAM table than your “files up to 2/4GB” file system allowed. With the advent of partitioning, this really should have instantly gone away

      [Read more...]
    Sphinx @ Percona Live: Update
    +2 Vote Up -0Vote Down
    The Percona Live: MySQL User Conference is just around the corner! Before we begin our trek to San Jose, we want to provide you with one last announcement about our upcoming activities. First of all, as we’ve previously mentioned, Andrew Aksyonoff (Sphinx’s founder) is going to be delivering a Sphinx tutorial on the 22nd of April [...]
    Refactoring Internal temporary tables (another stab at it)
    +1 Vote Up -2Vote Down

    A few weekends ago, I started to again look at the code in Drizzle for producing internal temporary tables. Basically, we have a few type of tables:

    • Standard
    • Temporary (from CREATE TEMPORARY TABLE)
    • Temporary (from ALTER TABLE)
    • Internal temporary (to help with query execution)

    If you’re lucky enough to be creating one of the first three types, you go through an increasingly lovely pile of code that constructs a nice protobuf message about what the table should look like and hands all responsibility over to the storage engine as to how to do that. The basic idea is that Drizzle gets the heck out of the way and lets the storage engine do its thing. This code path looks rather different

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 1026 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.