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 61 to 90 of 32142 Next 30 Older Entries
Replication Sync Checking Algorithms
+0 Vote Up -0Vote Down

I was interested to see the announcement of a MySQL replication synchronization checker utility from Oracle recently. Readers may know that I spent years working on this problem. The tool is now known as pt-table-checksum in Percona Toolkit, but the original work started in 2006. I would say that I personally have spent at least 6 months working on that; adding up all the other Percona Toolkit developers, there might be several man-years of work invested. (I’m not with Percona anymore.)

The pt-table-checksum tool has been reinvented about three times as I and others learned more about the difficult and subtle problems involved. But if it were still a project I worked on, I’d still not be happy with it. It causes too much load on servers and does needless work. Solving that

  [Read more...]
MySQL Enterprise Backup 3.10: Teasing compression.
Employee +0 Vote Up -0Vote Down

Ok, so I wanted to look into the new compression options of MEB 3.10.

And I would like to share my tests with you. Remember, they’re just this, tests, so please feel free to copy n paste and obtain your own results and conclusions, and should I say it, baselines, in order to compare future behaviour, on your own system.

An Oracle Linux 6.3 virtual machine with 3Gb RAM, 2 virtual threads, on a 1x quad core, windows laptop. Not pretty, but hey.

So, these tests are solely about backup. I’ll do restore when I get some *more* time.

 

First up, lets compare like with like, i.e. MEB version 3.9 & 3.10:

Let’s make this interesting, hence, want to use as much resources available as possible, read, write, process threads and number of buffers.

mysqlbackup --user=root --password=oracle
  [Read more...]
MySQL Enterprise Backup 3.10: Teasing compression.
Employee +0 Vote Up -0Vote Down

Ok, so I wanted to look into the new compression options of MEB 3.10.

And I would like to share my tests with you. Remember, they’re just this, tests, so please feel free to copy n paste and obtain your own results and conclusions, and should I say it, baselines, in order to compare future behaviour, on your own system.

An Oracle Linux 6.3 virtual machine with 3Gb RAM, 2 virtual threads, on a 1x quad core, windows laptop. Not pretty, but hey.

So, these tests are solely about backup. I’ll do restore when I get some *more* time.

 

First up, lets compare like with like, i.e. MEB version 3.9 & 3.10:

Let’s make this interesting, hence, want to use as much resources available as possible, read, write, process threads and number of buffers.

mysqlbackup --user=root --password=oracle
  [Read more...]
New SQLyog and MONyog coming – please upgrade soon!
+1 Vote Up -0Vote Down

We are about to release upgrades to both SQLyog and MONyog with an important fix: linked libraries possibly vulnerable to the ‘Heartbleed’ OpenSSL bug have been upgraded to non-affected versions (the new MONyog release will have a few more fixes as well).

Since this security issue became known a few days ago, media and Internet have swollen with information about vulnerable systems. There is probably both a lot of facts and fiction circulating.

A good summary appeared in the Percona blog. It mostly focuses on server-side vulnerabilities. However

  [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...]
OpenSSL Heartbleed Security Update
+0 Vote Up -0Vote Down
Fri, 2014-04-11 07:56rasmusjohansson

As some of you may know, CVE-2014-0160 (“Heartbleed”) announced a vulnerability in certain versions of OpenSSL.

After the announcement on Monday 7th April 2014, the team began investigating the level of potential risk to our hosted systems and on-premise software.

Hosted Systems

Since SkySQL.com and MariaDB.com use OpenSSL in its platforms it was deemed necessary to immediately update all platforms with the recommended security patches.

Please be assured that our online systems are no longer at risk from this vulnerability.

We recommend that all users of SkySQL and MariaDB online

  [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...]
MongoDB, TokuMX and InnoDB for concurrent inserts
+0 Vote Up -0Vote Down
I used the insert benchmark with concurrent insert threads to understand performance limits in MongoDB, TokuMX and InnoDB. The database started empty and eventually was much larger than RAM. The benchmark requires many random writes for secondary index maintenance for an update-in-place b-tree used by MongoDB and InnoDB. The test server has fast flash storage. The work per transaction for this test is inserting 1000 documents/rows where each document/row is small (100 bytes) and has 3 secondary indexes to maintain. The test used 10 client connections to run these transactions concurrently and each client uses a separate collection/table. The performance summaries listed below are based on the context for this test -- fast storage, insert heavy with secondary index maintenance. My conclusion from running many insert benchmark tests is that I don't want to load big databases with  [Read more...]
MySQL 5.6.17 Overview and Highlights
+1 Vote Up -0Vote Down

MySQL 5.6.17 was recently released (it is the latest MySQL 5.6, is GA), and is available for download here:

For this release, I counted 7 “Functionality Added” and/or “Incompatible Change” fixes:

  • Incompatible Change: The AES_ENCRYPT() and AES_DECRYPT() functions now permit control of the block encryption mode and take an optional initialization vector argument.
  • Incompatible Change: The ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE, and NO_ZERO_IN_DATE SQL modes now are deprecated and setting the sql_mode value to include any of them generates a warning. In MySQL 5.7, these modes do nothing. Instead, their effects are included in the effects of
  •   [Read more...]
    Percona Live Recap
    +1 Vote Up -0Vote Down

    I had a great time at Percona Live. I think this was the best MySQL conference I’ve ever been to. (The food was excellent too. The fastest way to a man’s heart is through his stomach.)

    The talks I attended were very good. Jay Janssen’s tutorial on Percona XtraDB Cluster was impressive. I can’t imagine how much time he must have spent preparing for that.

    I was very happy that Oracle, MariaDB, and WebScaleSQL had a strong presence, too. There were also a lot of one-degree-of-separation talks on topics like Hadoop and so forth. I attended a talk by Google on how their F1 database works. The biggest surprise in that talk? F1 is more expensive for them to operate than MySQL. I expected that anything they built in-house would surely be more cost effective, but I was wrong.

    The community awards and lightning talks were fun as always. My co-founder

      [Read more...]
    PHP mysqlnd memory optimizations: from 49MB to 2MB
    Employee +0 Vote Up -0Vote Down

    Inspired by Antony, Andrey has implemented a memory optimization for the PHP mysqlnd library. Depending on your usage pattern and the actual query, memory used for result sets is less and free’d earlier to be reused by the PHP engine. In other cases, the optimization will consume about the same or even more memory. The additional choice is currently available with mysqli only.

    From the network line into your script

    Many wheels start spinning when mysqli_query() is called. All the PHP MySQL APIs/extensions (mysqli, PDO_MySQL, mysql) use a client library that handles the networking details and provides a C API to the C extensions. Any recent PHP will default to use the mysqlnd library. The library speaks

      [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...]
    The MySQL Optimizer Cost Model Project
    Employee_Team +3 Vote Up -0Vote Down

    You may not be aware of this but the foundation that the MySQL optimizer builds on when choosing a query plan – the cost model – is for the most part very old. At least in tech terms.

    Much of it was written in another millennium, at a time when “Forest Gump” and “Titanic” won Oscars and “Baywatch” was the big thing on TV. Although the revision history doesn’t go that far back, it wouldn’t come as a surprise if it predates that annoying “Macarena” song and even “The Sign” (Ace Of Base) – don’t follow those links unless you’re feeling very brave…

    Thankfully, a lot has happened since Ace of

      [Read more...]
    Oracle MySQL Tech Tour event in Helsinki 7th of May
    Employee +3 Vote Up -0Vote Down

    Marko Mäkelä from InnoDB engineering team will deliver session on " InnoDB on-line schema changes and improved durability in MySQL 5.7"

    Are you about to develop a new modern web-based application, wondering what the best database solution is for you? Would you like to learn how to use NoSQL access to MySQL, as well as the new MySQL Database and MySQL Cluster features to build next generation applications?

    Join us for this “Performance, Scalability and High Availability with MySQL” Tech Tour! You will hear directly from the source about the latest MySQL innovations from Oracle, including how the MySQL 5.7 Development Milestone Releases yet again significantly increase the performance of MySQL, and how the new MySQL Fabric provides you with a framework for both High-Availability and




      [Read more...]
    Percona Live MySQL Conference Highlights
    +0 Vote Up -0Vote Down

    The Percona Live MySQL Conference and Expo 2014 was March 31st through April 4th in Santa Clara, California. I heard numerous positive comments from attendees and saw even more on social media. Our conference team lead by Kortney Runyan pulled together a smooth, enjoyable event which made it easy for attendees to focus on learning and networking. Some of the Percona Live MySQL Conference highlights from this year follow.

    Percona Live MySQL Conference Highlights

    A few stats for the conference this year versus last year:

    • Total registrations were up nearly 15%
    • Attendees represented 40 countries, up from 36 in 2013
    • 34 companies sponsored the conference this year, up from 33 last year
    • This year’s conference covered 5 days including
      [Read more...]
    How Tokutek uses the Random Query Generator framework to test TokuDB
    +0 Vote Up -0Vote Down

    During a typical release cycle for TokuDB at Tokutek, we spend time qualifying and hardening the product using numerous tools.  For example, we run stress and unit tests directly on the Fractal Tree indexes, MySQL Test Runner (MTR) tests on the storage engine as well as numerous performance benchmarks to prevent regressions. In addition, we have recently been implementing the Random Query Generator (RQG) framework internally here at Tokutek to more exhaustively stress TokuDB.  My name is Joel Epstein and I am a Quality Assurance Engineer here at Tokutek who has been integrating RQG into the overall test plan strategy.

    At

      [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...]
    Heartbleed: Separating FAQ From FUD
    +1 Vote Up -0Vote Down

    If you’ve been following this blog (my colleague, David Busby, posted about it yesterday) or any tech news outlet in the past few days, you’ve probably seen some mention of the “Heartbleed” vulnerability in certain versions of the OpenSSL library.

    So what is ‘Heartbleed’, really?

    In short, Heartbleed is an information-leak issue. An attacker can exploit this bug to retrieve the contents of a server’s memory without any need for local access. According to the researchers that discovered it, this can be done without leaving any trace of compromise on the system. In other words, if you’re vulnerable, they can steal your keys and you won’t even notice that they’ve gone missing. I use the word

      [Read more...]
    "Minute-to-win-it" Blue Studio by Beats - Heterogenous Replication Survey
    +0 Vote Up -0Vote Down
    Continuent would like to better understand the relationships and data flows that exist between different database systems that you are using to understand your replication and data integration needs better. In particular, we'd like to know about any heterogeneous data exchanges, including manual dump/load and automated process, and whether non-database sources, such as Twitter and Facebook,
    MySQL for Excel new features (1.2.0): Edit Connections
    Employee +1 Vote Up -0Vote Down

    Welcome to another post of the MySQL for Excel team, this time we will talk about another cool feature you can find in our latest release to date (1.2.0) which can be downloaded directly from our MySQL Installer downloads page.

    If you want to learn how you can easily edit connections directly from the main MySQL for Excel panel now please read this post.

    If you would like to give us your feedback and propose new features you would like to see on future versions of MySQL for Excel we encourage you to please visit our forum and leave us a comment.
    Thank you for your support!

    Porting from Oracle to MySQL
    +0 Vote Up -0Vote Down
    A potential customer asked my about porting her application from Oracle Database to MySQL.

    I always try to start with the "why" (a dear friend bought me this book, recommended: http://www.amazon.com/Start-Why-Leaders-Inspire-Everyone/dp/1591846447).

    She said "cloud!". I said "OK!".

    I conducted a short research, found many things in many places all over the place, brought them to a nice email I sent her back and then thought I'll post it here and make it public as it might be useful for us all. If you feel that I missed something, add comments, send feedback.

    These are the leading tools to do the actual migration of the data structure, data export/import, sprocs, triggers, etc.:
  • MySQL Workbench has a migration feature: http://www.mysql.com/products/workbench/migrate/
  • MySQLYog can be used to migrate:









  •   [Read more...]
    Making Use of Boost Geometry in MySQL GIS
    Employee_Team +1 Vote Up -0Vote Down

    This post talks about how we make use of Boost.Geometry in MySQL to implement reliable and efficient GIS functionality, as well as changes to the GIS features in the lab release.

    Prerequisite

    This article assumes the reader knows about the basic geometry database concepts defined by the OGC. That includes WKT, WKB, the 8 kinds of spatial relationship checks—contains, within, intersects, disjoint, crosses, touches, overlaps, and equals—along with the 4 types of spatial set operations—intersection, union, difference, and symdifference. You can find a list of OGC Simple Feature Access standards, along with additional information on the aforementioned topics here.

    Terms & Abbreviations

    BG: Boost.Geometry

      [Read more...]
    MySQL 5.6.17 Community Release Notes
    Employee +2 Vote Up -0Vote Down

    Thank you to the MySQL Community, on behalf of the MySQL team @ Oracle. Your bug reports, testcases and patches have helped create a better MySQL 5.6.17.

    In particular:

    • Thanks to Anthony Pong for reporting a confusing error message when mysql_install_db could not locate the required Perl modules. Bug #69844.
    • Thanks to Jervin Real for reporting a recently introduced performance regression with compressed InnoDB tables. Bug #71436.
    • Thanks to Laurynas Biveinis for reporting a race condition in InnoDB on shutdown. Bug #70430.
    • Thanks to Jervin Real for reporting that innodb_data_file_path could not be specified in
      [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...]
    MySQL 5.7: Performance Schema Improvements, Percona Live
    Employee +1 Vote Up -0Vote Down

    I had a great time last week at Percona Live, meeting up with lots of old friends, and getting to know lots of new ones.

    It was great to meet many of the people that hang around on DBHangOps face to face. Geoff even got a community award (well done)! Unfortunately I had to miss the lunch.

    It was also good to see Oracle getting a community award. Our engineers are extremely hard working, and all want to help community and customers alike be successful with their MySQL environments. There was lots of great positive attitude towards the work we’ve been doing, it was pleasing to hear that we are on the right track.

    I haven’t been to a conference at that venue since

      [Read more...]
    Collaborate 14, Las Vegas, and the Naked Guy Occupying My Hotel Room
    Employee +1 Vote Up -0Vote Down

    Colaborate is a big show for C-level executives and up for the three big Oracle User Groups. Last week at Percona Live was all MySQL, Open Source, and a few hundred close folks. This week is the biggest show, after Oracle Open World, on the Oracle user calendar and draws a huge crowd from around the globe. All the Fortune 500 are here or their contractors. In short, anything tangential to any Oracle product can be found along with companies that offer add-ons, support, consulting, and product. A lot of the attendees have MySQL in their computer rooms and that is why I am in Las Vegas.

    Vegas is a convention

      [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

    Percona Live Highlights
    Employee +1 Vote Up -0Vote Down

    Last week marked my first April-MySQL-Conf since 2009, and now that I’m back home I wanted to reflect on some of my personal highlights.


    Photo Credit: @miguel2angel


      [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 [...]
    OpenSSL heartbleed CVE-2014-0160 – Data leaks make my heart bleed
    +0 Vote Up -0Vote Down

    The heartbleed bug was introduced in OpenSSL 1.0.1 and is present in

    • 1.0.1
    • 1.0.1a
    • 1.0.1b
    • 1.0.1c
    • 1.0.1d
    • 1.0.1e
    • 1.0.1f

    The bug is not present in 1.0.1g, nor is it present in the 1.0.0 branch nor the 0.9.8 branch of OpenSSL some sources report 1.0.2-beta is also affected by this bug at the time of writing, however it is a beta product and I would really recommend not to use beta quality releases for something as fundamentally important as OpenSSL in production.

    The bug itself is within the heartbeat extension of OpenSSL (RFC6520). The bug allows an attacker to leak the memory in up to 64k chunks, this is not to say the data being leaked is limited to 64k as the attacker can continually abuse this bug to leak data, until they are satisfied with

      [Read more...]
    Previous 30 Newer Entries Showing entries 61 to 90 of 32142 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.