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

Displaying posts with tag: mysql (reset)

My talks about MySQL, Galera and LXC (and friends)
+0 Vote Up -0Vote Down

Im giving some talks this year:

MySQL Hochverfügbar mit Galera

Location: FrOSCon

About: Learn about Galera and deploy it using LXC and Ansible

LBaaS-Loadbalancer as a Service

Place: GUUG Frühjahrsgespräche

Topic: It is a workshop ( together with Jan Walzer and Jörg Jungermann). We are going to show how to use LXC to provide slim loadbalancers.

Medley der Containertechniken

Place: GUUG Frühjahrsgespräche

Topic: Learn about all the basic techniques vanilla based Container technology uses/shares (Namespaces, Cgroups und Chroot). Have a look at some of them (LXC, Libvrit, systemd-nspawn and Docker)

MySQL Replikation: Von den Anfängen in die Zukunft

Place: DOAG 2014

Topic: Learn about the past and the future of MySQL (and MariaDB) replication.

Reference architecture for a write-intensive MySQL deployment
+0 Vote Up -0Vote Down

We designed Percona Cloud Tools (both hardware and software setup) to handle a very high-intensive MySQL write workload. For example, we already observe inserts of 1bln+ datapoints per day. So I wanted to share what kind of hardware we use to achieve this result.

Let me describe what we use, and later I will explain why.

Server:

  • Chassis: Supermicro SC825TQ-R740LPB 2U Rackmount Chassis
  • Motherboard: Supermicro X9DRI-F dual socket
  • CPU: Dual Intel Xeon Ivy Bridge E5-2643v2 (6x 3.5Ghz cores, 12x HT cores, 25M L3)
  • Memory: 256GB (16x 16GB 256-bit quad-channel) ECC registered DDR3-1600
  • Raid: LSI MegaRAID 9260-4i 4-port 6G/s hardware RAID controller, 512M buffer
  • MainStorage: PCIe SSD HGST FlashMAX II 4.8TB
  • Secondary
  [Read more...]
Announcing ClusterControl Support for MariaDB 10
+0 Vote Up -0Vote Down
July 22, 2014 By Severalnines

We just wanted to make it official: Severalnines ClusterControl now supports MariaDB 10!

 

As most of you know will know by now, MariaDB 10 is the newest and most advanced version of the popular MariaDB relational database system. Whilst remaining application-compatible with the MySQL database, it adds many new capabilities to address the most challenging web and enterprise application use cases. Cluster deployments would be based on MariaDB Galera Cluster 10, which is a complete merge of MariaDB 10.0.12 and Galera Cluster. 

 

ClusterControl for MariaDB Clusters

 

  [Read more...]
MySQL Connector/NET 6.9.2 RC has been released
Employee +1 Vote Up -0Vote Down

Dear MySQL users,

MySQL Connector/Net 6.9.2 a new version of the all-managed .NET driver for MySQL has been released. This is a RC release for 6.9.x and is not recommended for production environments.

It is appropriate for use with MySQL server versions 5.5-5.7.

It is now available in source and binary form fromhttp://dev.mysql.com/downloads/connector/net/#downloadsandmirrorsites

(note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

Enjoy and thanks for the support!

On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team.

Percona XtraDB Cluster 5.6.19-25.6 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on July 21st 2014. Binaries are available from downloads area or from our software repositories. We’re also happy to announce that Ubuntu 14.04 LTS users can now download, install, and upgrade Percona XtraDB Cluster 5.6 from

  [Read more...]
MySQL for Visual Studio 1.2.2 RC has been released
Employee +2 Vote Up -0Vote Down
Dear MySQL users,
MySQL for Visual Studio is a product including all of the Visual Studio integration. The 1.2.2 version is a release candidate release of this product which is feature complete but still can contain minor bugs and is not suitable for production environments.
This version is appropriate for use with MySQL server versions 5.5-5.6.
How To Install Nginx With PHP And MySQL (LEMP Stack) On CentOS 7
+0 Vote Up -0Vote Down

How To Install Nginx With PHP And MySQL (LEMP Stack) On CentOS 7

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a CentOS 6.5 server with PHP support (through PHP-FPM) and MySQL (Mariadb) support.

A schema change inconsistency with Galera Cluster for MySQL
+0 Vote Up -0Vote Down

I recently worked on a case where one node of a Galera cluster had its schema desynchronized with the other nodes. And that was although Total Order Isolation method was in effect to perform the schema changes. Let’s see what happened.

Background

For those of you who are not familiar with how Galera can perform schema changes, here is a short recap:

  • Two methods are available depending on the value of the wsrep_OSU_method setting. Both have benefits and drawbacks, it is not the main topic of this post.
  • With TOI (Total Order Isolation), a DDL statement is performed at the same point in the replication flow on all nodes, giving strong guarantees that the schema is always identical on all nodes.
  • With RSU (Rolling Schema Upgrade), a DDL statement is not replicated to the other nodes.
  [Read more...]
Decoding (encrypted) MySQL traffic with Wireshark
+1 Vote Up -0Vote Down
In a comment on my post about Using SSL with MySQL xiaochong zhang asked if it is possible to decode SSL/TLS encrypted MySQL traffic. The short answer is: It depends.

To test this we need a MySQL server which is SSL enabled. I used MySQL Sandbox to create a sandboxed 5.6.19 server. Then I used mysslgen to create the config and the certificates.

$ make_sandbox 5.6.19
$ ./mysslgen.py --config=sandboxes/msb_5_6_19/my.sandbox.cnf --ssldir=sandboxes/msb_5_6_19/ssl

This assumes there already is a extracted tarball of MySQL 5.6.19 in ~/mysql/5.6.19

The mysslgen.py script will return a message with the changes you should make in your mysqld and client sections of the my.sandbox.cnf file. Then








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

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

https://downloads.mariadb.org/mariadb/10.1.0/

This is the first alpha release of MariaDB 10.1, so there are a lot of new changes and functionalities added, which cover a wide variety of areas such as: Performance, InnoDB/XtraDB, WebScaleSQL, Optimizer, Security, Storage Engine functionality, & Administration Improvements.

These are 9 of the most notable changes in MariaDB 10.1.0 (but do check out the release notes and changelogs below for the full list of changes):

  • InnoDB: Allow > 16K pages on InnoDB – InnoDB now allows page size to be configured as 16K, 32K and 64K. Note that single row size must be
  • InnoDB:
  •   [Read more...]
    Systemtap solves phantom MySQLd SIGTERM / SIGKILL issue
    +0 Vote Up -0Vote Down

    The Percona Managed Services team recently faced a somewhat peculiar client issue. We’d receive pages about their MySQL service being unreachable. However, studying the logs showed nothing out of the ordinary…. for the most part it appeared to be a normal shutdown and there was nothing in anyone’s command history nor a cron task to speak of that was suspicious.

    This is one of those obscure and peculiar (read: unique) issues that triggered an old memory; I’d seen this behavior before and I had just the tool to catch the culprit in the act.

    Systemtap made diagnostics of this issue possible and I can’t state enough how much of a powerful and often under-utilized tool set systemtap really is.

    cat >

      [Read more...]
    Hadoop BoF Session at OSCON
    +0 Vote Up -0Vote Down

    I have a BoF session next week at OSCON next week:

    Migrating Data from MySQL and Oracle into Hadoop

    The session is at 7pm Tuesday night – look for rooms D135 and/or D137/138.

    Correction: We are now in  E144 on Tuesday with the Hadoop get together first at 7pm, and the Data Migration to follow at 8pm.

    I’m actually going to be joined by Gwen Shapira from Cloudera, who has a BoF session on Hadoop next door at the same time, along with Eric Herman from Booking.com. We’ll use the opportunity to talk all things Hadoop, but particularly the ingestion of data from MySQL and other databases into the Hadoop datastore.

    As always, it’d be great to meet anybody interested in Hadoop at the BoF, please come along and

      [Read more...]
    Q&A: Even More Deadly Mistakes of MySQL Development
    +1 Vote Up -0Vote Down

    On Wednesday I gave a presentation on “How to Avoid Even More Common (but Deadly) MySQL Development Mistakes” for Percona MySQL Webinars.  If you missed it, you can still register to view the recording and my slides.

    Thanks to everyone who attended, and especially to folks who asked the great questions.  I answered as many as we had time for

      [Read more...]
    Update on MySQL on POWER8
    +2 Vote Up -0Vote Down

    About 1.5 months ago I blogged on MySQL 5.6 on POWER andtalked about what I had to poke at to make modern MySQL versions run and run well on shiny POWER8 systems.

    One of those bugs, MySQL bug 47213 (InnoDB mutex/rw_lock should be conscious of memory ordering other than Intel) was recently marked as CLOSED by the Oracle MySQL team and the upcoming 5.6.20 and 5.7.5 releases should have the fix!

    This is excellent news for those wanting to run MySQL on SMP systems that don’t have an Intel-like memory model (e.g. POWER and MIPS64).

    This was the most major and invasive patch in the patchset for MySQL on POWER. It’s

      [Read more...]
    Recover after DROP TABLE. Case 2
    +1 Vote Up -0Vote Down

    Introduction

    In the previous post we described the situation when TwinDB recovery toolkit can be used to recover accidentaly dropped table in the case innodb_file_per_table=OFF setting.
    In this post we will show how to recover MySQL table or database in case innodb_file_per_table is ON. So, let’s assume that mysql server has setting innodb_file_per_table=ON. This option tells InnoDB to store each table with user in a separate data  file.

    We will use for recovery test the same database sakila, that was used in the previous post.

    root@test:/var/lib/mysql/sakila# ll

      [Read more...]
    High Availability with mysqlnd_ms on Percona XtraDB Cluster
    +1 Vote Up -0Vote Down

    This is the second part of my series on High Availability with mysqlnd_ms. In my first post, “Simple MySQL Master HA with mysqlnd_ms,” I showed a simple HA solution using asynchronous MySQL replication. This time we will see how to leverage an all-primary cluster where you can write to all nodes. In this post I used Percona XtraDB Cluster, but you should also be able to do the same with MySQL NDB Cluster or Tungsten Replicator.

    To start with, here is the mysqlnd_ms configuration I used:

    mysqlnd_ms_mm.ini
    .  All of these files are available from my

      [Read more...]
    Oracle Critical Patch Update for MySQL
    +1 Vote Up -0Vote Down
    Oracle has released the Critical Patch Update (CPU) for July 2014. The Oracle MySQL Risk Matrix lists 10 security fixes.

    It took me some time to understand the subcomponent names. So here is the list with the full name of each subcomponent:

    SubcomponentFull nameSRFTSServer: Full Text SearchSRINFOSCServer: INFORMATION_SCHEMASRCHARServer: Character setsENARCEngine: ArchiveSROPTZRServer: OptimizerSRREPServer: ReplicationSRSPServer: Stored ProcecureENFEDEngine: Federated
    I don't think there is anything really important in the list, but it might be a good trigger to update to the latest release.

    Upgrading should be easy especially if you're using the APT or






      [Read more...]
    MySQL Slave Scaling and more
    +2 Vote Up -0Vote Down

    Jean-François talks about binlog servers. Take a look here: http://blog.booking.com/mysql_slave_scaling_and_more.html

    ClouSE 1.0 is generally available
    +1 Vote Up -0Vote Down


    OblakSoft is pleased to announce general availability of the Cloud Storage Engine for MySQL (ClouSE) version 1.0.  Whether you want to use ready-to-run WordPress for Amazon Cloud / Google Cloud, configure your own WordPress installation with WP2Cloud plugin, or use ClouSE to deploy your own applications, ClouSE lets you tap the power of cloud storage to store your data extremely durably and make serving the content highly scalable.

    We would like to thank more than 2,000 registered Beta


      [Read more...]
    Install Apache2, PHP5 And MySQL Support On CentOS 7 (LAMP)
    +1 Vote Up -0Vote Down

    Install Apache2, PHP5 And MySQL Support On CentOS 7 (LAMP)

    This tutorial shows how you can install an Apache2 webserver on a CentOS 7.0 server with PHP5 support (mod_php) and MySQL support. LAMP is short for Linux, Apache, MySQL, PHP.

    Making Real-Time Analytics a Reality — TDWI -The Data Warehousing Institute
    +0 Vote Up -0Vote Down

    My article on how to make the real-time processing of information from traditional transactional stores into Hadoop a reality has been published over at TDWI:

    Making Real-Time Analytics a Reality — TDWI -The Data Warehousing Institute.


    TokuDB tips: MySQL backups
    +0 Vote Up -0Vote Down

    In my recent post, “TokuDB gotchas: slow INFORMATION_SCHEMA TABLES,” I saw a couple questions and tweets asking if we use TokuDB in production. Actually I mentioned it in that post and we also blogged about it in a couple of other recent posts:

    So, yes, we are using Percona Server + TokuDB as a main storage engine in Percona Cloud Tools to store timeseries data.

    And, yes, Percona

      [Read more...]
    Priority queue optimization for filesort is now visible in MariaDB 10.0
    +1 Vote Up -0Vote Down

    TL;DR: Priority queue optimization for filesort with small LIMIT is now visible in MariaDB: there is a status variable and you can also see it in the slow query log (KB page link).

    A longer variant:
    One of the new optimizations in MySQL 5.6 is ability to use a priority queue instead of sorting for ORDER BY … LIMIT queries. The optimization was ported into MariaDB 10.0 long ago, but we still get questions if/when it will be ported. I guess, the reason for this is that, besides the query speed, you can’t see this optimization. Neither EXPLAIN, nor EXPLAIN FORMAT=JSON or PERFORMANCE_SCHEMA or status variables give any indication whether filesort used priority queue or the regular quicksort+merge algorithm.

    MySQL 5.6 has


      [Read more...]
    Simple MySQL Master HA with mysqlnd_ms
    +0 Vote Up -0Vote Down

    I had the pleasure of presenting to the PHP Users Group Philippines a few days ago about mysqlnd_ms. The mysqlnd plugin, MySQL Master Slave, is a transparent layer on top of mysqlnd extension. This allows you to do read-write splitting and slave reads load balancing without needing to change anything from your application. But do you know you can also achieve a form of high availability with this plugin? I shared 2 forms on my presentation, using async MySQL replication either in master-slave configuration or master-master configuration, while the second form is having an all primary cluster where you can write to all nodes.

    This first part is to demonstrate how you can achieve a simple HA solution using the first form. First, all the sample code here can be found on my

      [Read more...]
    Discover the latest MySQL Cluster Developments – Upcoming webinar
    Employee +2 Vote Up -0Vote Down

    On Thursday 17th July I’ll be hosting a webinar which explains what MySQL Clusrter is, what it can deliver and what the latest developments are. As always the webinar is free but please register here (http://www.mysql.com/news-and-events/web-seminars/discover-the-latest-mysql-cluster-developments/" target="_blank).

    Details:

    Join this technical webinar to learn how MySQL Cluster 7.3, the latest GA release, enables developer agility by making it far simpler and faster to build your products and web-based applications with MySQL Cluster. You’ll

      [Read more...]
    MySQL Cluster 7.3.6 Released
    Employee +2 Vote Up -0Vote Down


    The binary and source versions of MySQL Cluster 7.3.6 have now been made available at http://www.mysql.com/downloads/cluster/ (http://www.mysql.com/downloads/cluster/" target="_blank).

    Release notes

    MySQL Cluster NDB 7.3.6 is a new release of MySQL Cluster, based
    on MySQL Server 5.6 and including features from version 7.3 of the
    NDB storage engine, as well as fixing a number of recently
    discovered bugs in previous MySQL Cluster releases.

    Obtaining MySQL Cluster NDB 7.3. MySQL Cluster NDB 7.3 source
    code and binaries can be obtained from






      [Read more...]
    Save 20% With MySQL Training and Certification Packages
    Employee_Team +2 Vote Up -0Vote Down

    Get the best from both worlds with bundled packages: a training course and a certification exam voucher. You save 20% when you buy training and certification in discount packages.

    Training helps you acquire product expertise. Certification proves this expertise to your future employers.

    There are two MySQL Discount Packages: MySQL Database Administration and MySQL Developer.

    For more information about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

    Geographically distributed multi-master MySQL clusters
    +0 Vote Up -0Vote Down
    Global data access can greatly expand the reach of your business. Continuent Tungsten multi-site multi-master (MSMM) solutions enable applications to accept write traffic in multiple locations across on-premises and cloud providers. This includes the following important real-world use cases: Improve performance for globally distributed users registering hardware devices by permitting updates
    Managing shards of MySQL databases with MySQL Fabric
    +1 Vote Up -1Vote Down

    This is the fourth post in our MySQL Fabric series. In case you’re joining us now, we started with an introductory post, and then discussed High Availability (HA) using MySQL Fabric here (Part 1) and here (Part 2). Today we will talk about how MySQL Fabric can help you scale out MySQL databases with sharding.

    Introduction

    At the time of writing, MySQL Fabric includes support for range- and hash-based sharding. As with HA, the functionality is split between client, through a MySQL Fabric-aware connector; and server, through the

      [Read more...]
    Harnessing the power of master/slave clusters to operate data-driven businesses on MySQL
    +1 Vote Up -0Vote Down
    Users seeking high availability, DR and zero downtime maintenance operation for business-critical MySQL applications face confusing choices. Is multi-master or master/slave clustering better?  What about synchronous versus asynchronous replication? Using a plain vanilla, stock MySQL or a modified version of it? Which of these choices are right for data-driven businesses that depend on fast,
    Showing entries 1 to 30 of 16123 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.