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 32189 Next 30 Older Entries
Managing farms of MySQL servers with MySQL Fabric
+0 Vote Up -0Vote Down

While built-in replication has been a major cause for MySQL’s wide adoption, official tools to help DBAs manage replication topologies have typically been missing from the picture. The community has produced many good products to fill in this gap, but recently, Oracle has been filling it too with the addition of MySQL Utilities to the mix.

One part of the Utilities that has been generating interest recently is MySQL Fabric, and we will be discussing this project in an upcoming series of blog

  [Read more...]
Shard-Query 2.5 is now released
+0 Vote Up -0Vote Down

Shard-Query 2.5 has been a long time coming, but the release is finally officially out the door.

There are numerous changes from the last major release including:

  •  Improved parser – fully handles complex expressions
  •  LOAD DATA INFILE support and S3 support
  •  Semi-join materialization for IN and NOT IN subqueries
  •  Improved support for subqueries in the FROM clause
  •  INSERT .. SELECT and CREATE TABLE .. SELECT support
  •  Ability to do range lookups on the shard key (IN/BETWEEN/etc)
  •  Improved proxy – supports SHOW commands too
  •  Support for all MySQL SELECT dialect including WITH ROLLUP
  •  Custom aggregate function support
  •  Asynchronous query support
  •  Numerous bug fixes

You can find it here



  [Read more...]
Geographically distributed multi-master MySQL clusters
+0 Vote Up -0Vote Down
In today's webinar, we discuss the multi-master capabilities of Continuent Tungsten to help you build and manage systems that spread data across multiple sites.  We cover important topics such as setting up large scale topologies, handling failures, and how to handle data privacy issues like removing personally identifiable information or handling privacy law restrictions on data movement. We
DFW Unix User group talk May 1st
Employee +2 Vote Up -0Vote Down

Come hear about MySQL at the May 1st DFWUUG Dallas / Fort Worth Unix User group Meeting. Always a great crowd, good pizza, and fun. Seven PM at NEW IBM Innovation Center at 1177 South Beltline Road, in Coppell,


The Perfect Server - Ubuntu 14.04 (Apache2, PHP, MySQL, PureFTPD, BIND, Dovecot, ISPConfig 3)
+0 Vote Up -0Vote Down

The Perfect Server - Ubuntu 14.04 (Apache2, PHP, MySQL, PureFTPD, BIND, Dovecot, ISPConfig 3)

This tutorial shows how to prepare an Ubuntu 14.04 (Trusty Tahr) server (with Apache2, BIND, Dovecot) for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache or nginx web server, Postfix mail server, Courier or Dovecot IMAP/POP3 server, MySQL, BIND or MyDNS nameserver, PureFTPd, SpamAssassin, ClamAV, and many more. This setup covers Apache (instead of nginx), BIND (instead of MyDNS), and Dovecot (instead of Courier).

MySQL at OpenSUSE Conference, Dubrovnik, Croatia & JavaScript UnConference, Hamburg, Germany
Employee_Team +1 Vote Up -0Vote Down

The OpenSUSE Conference in Dubrovnik, Croatia started today and will continue till Monday April 28, 2014. MySQL team is going to be part of this event. Do not miss to visit our booth, which will be located on the ground floor as well as come to listen 2 MySQL talks (see OpenSUSE schedule):

  • Georgi Kodinov is going to have a talk about "Protect your MySQL server". His talk is scheduled for Friday, April 25, 2014 @ 13:00 in Ragusa mtg.room 
  • Norvald Ryeng will talk about "The upstream view" - Package maintenance as seen from MySQL Engineering. His talk is scheduled for Sunday, April 27, 2014 @ 13:00 in Ragusa mtg.room

For the whole conference plan you can check the

  [Read more...]
Importing Raster Based Spatial Data into MySQL 5.7
Employee_Team +1 Vote Up -0Vote Down

Setting up the Geospatial Data Abstraction Library
GDAL 1.10+ (by OS Geo) supports converting spatial data between various raster and vector (points, lines, polygons, etc.) based formats, along with supporting MySQL. MySQL and ESRI Shapefiles are generally the best supported combination today.

Version 1.10 of GDAL has big improvements over older versions, but most linux distros (EL6 has GDAL 1.7) only have packages for the older versions. I would recommend building the latest 1.11 RC release from source because the


  [Read more...]
Abdel-Mawla Gharieb: How to Setup MySQL Master/Slave Replication ?
+1 Vote Up -0Vote Down

It's not usual to find an easy source on how to setup MySQL replication, I thought it might be useful at least for the beginners to write a direct and simple howto blog on setting up Master/Slave replication in MySQL.

Before going through the replication setup steps, I think it's better to explain first how Replication works in MySQL.

MySQL replication is mainly consists of three-part process:

  • The master server records all data changes to its binary logs (binary log events) and send it to the slave using a thread called (Binlog dump thread) once the slave connects to the master.
  • The slave copies the binary log events sent by the master's binlog dump thread to its relay logs using a thread called (Slave I/O thread).
  • The slave applies these changes from the relay logs to its data by replaying (executing) all events using a thread called
  [Read more...]
Encrypted and incremental MySQL backups with Percona XtraBackup
+0 Vote Up -0Vote Down

We’ve recently received a number of questions on how to implement incremental MySQL backups alongside encryption with Percona XtraBackup. Some users thought it was not initially possible because with the default

--encrypt
options with XtraBackup, all files will be encrypted, but alas, that is not the case. This is where the option
--extra-lsn-dir
becomes useful, because it allows you to save LSN (Log Sequence Number) information to another directory and exclude it from encryption, allowing you to use the same information needed by incremental backups. Enough talk, let me show you.

Because you would want to usually script your backup and restore procedure, I’d use variables here as well to make you more familiar. First,

  [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
+1 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
  • Really large NLP corpora
    +0 Vote Up -0Vote Down

    Jeeze people. You’re all noisy. I’m sure it was all done for posterity’s sake.

    23M     irclogs/MagNET/#perl.log
    29M     irclogs/freenode/#mysql.log
    36M     irclogs/freenode/#debian.log
    37M     irclogs/foonetic/#xkcd.log
    39M     irclogs/OFTC/#debian.log
    43M     irclogs/freenode/#jquery.log
    44M     irclogs/freenode/#perl.log
    
    $ for file in irclogs/MagNET/#perl.log irclogs/freenode/#mysql.log irclogs/freenode/#debian.log irclogs/foonetic/#xkcd.log irclogs/OFTC/#debian.log irclogs/freenode/#jquery.log irclogs/freenode/#perl.log; do echo -n "$file: " ; head -1 $file ; done
    irclogs/MagNET/#perl.log: --- Log opened Thu May 26 08:31:32 2011
    irclogs/freenode/#mysql.log: --- Log opened Wed Dec 28 09:03:49 2011
    irclogs/freenode/#debian.log: --- Log opened Tue Mar 12 12:52:40 2013
    irclogs/foonetic/#xkcd.log: --- Log opened Wed Dec 28 19:33:43 2011
    irclogs/OFTC/#debian.log: --- Log
      [Read more...]
    FYI: Galera is just a provider
    +1 Vote Up -0Vote Down

    No news in telling Galera is the synchronous multi master solution for MySQL.
    But Galera is just a provider.

    What do you mean by provider?

    Remember configuring “Galera”?
    There are two options
    wsrep_provider and wsrep_provider_options
    These define the provider (Galera) and the options for the provider.
    The rest of the wsrep_ options are for wsrep.

    https://launchpad.net/wsrep

    wsrep API defines a set of application callbacks and replication library calls necessary to implement synchronous writeset






      [Read more...]
    Concurrent, read-only, not cached: MongoDB, TokuMX, MySQL
    +0 Vote Up -0Vote Down
    I repeated the tests described here using a database larger than RAM. The test database has 8 collections/tables with 400M documents/rows per table. I previously reported results for this workload using a server with 24 CPU cores and a slightly different flash storage device. This time I provide a graph and use a server with more CPU cores. The goal for this test is to determine whether the DBMS can use the capacity of a high-performance storage device, the impact from different filesystem readahead settings for MongoDB and TokuMX and the impact from different read page sizes for TokuMX and InnoDB. It will take two blog posts to share everything. I think I will have much better QPS  [Read more...]
    Help fill the MySQL Track At SELF
    Employee +1 Vote Up -0Vote Down

    Help fill up the MySQL track at the Southeast Linux Fest. RFP for #self2014 has been extended to Mon April 28th at 9 PM ET. Last chance! Get those talk submissions in!


    RW locks are hard
    +1 Vote Up -0Vote Down
    MongoDB and TokuMX saturated at a lower QPS rate then MySQL when running read-only workloads on a cached database with high concurrency. Many of the stalls were on the per-database RW-lock and I was curious about the benefit from removing that lock. I hacked MongoDB to not use the RW-lock per query (not safe for production) and repeated the test. I got less than 5% more QPS at 32 concurrent clients. I expected more, looked at performance with PMP and quickly realized there were several other sources of mutex contention that are largely hidden by contention on the per-database RW-lock. So this problem won't be easy to fix but I think it can be fixed.

    The easy way to implement a reader-writer lock uses the pattern

      [Read more...]
    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

    Newbie password mistake
    Employee +2 Vote Up -0Vote Down

    I received a panic call from a newbie MySQL DBA. Or should I say the ‘Linux Admin’/’MySQl DBA’/’CSS guru’/’PHP Programmer’/’Network Admin’/’Backup Operator’/’CIO’ of a small business. He had reset his password was was now locked out. Luckily, he had only changed his password and still had root access.

    What he did:
    mysql>use mysql;
    SET PASSWORD for 'mrdoesall'@'10.%' to 'bigsecret';
    mysql>

    Long time MySQL DBAs should be groaning at this with a wince remembering when it happened to them. For those of you who did not catch the problem, what happened is that he value in the user.password table is set to the string ‘bigsecret’. When our friend tries to login, the password is encrypted and compared to the value





      [Read more...]
    MySQL Connect — Reviewing the submitted presentations
    Employee +2 Vote Up -0Vote Down

    The presentations submitted for MySQL Connect are amazing. This year again I am very fortunate and slightly cursed to be on the selection committee again. Fortunate that I get a glimpse of some truly amazing work being done with MySQL. And cursed in that there are a lot of great talks that will not make it that I still want to see.

    We had over 190 submissions for 50 some odd speaking slots. In the past there has been some over lap with two members of the same engineering team proposing slight variations on a topic that can be combined. Sometimes there are blatantly obvious marketing sessions that will not only speed you queries, brighten you teeth, but also walk your dog. Usually it is easy to pick out a few obviously poor proposals. But not this

      [Read more...]
    Percona Live 2014 behind; MySQL ahead
    +0 Vote Up -0Vote Down

    I started using MySQL 11 years ago.  That’s not too long compared to other people in the industry, but nonetheless here’s my perspective on the state of the MySQL industry after attending Percona Live MySQL Conference & Expo 2104.

    In short, the attitude around MySQL has changed from “Does it work?” to “Is it fast and reliable?” to “How do we manage it?” To further generalize, these periods correspond roughly to the original MySQL AB team, Percona and Oracle, and the last period is the current period so key players are emerging, like WebScaleSQL.

    Does it work?

    Peter Zaitsev said in one of his

      [Read more...]
    It is event season for SkySQL and MariaDB: Where will we see you next?
    +0 Vote Up -0Vote Down

    The conference season has begun for us here at SkySQL. It seems like the almost all linux and MySQL shows are in the next four months. This is the time of year that we get to collect those airline points, have our beds made for us, eat out a few times a day and put on a few pounds! I have been practicing for this all year. Check out our Events Section to see all of our upcoming events.

    read more

    It is event season for SkySQL and MariaDB: Where will we see you next?
    +0 Vote Up -0Vote Down

    The conference season has begun for us here at SkySQL. It seems like the almost all linux and MySQL shows are in the next four months. This is the time of year that we get to collect those airline points, have our beds made for us, eat out a few times a day and put on a few pounds! I have been practicing for this all year. Check out our Events Section to see all of our upcoming events.

    read more

    Updates from VividCortex
    +0 Vote Up -0Vote Down

    What's new in VividCortex? We'll do these blog posts once a week to let you know all of the changes such as new features, bug fixes, performance improvements, and even a peek into the future.

    Upcoming Events

    If you haven't seen the VividCortex application in action, please register for a live demo on production systems on May 14th.

    Catch us at the following upcoming events:

    Upcoming Improvements

    • Agent management UI in the web application.
    • Agent performance improvements.
    • Events dashboard redesign and performance improvements.
    • Replication dashboard, for real-time live updating view of your replication topology and
      [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...]
    Concurrent, read-only & cached: MongoDB, TokuMX, MySQL
    +1 Vote Up -0Vote Down
    This has results for a read-only workload where all data is cached. The test query fetches all columns in one doucment/row by PK. For InnoDB all data is in the buffer pool. For TokuMX and MongoDB all data is in the OS filesystem cache and accessed via mmap'd files. The test server has 40 CPU cores with HT enabled and the test clients share the host with mysqld/mongod to reduce variance from network latency. This was similar to a previous test, except the database is in cache and the test host has more CPU cores. The summary of my results is:
    • MongoDB 2.6 has a performance regression from using more CPU per query. The regression might be limited to simple queries that do single row lookups on the _id index. I spent a bit of time rediscovering how to get hierarchical

      [Read more...]
    Using mysqldump and the MySQL binary log – a quick guide on how to backup and restore MySQL databases
    +0 Vote Up -0Vote Down

    Be sure to check out my other posts on mysqldump:
    - Scripting Backups of MySQL with Perl via mysqldump
    - Splitting a MySQL Dump File Into Smaller Files Via Perl
    - Creating and restoring database backups with mysqldump and MySQL Enterprise Backup – Part 1 of 2
    - Creating and restoring database backups with mysqldump and



      [Read more...]
    MySQL Community Awards: Community Contributor of the Year 2014
    +1 Vote Up -0Vote Down

    As one decompresses from the active month that April brings to the MySQL ecosystem, its worth noting that I received a MySQL Community Award – Community Contributor of the Year 2014 award at the Percona Live MySQL Conference & Expo 2014 in Santa Clara. I was extremely happy and thankful to receive such an award and I still am. Thank you MySQL Community.

    My reason for winning, now immortalised:

    Colin’s list of service to the MySQL Community goes back almost 10

      [Read more...]
    See you at ICTexpo Helsinki 2014
    +0 Vote Up -0Vote Down
    ICTexpo Helsinki 2014 offers two effective days full of innovations, inspiration and information - the biggest professional IT show in the Nordics with large scale of solutions to help you to take your business to the next level. Continuent will be exhibiting in Red Hat Village [booth 5f31], which gathers the most significant enterprise level companies from the Open Source ecosystem in Finland
    MySQL April Newsletter: Latest MySQL Product Releases and More
    Employee_Team +1 Vote Up -0Vote Down

    MySQL April Newsletter is now available! Read this edition to learn more details about the abundant product announcements we made recently, including MySQL 5.7 Development Milestone Release, MySQL Workbench 6.1 GA, as well as the Release Candidate of MySQL Fabric. You'll also find information regarding the latest white papers (http://www.mysql.com/why-mysql/white-papers/), upcoming webinars (http://www.mysql.com/news-and-events/web-seminars/) and events (http://www.mysql.com/news-and-events/events/), and technical blogs for tips and tricks using MySQL.

    Enjoy and hope you find it informative! 

    MySQL for Visual Studio 1.2.0 alpha has been released
    Employee +0 Vote Up -0Vote Down
    MySQL for Visual Studio is a product including all of the Visual Studio integration previously available as part of Connector/Net. The 1.2.0 version is an alpha release of this product that intents to introduce users to the new features in this version.
    Showing entries 1 to 30 of 32189 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.