Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 151 to 160 of 34997 10 Older Entries
On SHOW BINLOG/RELAYLOG EVENTS
+1 Vote Up -0Vote Down

Some notes after working with SHOW BINLOG EVENTS and SHOW RELAYLOG EVENTS statements; there are a few gotchas and some interesting facts. My reflections also follow.

I'm calling these commands from orchestrator when working with Pseudo-GTID (which I do alot). I …

  [Read more...]
Yet another MySQL 5.7 silent change
+0 Vote Up -0Vote Down

When a new version of MySQL appears, the first source of information for the brave experimenter is a page in the manual named What is new in MySQL X.X, also known as MySQL in a nutshell. For MySQL 5.7, the in-a-nutshell page lists quite a lot of changes. In that page, the list of removed features is enough to send a chill down the spine of most any DBA. Some of the items in the …

  [Read more...]
ScaleDB is Hiring a Senior Software Engineer for DBMS Kernel
+0 Vote Up -0Vote Down

ScaleDB extends MySQL for high-velocity high-volume data, enabling near real-time analytics across massive streams of data. Like Hadoop, ScaleDB leverages a cluster of commodity machines with low-cost spinning disks for storage, mitigating the typical trade-offs between data fidelity and the volume of data and time analyzed. NoSQL and Hadoop are excellent choices for unstructured data, or data variety challenges. However, if your data is structured time-series data, and generated at high-velocity and high-volume, ScaleDB is the tool for you. On a nine-node cluster, ScaleDB inserts millions of rows per second and queries up to 1000 times faster, more than …

  [Read more...]
Baron Schwartz speaking at OSCON EU
+0 Vote Up -0Vote Down

Baron Schwartz will be speaking on Building Microservices with Go at OSCON EU on October 26th.

Below is an overview;

Go is great for building HTTP and RPC services. VividCortex’s infrastructure is Go-based, and there are a lot of lessons to learn from the experience building it. Here are some of the things we needed to do above and beyond what the standard libraries provide:

  • Using net/http effectively
  • Building an actually sane REST framework in Go
  • Dealing with garbage collection
  • Building a build system …
  [Read more...]
Baron Schwartz speaking at OSCON EU
+0 Vote Up -0Vote Down

Baron Schwartz will be speaking on Building Microservices with Go at OSCON EU on October 26th.

Below is an overview;

Go is great for building HTTP and RPC services. VividCortex’s infrastructure is Go-based, and there are a lot of lessons to learn from the experience building it. Here are some of the things we needed to do above and beyond what the standard libraries provide:

  • Using net/http effectively
  • Building an actually sane REST framework in Go
  • Dealing with garbage collection
  • Building a build system …
  [Read more...]
#DBHangOps 08/06/15 -- Orchestrator and Binlog Servers and more!
+0 Vote Up -0Vote Down

#DBHangOps 08/06/15 -- Orchestrator and Binlog Servers and more!

Hello everybody!

Join in #DBHangOps this Thursday, August, 06, 2015 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

  • Orchestrator and Binlog Servers from Shlomi Noach
  • Configuration vs. Orchestration

You can check out the event page at https://plus.google.com/events/ci32euumljnmivfo8kkh9j8kum8 on Thursday to participate.

As always, you can still watch the …

  [Read more...]
LDAP Authentication with MariaDB PAM Plugin
+1 Vote Up -0Vote Down

This is getting more and more common, so I wanted to provide the steps required to get LDAP authentication working with MariaDB PAM plugin.

Unless you’re already familiar with setting up the MariaDB PAM plugin, I’d first recommend getting this to work with a standard Linux user (steps 1-4), then once all is working fine, progress to the LDAP users (steps 5-10). (And if you do not want to test this for the Linux user account, then you may skip steps #2 and #3.)

  1. Enable plugin by running the following from the command line client:
    INSTALL SONAME 'auth_pam';
    

    You should see an entry like this afterward in …

  [Read more...]
Write-heavy workload vs the MongoDB optimizer
+0 Vote Up -0Vote Down

We experienced wasted disk IO from the MySQL query optimizer a few years back and fixed it via FORCE INDEX hints. I think I am experiencing wasted disk IO from the MongoDB optimizer during recent tests with the insert benchmark.

The problem with MySQL requires a query for which more than one index can be used. The problem query was a single table SELECT statement. The optimizer must figure out the best index and calls the …

  [Read more...]
MySQL 5.7.8 - mysqlpump caveat
Employee +2 Vote Up -0Vote Down

MySQL 5.7.8-rc2 was released today, and features a new server utility called mysqlpump. This utility contains a number of major improvements over mysqldump including:

  • Parallel processing of databases, and of objects within databases, to speed up the dump process
  • For dump file reloading, faster secondary index creation for InnoDB tables by adding indexes after rows are inserted
  • Better control over which databases and database objects (tables, views, stored programs, user accounts) to dump
  • Dumping of user accounts as …
  [Read more...]
MySQL 5.7.8 : features, bugs and rumors
+0 Vote Up -0Vote Down

I’ve had a look at a preview release of MySQL 5.7.8, some time before it became available to the general public (perks and duties of an Oracle ACE) and I found a few interesting things among the release notes and the tarball itself:


  • There is a new tool named mysqlpump, which is intended as a replacement for mysqldump, with parallel processing, …

  [Read more...]
10 Newer Entries Showing entries 151 to 160 of 34997 10 Older Entries

Planet MySQL © 1995, 2015, 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.