Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 34566 10 Older Entries
MySQL Enterprise Audit – parsing audit information from log files, inserting into MySQL table
+0 Vote Up -0Vote Down

The MySQL Enterprise Audit plug-in is part of the MySQL Enterprise Edition (available through a paid license). Basically, Enterprise Audit tracks everything that is happening on your MySQL server, and can be used to protect/detect the misuse of information, and to meet popular compliance regulations including HIPAA, …

  [Read more...]
Proposal to deprecate MySQL INTEGER display width and ZEROFILL
Employee +1 Vote Up -0Vote Down

In the MySQL team we are currently discussing if we should deprecate the integer display width in numeric types. For example:

CREATE TABLE my_table (
 id INT(11) NOT NULL PRIMARY KEY auto_increment

The (11) does not affect the storage size of the data type, which for an INT will always be 4 bytes. It affects the display width.
Our rationale for proposing this should be deprecated is that it is a common

  [Read more...]
Connector/J 5.1
+7 Vote Up -2Vote Down

Connector/J 5.1 (5.1.36 GA, published on Thursday, 02 Jul 2015)

Percona Server 5.5.44-37.3 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona Server 5.5.44-37.3 on July 1, 2015. Based on MySQL 5.5.44, including all the bug fixes in it, Percona Server 5.5.44-37.3 is now the current stable release in the 5.5 series.

  [Read more...]
Percona Server 5.6.25-73.0 is now available
+0 Vote Up -0Vote Down

Percona is glad to announce the release of Percona Server 5.6.25-73.0 on July 1, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories.

Based on …

  [Read more...]
MariaDB with Galera available on the IBM Power8 platform
+0 Vote Up -0Vote Down

Wed, 2015-07-01 12:54anderskarlsson

It was a very long time since I wrote something in this blob, but I have been very busy this spring with MariaDB on Power. This has been a lot of work, but also a lot of fun. So, what is this MariaDB on Power thing all about, well I wrote an introduction to the Power platform late last year. Since then a lot of things has happened.

One thing is that several service providers out there have adopted Power8 as a platform. To be honest, this really isn't sexy, but it is useful and as a user of …

  [Read more...]
Using Cgroups to Limit MySQL and MongoDB memory usage
+0 Vote Up -0Vote Down

Quite often, especially for benchmarks, I am trying to limit available memory for a database server (usually for MySQL, but recently for MongoDB also). This is usually needed to test database performance in scenarios with different memory limits. I have physical servers with the usually high amount of memory (128GB or more), but I am interested to see how a database server will perform, say if only 16GB of memory is available.

And while InnoDB usually respects the setting of innodb_buffer_pool_size in O_DIRECT mode (OS cache is not being used in this case), more engines (TokuDB for MySQL, MMAP, WiredTiger, RocksDB for MongoDB) …

  [Read more...]
Monitoring MySQL Database Backups
+0 Vote Up -0Vote Down

It’s important to monitor the (database) backups after you set-it-up. In this post we will answer a few how to monitor MySQL Database backups solutions – monitoring methods. We should see suggestions for: Monitoring Holland MySQL Backup Monitoring mysqldump backups Monitoring Xtrabackup using log Monitoring Backups using Nagios Usually we can have our backup script […]

How We Designed VividCortex For Agencies and Consultants
+0 Vote Up -0Vote Down

One of the decisions I notice acutely about other companies’ products is their user model. I always notice it, and it makes me either smile or grit my teeth. Companies get this wrong all the time.

  • Right: a user account owns itself and is affiliated to a company/organization/etc. It may belong to teams and have various levels of permissions. But the person who created the account owns the account.
  • Wrong: a user account is created and owned by, and depends on, an organization or company.

The difference may seem silly. Why would anyone care?

…  [Read more...]
Authentication with Middleware using Siesta
+0 Vote Up -0Vote Down

We recently added a token-based authentication example to the Siesta repository that provides an excellent starting point for building authenticated APIs using our lightweight HTTP handler library for Go. This example, modeled after our own internal API services, demonstrates features and practices that we’ve developed and found useful after using Siesta in production for many months.

Here’s what you’ll see in this “meaty” example:

  • Request …
  [Read more...]
Showing entries 1 to 10 of 34566 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.