Showing entries 41 to 50 of 37949
« 10 Newer Entries | 10 Older Entries »
BuzzConf is looking for technologists, innovators and entertainers!

MySQL is proud to announce that we are going to support and actively attend a very unique event BuzzConf in Australia. It’s hold on December 1-3, 2017 in Phoenix Park, AU.
BuzzConf is a family-friendly technology festival with a really unique atmosphere – all participants and presenters spend the weekend together in country Victoria, learning and playing with tech during the day and being entertained by live music all night!
Whether you want to give a talk, run a workshop, lead a kids track session, or entertain the masses during the festival, BuzzConf wants to hear from you!

The Call for Presenters runs until August 4, so there’s not long to get an idea in – but plenty of time to nut out all the final details should an idea from your community be selected for the program.
Find out what makes BuzzConf different at  …

[Read more]
Upcoming Webinar, 19th July, What is New in Tungsten Replicator 5.2 and Tungsten Clustering 5.2?

Continuent Tungsten 5.2 is just around the corner. This is one of our most exciting Tungsten product releases for some time!

In this webinar we’re going to have a look at a host of new features in the new release, including
Three new Replication Applier Targets (Kafka, Cassandra and Elasticsearch)
New improvements to our core command-line tools trepctl and thl
New foundations for our filtering services, and
Improvements to the compatibility between replication and clustering

This webinar is going be a packed session and we’ll show all the exciting stuff with more in-depth follow-up sessions in the coming weeks.

 

You’ll also learn about some more exciting changes coming in the upcoming Tungsten releases (5.2.1 and 5.3), and our major Tungsten 6.0 release due out by the end of the year.

So come and join us to get the low down on everything related to …

[Read more]
Setting Up Percona PAM with Active Directory for External Authentication

In this blog post, we’ll look at how to set up Percona PAM with Active Directory for external authentication.

In my previous article on Percona PAM, I demonstrated how to use Samba as a domain, and how easy it is to create domain users and groups via the samba-tool. Then we configured nss-pam-ldapd and nscd to enumerate user and group information via LDAP calls, and authenticate users from this source.

This time around, I will demonstrate two other ways of using Active Directory for external authentication by joining the domain via SSSD or Winbind. System Security Services Daemon (SSSD) allows you to configure …

[Read more]
Analysis of Financial Time Series Data Using MariaDB ColumnStore

Analysis of Financial Time Series Data Using MariaDB ColumnStore Satoru Goto Thu, 07/13/2017 - 11:31

MariaDB ColumnStore is a GPLv2 open source columnar database built on MariaDB Server. It is a fork and evolution of the former InfiniDB. It can be deployed in the cloud (optimized for Amazon Web Services) or on a local cluster of Linux servers using either local or networked storage. In this blog post, I will show some examples of analysis of financial time series data using MariaDB ColumnStore.

Free Forex Historical Data at HistData.com

First of all, we will download forex historical data ( …

[Read more]
MariaDB 10.2.7 now available

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.7. This is a stable (GA) release. See the release notes and changelog for details. Download MariaDB 10.2.7 Release Notes Changelog What is MariaDB 10.2? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

The post MariaDB 10.2.7 now available appeared first on MariaDB.org.

Gh-ost benchmark against pt-online-schema-change performance

In this blog post, I will run a gh-ost benchmark against the performance of pt-online-schema-change.

When gh-ost came out, I was very excited. As MySQL ROW replication became commonplace, you could use it to track changes instead of triggers. This practice is cleaner and safer compared to Percona Toolkit’s pt-online-schema-change. Since gh-ost doesn’t need triggers, I assumed it would generate lower overhead and work faster. I frequently called it “pt-online-schema-change on steroids” in my talks. …

[Read more]
Log Buffer #516: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Oracle:

12.2 New Feature: the FLEX ASM disk group part 2

Oracle ASM in Azure corruption – follow up

Set-based processing

ADF 12c BC Proxy User DB Connection and Save Point Error

Enabling A Modern Analytics Platform

SQL Server:

[Read more]
MariaDB 10.2.7 now available

MariaDB 10.2.7 now available dbart Wed, 07/12/2017 - 11:21

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.7. See the release notes and changelog for details.

Download MariaDB 10.2.7

Release Notes Changelog What is MariaDB 10.2?

[Read more]
Thread_Statistics and High Memory Usage

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.

I was recently working on a high memory usage issue for one of our clients, and made some interesting discoveries: high memory usage with no bounds. It was really tricky to diagnose.

Below, I am going to show you how to identify that having thread_statistics enabled causes high memory usage on busy systems with many threads.

Part 1: Issue Background

I had a server with 55.0G of available memory. Percona Server for MySQL version:

Version | 5.6.35-80.0-log Percona Server (GPL), Release 80.0, Revision f113994f31
                 Built On | debian-linux-gnu x86_64

We have …

[Read more]
On slave_parallel_workers and the logical clock

How can you tell if a given workload on the master could be replicated with many parallel workers on the slave?

The slave_parallel_type=LOGICAL_CLOCK is an implementation of a Lamport clock. The implementation is described in WL #7165 - including a neat little ASCII-art graphic.

Each event in the binary log is stamped with two values:
- The sequence_number increments for each commit
- The last_committed is the sequence_number which was in effect when this transaction entered the prepare phase.

A slave worker cannot begin doing a transaction until the last_committed value is smaller than the sequence_number of all other running threads.

mysqlbinlog mysql-bin.0000x | grep last_committed

#160118 15:31:34 server id 3  end_log_pos …
[Read more]
Showing entries 41 to 50 of 37949
« 10 Newer Entries | 10 Older Entries »