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

Displaying posts with tag: mariadb (reset)

Congratulations Ubuntu, for the wide choice!
+0 Vote Up -0Vote Down

Inspired by Yngve Svendsen’s post, I too think it makes absolute sense to congratulate Ubuntu on the 14.04 LTS release (some server notes - MySQL has a section dedicated to it). Ubuntu users have a lot of server choice today (that’s from all major MySQL ecosystem vendors):

  • MySQL 5.5.35 ships in main. It is the default MySQL. Oracle has committed to providing updates to 5.5 throughout the LTS release cycle of Ubuntu (which is longer than the planned EOL for 5.5). This is why the grant of a
  [Read more...]
SSL and MariaDB/MySQL
+0 Vote Up -0Vote Down

With the recent Heartbleed bug, people are clearly more interested in their MariaDB/MySQL running with SSL and if they have problems. First up, you should read the advisory notes: MariaDB, Percona Server (blog), and MySQL (blog).

Next, when you install MariaDB (or a variant) you are usually dynamically linked to the OpenSSL library that the system provides. Typically on startup

  [Read more...]
MariaDB 5.5.37 now available
+0 Vote Up -0Vote Down

The MariaDB project is pleased to announce the immediate availability of MariaDB 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 5.5? page in the MariaDB Knowledge Base for general information about the MariaDB 5.5 series.

Download MariaDB 5.5.37

Release Notes Changelog What is MariaDB

  [Read more...]
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...]
Korean MySQL Power User Group
+1 Vote Up -0Vote Down

If you are a MySQL power user in Korea, its well worth joining the Korean MySQL Power User Group. This is a group led by senior DBAs at many Korean companies. From what I gather, there is experience there using MySQL, MariaDB, Percona Server and Galera Cluster (many on various 5.5, some on 5.6, and quite a few testing 10.0). No one is using WebScaleSQL (yet?). The discussion group is rather active, and I’ve got a profile there (I get questions translated for me).

This is just a natural evolution of the DBA Dinners that were held once every quarter. Organised by OSS Korea, and

  [Read more...]
Amazon EC2 Linux AMIs
+1 Vote Up -0Vote Down

If you use Amazon Elastic Compute Cloud (EC2), you are always given choices of AMIs (by default; there are plenty of other AMIs available for your base-os): Amazon Linux AMI, Red Hat Enterprise Linux, SUSE Enterprise Server and Ubuntu. In terms of cost, the Amazon Linux AMI is the cheapest, followed by SUSE then RHEL. 

I use EC2 a lot for testing, and recently had to pay a “RHEL tax” as I needed to run a RHEL environment. For most uses I’m sure you can be satisfied by the Amazon Linux AMI. The last numbers suggest Amazon Linux is #2 in terms of usage on EC2.

Anyway, recently Amazon Linux AMI came out with the 2014.03 release (see release

  [Read more...]
Heartbleed OpenSSL Bug: Impact on ClusterControl Users & Recommendations on How to Protect your Systems
+0 Vote Up -0Vote Down
April 10, 2014 By Severalnines

 

In the wake of recent concerns and debates raised around the Heartbleed bug, we wanted to update Severalnines ClusterControl users on any impact this bug might have on ClusterControl & associated databases and/or applications.

 

Background

 

If your ClusterControl's web application has been accessible on the internet, then most likely you have also been exposed to the Heartbleed OpenSSL security bug, see: http://heartbleed.com for more details. 

By default, our database deployment script enables SSL encryption for the

  [Read more...]
Book in Korean: Real MariaDB
+1 Vote Up -0Vote Down

For some months now, there have been some back & forth emails with Matt, one of the senior DBAs behind the popular messaging service, KakaoTalk (yes, they are powered by MariaDB). Today I got some positive information: the book published entirely in the Korean language, titled Real MariaDB is now available.

It covers MariaDB 10.0. Where appropriate, there are also notes on MySQL 5.6 (especially with regards to differences). This is Matt’s fourth MySQL-related book, and

  [Read more...]
MariaDB 10.0.10 Overview and Highlights
+2 Vote Up -0Vote Down

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

https://downloads.mariadb.org/mariadb/10.0.10/

This is the first GA ("Generally Availability", aka "recommended for production systems") release of MariaDB 10.0, and 11th overall release of MariaDB 10.0.

Since this is the initial 10.0 GA release, this is primarily a bug-fix and polishing release.

Here are the main items of note:

read more

MariaDB 10.0 reference card: plugins in packages
+0 Vote Up -0Vote Down

MariaDB 10.0 comes with ~50 engines and plugins; and it comes in 35 package sets (34 binary ones and a source tarball).

Every day people come asking on #maria IRC whether a package X contains an engine Y, or saying that it doesn’t, or wondering if it should. Remembering all combinations isn’t easy, and it became impractical to study build logs or package contents every time, so I ended up with a cheat sheet for 10.0.10 GA. At the very least it should help me to answer those questions; even better if somebody else finds it useful.

The tables below refer to contents of packages provided at downloads.mariadb.org or at MariaDB repository mirrors. Packages built by distributions might have different contents and are not covered here.

Legend

— built-in (also known as static):
the plugin comes as a part of the server binary. It

  [Read more...]
When the Innovator's Dilemma hit the MySQL World
+2 Vote Up -5Vote Down
What’s the connection between databases and fruit flies?
Some of you may be familiar with the bestseller in business literature The Innovator's Dilemma: When New Technologies Cause Great Firms to Fail, by Harvard professor Clayton Christensen. In his book, Prof. Christensen compared disk drives to fruit flies. The comparison relates to the rapid changes that disrupted the disk drive industry for decades. That disruption is compared to the rapid changes that take place to fruit flies that live only for few hours, and for this reason researchers can study and analyse their behaviour.

In the software business, you can replace disk drives with databases. Obviously, databases live longer than fruit flies, but it is an industry that sometimes shows schizophrenic changes. Whilst it is true that relational databases have being dominated the


  [Read more...]
Compile at CentOS 6.5 the new MySQL webscalesql-5.6.17 branch by Facebook, Google, LinkedIn, and Twitter
+1 Vote Up -0Vote Down

http://webscalesql.org/

yeah , big buzz around that one :)

So I decided to check the install process:

1. Clone the repo from

root@webscalesql-5.6.clean:[Mon Mar 31 11:37:11][~]$ cd /opt/
root@webscalesql-5.6.clean:[Mon Mar 31 11:37:15][/opt]$ mkdir installs
root@webscalesql-5.6.clean:[Mon Mar 31 11:37:17][/opt]$ cd installs/
root@webscalesql-5.6.clean:[Mon Mar 31 11:37:19][/opt/installs]$ git clone https://github.com/webscalesql/webscalesql-5.6.git
Initialized empty Git repository in /opt/installs/webscalesql-5.6/.git/
remote: Counting objects: 30397, done.
remote: Compressing objects: 100% (12678/12678), done.
remote: Total 30397 (delta 18716), reused
  [Read more...]
The MariaDB Foundation Announces General Availability of MariaDB 10
+3 Vote Up -0Vote Down

Best MariaDB ever hits the streets – MariaDB 10 innovations developed with Google, SkySQL & Fusion-IO

London, United Kingdom – 31 March 2014 – The MariaDB Foundation, an independent body which promotes the popular open source database MariaDB, today announced the much-anticipated general availability of MariaDB 10, providing today’s generation of application developers with enhanced performance and functionality.

Since its launch in 2009, MariaDB has built an active and vibrant open source community and has led the way in database innovation. In 2013, Wikimedia Foundation, the people behind Wikipedia, announced the migration of many of its production MySQL systems over to MariaDB and Google confirmed it aims to move its thousand-plus MySQL instances over to MariaDB technology.

  [Read more...]
How to Migrate Your Application to Amazon Virtual Private Cloud without Downtime
+0 Vote Up -0Vote Down
March 27, 2014 By Severalnines

With datacenters being stretched by resource-intensive applications, more and more businesses are outgrowing their existing in-house capacity and having to reconfigure their IT operations. But how do you migrate a busy application to a totally new data center without downtime? How will the application scale in a virtualized cloud environment? And how do you guard against cloud server failures and keep a high level of uptime?

 

 

In this example, we will show you how to migrate a Web application (Wordpress) from a local data center to a AWS VPC. Without downtime even! 

 

Main steps:

      [Read more...]
    innodb_flush_logs_on_trx_commit and Galera Cluster
    +0 Vote Up -0Vote Down

    We deploy Galera Cluster (in MariaDB) for some clients, and innodb_flush_logs_on_trx_commit is one of the settings we’ve been playing with. The options according to the manual:

    • =0 don’t write or flush at commit, write and flush once per second
    • =1 write and flush at trx commit
    • =2 write log, but only flush once per second

    The flush (fsync) refers to the mechanism the filesystem uses to try and guarantee that written data is actually on the physical medium/device and not just in a buffer (of course cached RAID controllers, SANs and other devices use some different logic there, but it’s definitely written beyond the OS space).

    In a non-cluster setup, you’d always want it to be =1 in order to be ACID compliant and that’s also InnoDB’s default. So far so good. For cluster setups,

      [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...]
    Install MySQL fork MariaDB 10.0.9 on CentOS release 6.5 with server_audit-1.1.5 and oqgraph-engine
    +0 Vote Up -0Vote Down

    I needed to test the new server audit plug-in on latest MariaDB 10.0.9
    More info about that handy plug in you may find here : http://www.skysql.com/downloads/mariadb-audit-plugin
    Take a moment to read the info, along with that nice blog : http://www.skysql.com/blogs/ralf-gebhardt/activating-auditing-mariadb-and-mysql-5-minutes

    In short:

    root@mariadb-10.0.9:[Mon Mar 24 07:51:54][/tmp/]$ lftp http://ftp.igh.cnrs.fr/pub/mariadb/mariadb-10.0.9/yum/
    cd ok, cwd=/pub/mariadb/mariadb-10.0.9/yum                                   
    lftp ftp.igh.cnrs.fr:/pub/mariadb/mariadb-10.0.9/yum> bookmark add mariadb-10.0.9
    lftp


      [Read more...]
    [MySQL][Spider][VP]Spider-3.2 VP-1.1 released
    +0 Vote Up -0Vote Down
    I'm pleased to announce the release of Spider storage engine version 3.2(rc) and Vertical Partitioning storage engine version 1.1(beta).
    Spider is a Storage Engine for database sharding.
    http://spiderformysql.com/
    Vertical Partitioning is a Storage Engine for vertical partitioning for a table.
    http://launchpad.net/vpformysql

    Please use the following for downloading binary file.
    http://spiderformysql.com/download_spider.html

    The main changes in this version are following.
    Spider
    - Add server parameter "spider_log_result_error_with_sql", "spider_version", "spider_internal_xa_id_type", "spider_casual_read", "spider_dry_access" and "spider_delete_all_rows_type".
    - Add table parameter











      [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...]
    Clustering SugarCRM with MySQL Galera for High Availability and Performance
    +1 Vote Up -0Vote Down
    March 20, 2014 By Severalnines

    SugarCRM is the leader in open source CRM systems, and has been adopted by some of the largest firms, including IBM. The CRM software includes all sales, marketing and support tools out of the box, and can also be extended to integrate social media sources. For those depending on SugarCRM, especially when deploying in cloud environments with lower SLAs, having a high availability architecture can make a lot of sense. 

    In this blog post, we will show you how to cluster SugarCRM Community Edition

      [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...]
    MariaDB 10.0.9 Overview and Highlights
    +1 Vote Up -0Vote Down

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

    https://downloads.mariadb.org/mariadb/10.0.9/

    This is the second RC (“Release Candidate”) release of MariaDB 10.0, and 10th overall release of 10.0. All features planned for MariaDB 10.0 GA are included in this release.

    There were 6 notable changes in MariaDB 10.0.9:

  • InnoDB upgraded to version 5.6.15
  • Extended-keys optimization is now enabled by default.
  • MariaDB can be compiled to use the system’s PCRE library.
  • Added MASTER_GTID_WAIT() and
  •   [Read more...]
    MariaDB 5.5.36 Overview and Highlights
    +1 Vote Up -0Vote Down

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

    https://downloads.mariadb.org/mariadb/5.5.36/

    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 couple items worth mentioning:

  • Includes all bugfixes and updates from: MySQL 5.5.36
  • TokuDB is now included in RPM packages for CentOS 6 on x86-64
  • Note this release did not contain the bugfixes from XtraDB 5.5.36 yet. There is one bug fix in XtraDB 5.5.36 that is fairly serious, so if you are a *heavy* XtraDB+ user, I might wait for MariaDB 5.5.37 to be released, so you get this fix. I should note the bug was partially fixed in

      [Read more...]
    March 20 Webinar: How to Scale MySQL for Big Data Applications
    +0 Vote Up -0Vote Down

    You may think that you have to buy, install, and get up to speed on a new database if you want to work with large amounts of data, but you can do more than you think with the MySQL you already have.
    Register Now!

    SPEAKER: Jon Tobin, Tokutek
    DATE: Thursday, March 20th
    TIME: 1pm ET

    Without having to change your application or do special tuning you can increase performance and save significant time and money when you need to scale.

    Join Tokutek’s Jon Tobin as he demonstrates how to use MySQL or MariaDB in Big Data applications by simply upgrading the storage engine with TokuDB, and how to effectively evaluate TokuDB for increased performance, compression and agility.

    During this webinar you will learn:

    • How to dramatically increase performance without having to rewrite



      [Read more...]
    No application changes needed: 10 times faster slave with MariaDB 10 parallel replication
    +3 Vote Up -1Vote Down

    Parallel replication is in MariaDB 10.0. I did some benchmarks on the code in 10.0.9. The results are quite good! Here is a graph that shows a 10-times improvement when enabling parallel replication: The graph shows the transaction per second as a function of number of slave worker threads, when the slave is executing events from the master at full speed. The master binlog was generated with sysbench oltp.lua. When the binlog is enabled on the slave and made crash-safe (--sync-binlog=1 --innodb-flush-log-at-trx-commit=1), the slave is about ten times faster at 12 worker threads and above compared to the old single-threaded replication.

    These results are for

      [Read more...]
    Webinar Replay & Slides: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster
    +0 Vote Up -0Vote Down
    March 13, 2014 By Severalnines

    Thanks to everyone who attended this week’s webinar; if you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

     

    Special thanks to Seppo Jaakola, CEO at Codership, the creators of Galera Cluster, and to Johan Andersson, CTO at Severalnines, for their presentations and the live demo.

     

    Webinar topics discussed: 

    • Application use cases for Galera
    • Schema design
    • Events and Triggers
    • Query design
    • Migrating the schema
    • Loading initial data into the
      [Read more...]
    Team Sphinx to the MySQL User Conference!
    +1 Vote Up -0Vote Down
    MySQL is the world’s most popular open source database. Sphinx allows MySQL users to search text (and more) at scale, without choking-out their favorite database. It’s a match made in the big data heavens. So, it shouldn’t be a surprise that this year, like many years before, we’ll be heading to the Percona Live MySQL [...]
    How to use the ClusterControl REST API to automate your Database Cluster
    +0 Vote Up -0Vote Down
    March 11, 2014 By Severalnines

    For ops folks with multiple environments and instances to manage, a fully programmable infrastructure is the basis for automation. ClusterControl exposes all functionality through a REST API. The web UI also interacts with the REST API to retrieve monitoring data (cluster load, alarms, backup status, etc.) or to send management commands (add/remove nodes, run backups, upgrade a cluster, add/remove load balancer, etc.). The API is written in PHP and runs under Apache. The diagram below illustrates the architecture of ClusterControl.

    Figure: ClusterControl

      [Read more...]
    MariaDB 10.0.9 now available
    +0 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.9. This is a Release Candidate release.

    Among other changes, XtraDB is now the default InnoDB implementation, Oracle’s InnoDB is included as a plugin and can be dynamically loaded if desired. Packages for Ubuntu 14.04 “trusty” and Debian “Sid” have also been added to the MariaDB Ubuntu and Debian repositories.

    See the Release Notes and Changelog for detailed information on this release and the

      [Read more...]
    Book review: Getting started with MariaDB
    +2 Vote Up -0Vote Down

    Getting started with MariaDB, by Daniel Bartholomew, is a good book for people who wants to approach MariaDB without knowing MySQL. While this book covers all basic topics, it provides a vast overview of what MariaDB is and can do. In other words: the text is not just about SQL queries.

    The book also mentions topics that are not strictly related to MariaDB, but are important for MariaDB users; for

      [Read more...]
    Showing entries 1 to 30 of 717 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.