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 32823 Next 30 Older Entries
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.
FUD FUD FUD
+1 Vote Up -1Vote Down

From another web page:

"I'm not sure that loading a 1GB dump file into MySQL is a particularly good idea - it's not the most stable piece of software and I've had issues with smaller dumps than that before." March 29, 2013

 

It really irritates me when people says stupid things when the problem is their own incompetence or inexperience. Now let's think about this for just a second. MySQL is certainly one of the most popular databases powering the Internet. It is used extensively in tiny little sites like Google and Facebook. It is far from unstable. I routinely work on systems that have uptimes of many months if not years. Normal behavior is that the server is up until it needs be upgraded. I have worked on systems that executes tens of thousands of queries a second as a typical part of their usage patterns. And I have loaded SQL dump files that where well over 100

  [Read more...]
InfiniDB Expands Global Partner Program
+0 Vote Up -0Vote Down

InfiniDB Adds New Resources and Incentives for Channel Partners, Value Added Resellers and System Integrators to Sell and Build Applications with the InfiniDB High Performance Analytic Database

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.

Introduction to four key MariaDB client commands
+0 Vote Up -0Vote Down
Mon, 2014-07-21 09:00carlaschroder

It's time to get to know four of the most commonly used administration commands for your MariaDB server: mysql, mysqladmin, mysqldump, and mysqlimport.

The examples run these commands on the server rather than over the network. You'll be prompted for your password; if you want to save a few keystrokes you can record your password in a configuration file, which also solves the problem of how to pass a password if you want to use any of these commands in an unattended script. Doubtless you're aware of how to pass in your password directly in your commands, but doing this creates a security hole

  [Read more...]
Setting up and Using MySQL Replication
Employee_Team +1 Vote Up -0Vote Down

MySQL Replication allows servers to copy changes from one instance to another. Take the MySQL for Database Administrators course to learn about replication, including:

  • How to set up a replication environment
  • Complex topologies
  • Replication types
  • Global transaction IDs (GTIDs)
  • MySQL Utilities
  • Logs and threads

Replication is one of the many topics covered in the MySQL for Database Administrators course. You can take this 5-day instructor-led course as  

  [Read more...]
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...]
MySQL Type Conversion Rules
+1 Vote Up -0Vote Down

When you send a query to MySQL, you usually don’t need to think explicitly about the types of the expressions in your query. If you compare this to a lot of programming languages, you’ll find that it’s not always the way things work. In strongly typed languages like Java, for example, typing is very strict.

In this respect, MySQL is much more like a dynamically typed language such as PHP or Perl — a DWIM (do what I mean) typing system. Yet, internally, every expression in MySQL has a type, and it does conversions amongst them as needed.

Sometimes, you might wonder how does this query work and exactly what’s happening to the variables in these expressions? Importantly, does it always work right?

Examples of MySQL Type Conversion

Let’s look at

  [Read more...]
The Battle Begins…. Which Cloud Provider will Reign Supreme?
+0 Vote Up -0Vote Down

Place your bets now – it’s gonna be a good fight. The cloud is the arena where the next big tech giant battles will be taking place.. We’ll have to sit down as watch as the go head-to-head to win the customers who have started the mass migration to the cloud.

If you are thinking of migrating your databases to cloud, your vote will count towards determining the winner. As you evaluate your options, we suggest you consider these guys first and foremost.

 

Amazon Web Services
  • Amazon DynamoDB provides a scalable, low-latency NoSQL online Database Service backed by SSDs.
  • Amazon ElastiCache provides in-memory caching for web applications. This is Amazon’s
  [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...]
    MySQL Enterprise Monitor 3.0.13 has been released
    Employee_Team +0 Vote Up -0Vote Down

    We are pleased to announce that MySQL Enterprise Monitor 3.0.13 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud in a few weeks. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.

    You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.

    You will also find the binaries on the

      [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...]
    OurSQL Episode 194: Common Schema, part 4
    +0 Vote Up -0Vote Down
    PodcastsPerformanceQuery OptimizationServer Tuning

    This week we continue our series on Common Schema and talk about different ways to look at the processlist, help with the query profiler, and some internal Common Schema tables. Ear Candy is about RHEL 7.0 using MariaDB, and At the Movies is The Human Postmortem.

    OurSQL Episode 193: Common Schema, part 3
    +0 Vote Up -0Vote Down
    PodcastsServer Tuning

    This week we continue our discussion about Common Schema by talking about security views and schema analysis views. Ear Candy is that apt repositories for MySQL are available, and At the Movies is about copyright vs. civil liberties.

    MySQL Webinar: MySQL EXPLAIN, explained
    Employee +0 Vote Up -0Vote Down
    Some time ago, Matt Lord and I delivered a webinar on the MySQL EXPLAIN feature.  This webinar is available for on-demand access here (http://www.mysql.com/news-and-events/web-seminars/mysql-explain-explained/).  Based on the questions we got during the webinar, I want to emphasize that EXPLAIN does not execute the query, it only determines the query plan for the query.  Hence, EXPLAIN will not be able to evaluate how good the chosen query plan actually is.

    If you have questions on this topic after listening to this webinar, feel free to ask questions; either as comments on this blog or at the MySQL Optimizer Forum.

    You can also access other webinars on MySQL (http://www.mysql.com/news-and-events/on-demand-webinars/). New webinars will be announced here (http://www.mysql.com/news-and-events/web-seminars).
    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...]
    Connector/ODBC 5.3
    +0 Vote Up -0Vote Down
    Connector/ODBC 5.3 (5.3.4 GA, published on Friday, 18 Jul 2014)
    Connector/Net 6.9
    +0 Vote Up -0Vote Down
    Connector/Net 6.9 (6.9.2 rc, published on Friday, 18 Jul 2014)
    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...]
    MaxScale - from proxy to MySQL replication relay
    +0 Vote Up -0Vote Down
    Thu, 2014-07-17 10:57mriddoch

    Mark Riddoch, one of the MaxScale team, describes how a MaxScale plugin was developed for booking.com that allowed the proxy to be used to reduce the load placed on the master in large MySQL replication environments.

    During the first part of the year I spent a lot of time working on a proof of concept to use MaxScale as a way to distribute MySQL binlogs for large replications installations. I have to admit when I first heard the idea from Booking.com my reaction was - "MaxScale is a proxy for client applications, it can't do this". However I was wrong, proving that making versatile, configurable software can throw up surprises even for the people that design it.

    The Problem

    There have been posts elsewhere about the

      [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...]
    Brainiac Corner with Jeremy Tinley
    +0 Vote Up -0Vote Down

    The Brainiac Corner is a format where we talk with some of the smartest minds in the system, database, devops, and IT world. If you have opinions on pirates, or anything else related, please don’t hesitate to contact us

    Today, we interview Jeremy Tinley, the current Database Administrator at Etsy. He is a huge fan of puns and jokes. His favorite today is “A DBA walks into a bar and sees two tables. He says ‘Can I join you?’” He gets randomly preselected for TSA precheck lines more than anyone else he knows. If you are interested in his thoughts, connect through Twitter.

    How did you get from stork to

      [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...]
    MySQL Slave Scaling (and more)
    +0 Vote Up -0Vote Down
    Wed, 2014-07-16 11:51jean-françoisgagné

    At Booking.com, we have very wide replication topologies. It is not uncommon to have more than fifty (and sometimes more than a hundred) slaves replicating from the same master. When reaching this number of slaves, one must be careful not to saturate the network interface of the master. A solution exists but it has its weaknesses. We came up with an alternative approach that better fits our needs: the Binlog Server. We think that the Binlog Server can also be used to simplify disaster recovery and to ease promoting a slave as a new master after failure. Read on for more details.

    When having many slaves replicating from the same master, serving binary logs can saturate the network interface of the master as every change is requested by every slave. It is not unusual to have changes that generate lots of

      [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...]
    How to search for and replace a text string in MariaDB on Linux
    +0 Vote Up -0Vote Down
    Wed, 2014-07-16 08:02carlaschroder

    There will come a time when you must search for a particular text string in a field in MariaDB, and you may not know what database or table it might be in. It is somewhat like searching for a needle in a haystack, but fortunately we have good tools for finding our needle. I like to dump the database I'm searching into a text file and do my searches on the file, because it's a fast way to search, and you can mangle the dump file all you want without damaging anything important. When you have the results, you can run SQL queries on the appropriate tables to make the replacements.

    As always, be sure you have good backups before you muck around with your MariaDB server. Even better, have a copy of your production server in a sandbox for doing test runs.

    First, export your database into a text file, then search the file with your

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