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 783 Next 30 Older Entries

Displaying posts with tag: mariadb (reset)

MariaDB 10 is a Sandbox killjoy?
+0 Vote Up -0Vote Down

Using MySQL Sandbox I can install multiple instances of MySQL. It is not uncommon for me to run 5 or 6 instances at once, and in some occasions, I get to have even 10 of them. It is usually not a problem. But today I had an issue while testing MariaDB, for which I needed 5 instances, and I the installation failed after the 4th one. To make sure that the host could run that many servers, I tried installing 10 instances of MySQL 5.6 and 5.7. All at once, for a grand total of 20 instances:

$ make_multiple_sandbox --how_many_nodes=10 5.6.14
installing node 1
installing node 2
installing node 3
installing node 4
installing node 5
installing node 6
installing node 7
installing node 8
installing node 9
installing node 10
group directory installed in










  [Read more...]
Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 3: "Running in Eclipse"
+4 Vote Up -0Vote Down

Introduction:

To run MariaDB from Eclipse we will actually create and install the tar.gz package resulting from compilation(See Part 2) in a separate directory, this will allow us to have MariaDB cleanly installed on a separate location and so it will be also easily possible to run it independently from Eclipse.

In these Blog posts series we assume:


yoda							as developer user
 

read more

MariaDB 10.0.11 Overview and Highlights
+5 Vote Up -0Vote Down

MariaDB 10.0.11 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.0.11/

This is the second GA release of MariaDB 10.0, and 12th overall release of MariaDB 10.0.

This is primarily a bug-fix release.

Here are the main items of note:

  • Updated TokuDB engine to version 7.1.6
  • Updated Spider storage engine to version 3.2 (now Gamma)
  • Updated XtraDB storage engine to version 5.6.17-65.0
  • Updated InnoDB storage engine to version 5.6.17
  • Updated
  •   [Read more...]
    Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 2: "Compile in Eclipse"
    +2 Vote Up -0Vote Down

    Section 2: "COMPILE MARIADB IN ECLIPSE"



    2.1 Download and prepare sources folder

    We will need a directory to use as our playground, if you create the user yoda in Section 1:

    $ su - yoda
    $ mkdir -p ~/playground

    Download latest MariaDB 10 sources tar.gz and copy the archive into the above directory, you can latest sources from:

    read more

    MariaDB moves development to Github
    +0 Vote Up -0Vote Down

    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, 5.2, and

      [Read more...]
    Compiling & Debugging MariaDB(and MySQL) in Eclipse from scratch - Part 1: "Setup the building environment"
    +0 Vote Up -0Vote Down
    This guide will help you in compiling and debugging MariaDB (MySQL, Percona) within the Eclipse IDE on Linux and using cmake for source project preparation. It will be split in parts to keep each post lightweight and with a finite objective. At the end of reading this series of blog posts you should be able to:
  • Prepare for compilation any MariaDB (MySQL, Percona) source release based on cmake framework.
  • read more

    Since now on github is the place for MariaDB new dev !
    +3 Vote Up -0Vote Down

    Today while browsing through my emails I was very happy to read this email from Sergei Golubchik :

    Hi! I'm happy to announce that MariaDB-10.1 tree has been completely migrated to github. Since now on we'll use github for the new development in MariaDB. It's https://github.com/MariaDB/server, go on, fork it, hack around, submit pull requests. [...]
    How to Deploy Percona XtraDB Cluster without Internet Connection
    +0 Vote Up -0Vote Down
    May 23, 2014 By Severalnines

    If you need to deploy a database cluster behind your corporate firewall, on servers with no internet access, then this blog is for you. Most of the installation tutorials out there require servers to have an internet connection, and that would not work very well with companies under strict policies and compliance guidelines. 


    Our online Galera Configurator supports deployment without Internet connection for Percona XtraDB Cluster. You would need to prepare a minimum of four hosts (three DB nodes and one management node), generate a Deployment

      [Read more...]
    Engineering behind EXPLAIN FORMAT=JSON (or lack thereof)
    +3 Vote Up -3Vote Down

    MySQL 5.6 has added support for EXPLAIN FORMAT=JSON. The basic use case for that feature is that one can look at the JSON output and see more details about the query plan. More advanced/specific use cases are difficult, though. The problem is, you can’t predict what EXPLAIN FORMAT=JSON will produce. There is no documentation or any kind of convention regarding the contents of JSON document that you will get.

    To make sure I’m not missing something, I looked at MySQL Workbench. MySQL Workbench has a feature called Visual Explain. If you want to use, prepare to seeing this a lot:

    In Workbench 6.1.4 you get it for (almost?) any query with subquery. In Workbench 6.1.6 (released last week), some subqueries work, but it’s still easy to hit a

      [Read more...]
    MariaDB & MySQL Community Event videos & slides now up
    +0 Vote Up -0Vote Down

    If you couldn’t attend the MariaDB & MySQL Community Event in April 2014, held at the Hilton Santa Clara, fret not as there are slides and videos uploaded for you to watch at your leisure. There is likely to be at least one more community event later this year, so watch the space.

    Currently on the page, you’ll find most of the talks with slides and the videos are professionally done – with slide overlays. The audio could be better on some, but for an event that was pulled together by Monty in less than 3 weeks, it’s not too shabby. You can learn What’s new in MariaDB 10, a little more about the SPIDER storage engine,

      [Read more...]
    Webinar Replay, Slides & Q&A: Introducing ClusterControl 1.2.6 - Managing your MySQL, MariaDB & MongoDB Clusters
    +0 Vote Up -0Vote Down
    May 19, 2014 By Severalnines

     

    Thanks to everyone who attended and participated last week’s joint webinar on ClusterControl 1.2.6! We had great questions from participants (thank you), most of which are transcribed below with our answers to them.

     

    If you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

     

    Webinar topics discussed: 

    • Database Infrastructure Lifecycle
    • Deploy, Monitor, Manage,
      [Read more...]
    Archival and Analytics - Importing MySQL data into Hadoop Cluster using Sqoop
    +1 Vote Up -0Vote Down
    May 16, 2014 By Severalnines

    We won’t bore you with buzzwords like volume, velocity and variety. This post is for MySQL users who want to get their hands dirty with Hadoop, so roll up your sleeves and prepare for work. Why would you ever want to move MySQL data into Hadoop? One good reason is archival and analytics. You might not want to delete old data, but rather move it into Hadoop and make it available for further analysis at a later stage. 

     

    In this post, we are going to deploy a Hadoop Cluster and export data in bulk from a Galera Cluster using Apache Sqoop. Sqoop is a well-proven approach for bulk data loading from a relational

      [Read more...]
    An interesting case in ORDER BY LIMIT optimization
    +1 Vote Up -0Vote Down

    Recently, I was asked about an interesting case in ORDER BY … LIMIT optimization. Consider a table

    create table tbl (
      …
      KEY key1(col1, col2),
      PRIMARY KEY (pk)
    ) engine=InnoDB;
    

    Consider queries like:

      select * from tbl where col1=’foo’ and col2=123 order by pk limit 1;
      select * from tbl where col1=’bar’ and col2=123 order by pk limit 1;
    

    These run nearly instantly. But, if one combines these two queries with col1='foo' and col1='bar' into one query with col1 IN ('foo','bar'):

      select * from tbl where col1 IN (’foo’,'bar’) and col2=123 order by pk limit 1;
    

    then the query is be orders of magnitude slower than both of the queries with col1=const.

    The first thing to note when doing investigation is to note that the table uses InnoDB engine,

      [Read more...]
    MariaDB/MySQL: Making ENGINE clause mandatory
    +0 Vote Up -1Vote Down

    I got this idea from a Valerii Kravchuk’s MySQL bug report:

    http://bugs.mysql.com/bug.php?id=71978

    In theory, I completely agree that MySQL and forks should not allow us to set a default storage engine which cannot be used to create a table. You can see the same with MariaDB’s SEQUENCE. The MySQL & forks philosophy seems to be: ignore your mistakes, so you can repeat them forever. Which can turn a mistype into a major data loss.

    Unless you only use InnoDB and your magic powers tell you that this will never change, the ENGINE clause should be mandatory in your MySQL installation. Since there is no clean way to make it mandatory, setting a “weird” storage engine as default seems to be a decent workaround. I don’t like

      [Read more...]
    Comparing query optimizer features in MariaDB 10.0 and MySQL 5.6
    +0 Vote Up -0Vote Down

    MariaDB 10.0 had a stable release last month. It is a good time to take a look and see how it compares to the stable version of MySQL, MySQL 5.6 (as for Percona Server, it doesn’t have its own optimizer features).
    Changelogs and release notes have all the details, but it’s difficult to see the big picture. So I went for diagrams, and the result is a short article titled What is the difference between MySQL and MariaDB query optimizers. It should give one a clue about what are the recent developments in query optimizers in MySQL world.

    In case you’re interested in details about optimizer features in MariaDB 10.0, I’ve shared slides from a talk about MariaDB 10.0 query optimizer.

    MariaDB storage engines
    +0 Vote Up -0Vote Down

    This is a list of MariaDB storage engines that are not distributed with MySQL. I think that most of them will work with MySQL, but not all – at least CassandraSE doesn’t.

    Engine Description Introduced XtraDB A fully-compatible fork of InnoDB, mantained by Percona Big Bang Aria A crash-safe MyISAM, also used for internal temptables Big Bang TokuDB A transactional engine with innovative buffers and high compression, by TokuTek 10.0   [Read more...]
    New Release Webinar on May 13th: Introducing ClusterControl 1.2.6 - Live Demo
    +0 Vote Up -0Vote Down
    May 7, 2014 By Severalnines

     

    Following the release of ClusterControl 1.2.6 a couple of weeks ago, we are now looking forward to demonstrating this latest version of the product on Tuesday next week, May 13th.

     

    This release contains key new features (along with performance improvements and bug fixes), which we will be demonstrating live during the webinar. 

     

    Highlights include:

    • Centralized
      [Read more...]
    Continuent Delivers Real-Time Data to Cloudera | Business Wire
    +0 Vote Up -0Vote Down
    SAN JOSE, CA– May 6, 2014 – Continuent, Inc., a leading provider of open source database clustering and replication solutions, today announced that their recently announced Tungsten Replicator 3.0 solution has been certified by Cloudera, the leader in enterprise analytic data management powered by Apache Hadoop™. Continuent Tungsten Replicator 3.0 enables organizations to quickly and easily 
    The Other MariaDB Blog
    +1 Vote Up -0Vote Down

    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...]
    MariaDB 10 – XtraDB & InnoDB versions
    +1 Vote Up -0Vote Down

    I’ve had this question several times when presenting and once via an internal email thread so I figure I might as well write about it: What is the default transactional engine in MariaDB 10.0? The answer is simple – it is XtraDB.

    However this answer has some history: initial releases of MariaDB 10 actually shipped with InnoDB from MySQL 5.6. Only in 10.0.9 RC did the default switch back to being XtraDB. As MariaDB users previously know, XtraDB was the default InnoDB in 5.1, 5.2, 5.3, and 5.5 too. As always, you can switch easily between InnoDB/XtraDB – read more in: Using InnoDB instead of XtraDB

    How do you tell what version of InnoDB or XtraDB you are running? Simply, run: SHOW GLOBAL VARIABLES LIKE 'innodb_version';

    MariaDB 10.0 (read

      [Read more...]
    MySQL 5.6 + GTID & MariaDB 10 replication
    +1 Vote Up -0Vote Down

    While at the keynote of Tomas Ulin at Percona Live MySQL Conference & Expo Santa Clara 2014, he asked the audience what they were running, and most of the audience was on MySQL 5.5 while about 15% of the audience was on MySQL 5.6. This number is steadily increasing I’m sure, so one thing that becomes important is that people will probably start turning on Global Transaction Identifiers (GTIDs). 

    As you may already know, MariaDB 10 has a different implementation of Global Transaction ID. To me, this poses a problem in a mixed use environment (or even a migration scenario). Which is why

      [Read more...]
    MySQL related IRC discussion channels
    +0 Vote Up -0Vote Down

    There are many MySQL related IRC discussion channels as the ecosystem itself grows. I join the following. Are there any that I’m missing?

    Freenode (irc.freenode.net):

    • #mysql – main channel for all kinds of end user MySQL related discussions (the noisiest of the lot, naturally)
    • #maria – main channel for all kinds of MariaDB related discussions
    • #webscalesql – for all kinds of WebScaleSQL discussions
    • #percona – main channel for all kinds of Percona related discussions
    • #tokutek – main channel for Tokutek discussions (TokuDB or TokuMX)
    • SkySQL-specific channels: #maxscale and #mariadb-mgr

    OFTC (irc.oftc.net):

    • #debian-mysql – for all kinds of Debian MySQL related bits (packaging, bugs, etc.)
      [Read more...]
    MariaDB Galera Cluster 5.5.37 now available
    +0 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.37. This is a Stable (GA) release.

    See the Release Notes and Changelog for detailed information on this release and the What is MariaDB Galera Cluster? page in the MariaDB Knowledge Base for general information about MariaDB Galera Cluster.

    Download MariaDB Galera Cluster 5.5.37

    Release Notes

      [Read more...]
    Crunching XML files with MariaDB
    +0 Vote Up -0Vote Down

    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 kinds of data sources,

      [Read more...]
    Four MariaDB books available now
    +3 Vote Up -0Vote Down

    It’s quite exciting to see the amount of MariaDB books out there (first GA release of software: February 2010).

    From left-to-right:

  • MariaDB Crash Course (August 2011)
  •   [Read more...]
    Descending indexes in MariaDB
    +1 Vote Up -0Vote Down

    Since the dawn of time, MySQL indexes have a limit: they cannot be descending. Yes, ALTER TABLE and CREATE INDEX can contain the ASC and DESC keywords. It is perfectly legal in MySQL. But this does not mean that descending indexes are created. This is a well-known MySQL feature: when it cannot do something, it just pretends to. Well… someone thinks it is a feature. I think it is a bug (a bug is an unexpected behaviour), but what can we do.

    The lack of support for descending indexes is only an issue when we need to create an index in which at least one column is ascending and at least one column is descending. For example, MySQL pretends to understand the following statement, but the resulting index won’t probably help us:

    CREATE INDEX my_index ON my_table (my_column ASC, your_column
      [Read more...]
    How to Setup Centralized Authentication of ClusterControl Users with LDAP
    +0 Vote Up -0Vote Down
    April 24, 2014 By Severalnines

    ClusterControl 1.2.6 introduces integration with Active Directory and LDAP authentication. This allows users to log into ClusterControl by using their corporate credentials instead of a separate password. LDAP groups can be mapped onto ClusterControl user groups to apply roles to the entire group, so it is very convenient for larger organizations who have a centralized LDAP-compliant authentication system. This blog shows you how to configure LDAP authentication in ClusterControl, and allow users to use their Active Directory or LDAP username and password to log in to ClusterControl. 

      [Read more...]
    MariaDB 10.0.10 uploaded to Debian experimental
    +2 Vote Up -0Vote Down

    If you’re watching the NEW queue, you’ll notice that MariaDB 10.0.10 has been uploaded targeting Debian/experimental. Package description, and to think the bug was only opened on April 2nd – pretty quick turnaround.

    Related posts:

  • MariaDB in Debian unstable
  • Debian releases Lenny, MySQL 5.1 soon
  • MariaDB in Gentoo; updates for Solaris/Debian SPARC
  • MariaDB 5.5.37 Overview and Highlights
    +0 Vote Up -0Vote Down

    MariaDB 5.5.37 was recently released (it is the latest MariaDB 5.5), and is available for download here:

    https://downloads.mariadb.org/mariadb/5.5.37/

    This is a maintenance release, and so there are not too many big changes of note, just a number of normal bug fixes. However, there are a few items worth mentioning:

    read more

    Ubuntu 14.04 – some MySQL ecosystem notes
    +1 Vote Up -0Vote Down

    Following my previous post on the launch, I just rolled Ubuntu 14.04 LTS on an Amazon EC2 t1.micro instance (not something you expect to run a database server on, for sure – 1 vCPU, 0.613GiB RAM). If you do an apt-cache search mysql you get 435 return result sets with the default configuration (trusty: main & universe).

    If you do apt-get install mysql-server, you get MySQL 5.5. You enter the password of choice, and before you know it, MySQL is installed (a SELECT VERSION() will return 5.5.35-1ubuntu1).

    Next you decide to install MariaDB. I run an apt-get install mariadb-server. It pulls in libjemalloc (for TokuDB) and I expect future releases to ship this engine by default. You enter the password, and

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