Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 36179 10 Older Entries
How fall in love with Failing assertion: !m_fatal?
+0 Vote Up -0Vote Down

The story about real love.
Once upon a time there was a bug about resizing innodb buffer pool size online ->
#77564 which was fixed on version MySQL 5.7.9.
But you can not stop the real love. Suddenly she came up and truely surprised me,because I was recently freed from depression. And now the same thing is happening again. With MySQL 5.7.12 if you try to resize:

mysql> set global innodb_buffer_pool_size = 107374182400;
Query OK, 0 rows affected (0.01 sec)

2016-05-31 11:50:18 0x7f7926ba1740 InnoDB: …





  [Read more...]
Speaking in June 2016
+0 Vote Up -0Vote Down

I have a few upcoming speaking engagements in June 2016:

  • Nerdear.la – June 9-10 2016 – Buenos Aires, Argentina – never been to this event but MariaDB Corporation are sponsors and I’m quite excited to be back in Buenos Aires. I’m going to talk about the MySQL ecosystem in 2016.
  • SouthEast LinuxFest – June 10-12 2016 – Charlotte, NC, USA – I have a few talks here, a bit bummed that I’m going to be missing the speaker dinner, but I expect this to be another great year. Learn about …
  [Read more...]
Codership Galera Cluster Webinar – Using Galera Replication to Create Geo-distributed Clusters on the WAN-June 9th
+0 Vote Up -0Vote Down

Description

In this webinar, we will show the advantages of having a geo-distributed database cluster and how to create one using Galera Cluster for MySQL. We will also discuss the configuration and status variables that are involved and how to deal with typical situations on the WAN such as slow, untrusted or unreliable links, latency and packet loss. We will demonstrate a multi-region cluster on Amazon EC2 and perform some throughput and latency measurements in real-time.

USA Time:  10-11 AM PDT (Pacific Standard Time), 9th of June

  [Read more...]
Become a ClusterControl DBA - SSL Key Management and Encryption of MySQL Data in Transit
+0 Vote Up -0Vote Down

Databases usually work in a secure environment. It may be a datacenter with a dedicated VLAN for database traffic. It may be a VPC in EC2. If your network spreads across multiple datacenters in different regions, you’d usually use some kind of Virtual Private Network or SSH tunneling to connect these locations in a secure manner. With data privacy and security being hot topics these days, you might feel better with an additional layer of security.

MySQL supports SSL as a means to encrypt traffic both between MySQL servers (replication) and between MySQL servers and clients. If you use Galera cluster, similar …

  [Read more...]
Codership Galera Cluster Webinar USA – Using Galera Replication to Create Geo-distributed Clusters on the WAN-June 9th
+0 Vote Up -0Vote Down

Description

In this webinar, we will show the advantages of having a geo-distributed database cluster and how to create one using Galera Cluster for MySQL. We will also discuss the configuration and status variables that are involved and how to deal with typical situations on the WAN such as slow, untrusted or unreliable links, latency and packet loss. We will demonstrate a multi-region cluster on Amazon EC2 and perform some throughput and latency measurements in real-time.

Time:  10-11 AM PDT (Pacific Standard Time), 9th of June

  [Read more...]
Codership Galera Cluster Webinar EMEA – Using Galera Replication to Create Geo-distributed Clusters on the WAN-June 9th
+0 Vote Up -0Vote Down

Description

In this webinar, we will show the advantages of having a geo-distributed database cluster and how to create one using Galera Cluster for MySQL. We will also discuss the configuration and status variables that are involved and how to deal with typical situations on the WAN such as slow, untrusted or unreliable links, latency and packet loss. We will demonstrate a multi-region cluster on Amazon EC2 and perform some throughput and latency measurements in real-time.

Time:  11-12 AM EEST (Eastern European Standard Time), 9th of June

  [Read more...]
systemd: a revolution gets used to itself
+0 Vote Up -0Vote Down

New versions of systemd (like in Ubuntu 16.04) are able to configure pid Cgroups (ulimit -u via Cgroups) using TasksMax.

Check the commit implementing TaksMax.

Author: Lennart Poettering <lennart@poettering.net>
Date:   Fri Nov 13 19:28:32 2015 +0100

    core: enable TasksMax= for all services by default, and set it to 512

    Also, enable TasksAccounting= for all services by default, too.

    See:

    http://lists.freedesktop.org/archives/systemd-devel/2015-November/035006.html

But not we’ve got silly defaults:

$ systemctl show -p TasksMax docker
TasksMax=512

$ …
  [Read more...]
Linux User-Group Console
+0 Vote Up -0Vote Down

This post shows you how to add the menu option and GUI to set users and groups. It’s quite a bit easier than mastering all the command-line syntax. It makes setting up the required user and group accounts for an Oracle Enterprise or MySQL database solution much easier.

You add the utility by calling the yum (Yellowdog Updater, Modified) utility like this:

yum installed -y system-config_users

You should see the following:

Loaded plugins: langpacks
adobe-linux-x86_64                                       |  951 B     00:00     
ol7_UEKR3 …
  [Read more...]
Infiniflash Benchmark
+0 Vote Up -0Vote Down

Sandisk (FusionIO) and Nexenta are working together to build this SDS solution.

Infiniflash is a very large SDS production, which manages for very large DW system who requires large storage space and also high IOPS.

We test infiniflash system ,read this Infiniflash_benchmark

Releasing ocelotgui 1.0.0
+0 Vote Up -0Vote Down

Today ocelotgui, the Ocelot Graphical User Interface for MySQL and MariaDB, version 1.0.0, is generally available for Linux. Read the manual, see the screenshots, and download binary (.deb or .rpm) packages and GPL-licensed C++ source here.

Showing entries 1 to 10 of 36179 10 Older Entries

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