Showing entries 1 to 10 of 23
10 Older Entries »
Displaying posts with tag: webscalesql (reset)
Apr
08
2016
(tweet) Summary of Percona Live 2015
Posted by Colin Charles on Fri 08 Apr 2016 09:44 UTC
Tags:

The problem with Twitter is that we talk about something and before you know it, people forget. (e.g. does WebScaleSQL have an async client library?) How many blog posts are there about Percona Live Santa Clara 2015? This time (2016), I’m going to endeavour to write more than to just tweet – I want to remember this stuff, and search archives (and also note the changes that happen in this ecosystem). And maybe you do too as well. So look forward to more blogs from Percona Live Data Performance Conference 2016. In the meantime, here’s tweets in chronological order from my Twitter search.

  • crowd filling up the keynote room for #perconalive
  • beginning shortly, we’ll see @peterzaitsev at #perconalive doing his keynote
  • #perconalive has over 1,200 attendees – oracle has 20 folk, with 22 folk from facebook
    • …
[Read more]
Sep
08
2015
super_read_only and GTID replication
Posted by MySQL Performance Blog on Tue 08 Sep 2015 07:00 UTC
Tags:

Percona Server 5.6.21+ and MySQL 5.7.8+ offer the super_read_only option that was first implemented in WebscaleSQL. Unlike read_only, this option prevents all users from running writes (even those with the SUPER privilege). Sure enough, this is a great feature, but what’s the relation with GTID? Read on!

TL;DR

Enabling super_read_only on all slaves when using GTID replication makes your topology far less sensitive to errant transactions. Failover is then easier and safer because creating errant transactions is much harder.

GTID replication is awesome…

For years, all MySQL DBAs in the world have been fighting with positioning when working with replication. Each time you move a slave from one master to another, you must be very careful to start …

[Read more]
Apr
27
2015
WebScaleSQL builds available for Debian 8 and Ubuntu 15.04
Posted by dba square on Mon 27 Apr 2015 12:53 UTC
Tags:

After many months of heavy development and testing, Debian 8 (Jesse) and Ubuntu 15.04 (Vivid Vervet) were released recently.

For those who already upgraded their systems and/or plan do do it in close future, we prepared builds of WebScaleSQL :-)

You can also install it using PSCE repository.

 

Apr
10
2015
WebScaleSQL 5.6.24 is built and ready to test
Posted by dba square on Fri 10 Apr 2015 12:15 UTC
Tags:

On Tuesday  Steaphan Greene  announced that all currently-pushed changes have now been rebased onto the newly-released upstream MySQL-5.6.24.


The new branch at this point is available on github.

Our .deb and .rpm builds are available in the PSCE repo as well as being browsable here http://repo.psce.com/download/webscalesql/

Instructions for using the repo are available for Debian …

[Read more]
Mar
06
2015
MariaDB 10.1.3 Overview and Highlights
Posted by Chris Calender on Fri 06 Mar 2015 02:14 UTC
Tags:
webscale, xtradb, mariadb, json, MySQL, mariadb changelogs, mariadb downloads, MariaDB 10.1, webscalesql, ANALYZE statement, atomic writes, download mariadb 10.1, Force PK option, FusionIO and MySQL MariaDB, mariadb 10.1 download, GET_LOCK(), compound statements, CLIENT_STATISTICS, default roles, defrag innodb, defrag innodb tablespace, defragment innodb, defragment innodb tablespace, FLUSH QUERY_RESPONSE_TIME, SHOW QUERY_RESPONSE_TIME, triggers can be run on slave, USER_STATISTICS, Boundary, ConvexHull, domain_id based replication filters, EXPLAIN FORMAT=JSON, innodb_log_compressed_pages, Scalability fixes, Webscale patches, WSREP_MEMBERSHIP, WSREP_STATUS, Consistent IF EXISTS, dirty galera reads, download MariaDB 10.1.3, Dump thread, Dump Thread Enhancements, Enhanced semisync replication, InnoDB Page compression, MariaDB 10.1 Beta, MariaDB 10.1.3, mariadb and json, mysql and json, range checked for each record, range+MRR, semisync replication, skip_parallel_replication, slave_parallel_mode, snappy compression method, Table and Tablespace Encryption, table definition cache lock, table definition cache now has lock-free implementation, wsrep_dirty_reads, XtraDB Page compression

MariaDB 10.1.3 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.1.3/

This is the 1st beta, and 4th overall, release of MariaDB 10.1, so there are a lot of new changes, functionalities added, defaults changed, and many bugs fixed (I counted 420 – 117 in 10.1.2 & 637 in 10.1.1, fwiw).

Since it’s beta, I’ll only cover the major changes and additions, and omit covering general bug fixes (feel free to browse them all here).

To me, these are the highlights of the new features:

[Read more]
Feb
04
2015
WebScaleSQL RPMs available at PSCE repository
Posted by dba square on Wed 04 Feb 2015 13:46 UTC
Tags:

Driven by popularity of previous post about Debian/Ubuntu builds of WebScaleSQL and long discussions during FOSDEM conference this weekend, PSCE engineering team decided to put even more effort into.

We would like to introduce:

  • RPM packages available for download
  • RedHat/CentOS repository

Architectures covered:

  • x86 (32-bit)
  • x86_64 (64-bit)

Please note that “WebScaleSQL does not currently maintain compatibility for anything except GNU/Linux x86_64.” (WebScaleSQL FAQ)”

RedHat/CentOS releases:

  • CentOS 6
  • CentOS 7

Packages can be downloaded from …

[Read more]
Jan
31
2015
WebScaleSQL builds for the MySQL Community
Posted by dba square on Sat 31 Jan 2015 11:48 UTC
Tags:

We have been looking at the WebScaleSQL project with great excitement. As with any new enhancements to the MySQL world, we need to test extensively to ensure we can give PSCE customers the best advice possible. Since this project is source only, we decided to add WebScaleSQL builds to our repo, so we could examine the changes being introduced by all the different collaborators.

So what is WebscaleSQL?

WebScaleSQL is a collaboration among engineers from several companies that face the same challenges in deploying MySQL at scale, and seek greater performance from a database technology tailored for their needs.

— WebScaleSQL, Frequently Asked Questions

What makes this project so special, is the level of collaboration between some of the most …

[Read more]
Jan
17
2015
MariaDB 10.1.2 Overview and Highlights
Posted by Chris Calender on Sat 17 Jan 2015 17:03 UTC
Tags:
webscale, xtradb, mariadb, union all, MySQL, mariadb changelogs, mariadb downloads, MariaDB 10.1, webscalesql, ANALYZE statement, atomic writes, download mariadb 10.1, download MariaDB 10.1.0, Force PK option, FusionIO and MySQL MariaDB, mariadb 10.1 alpha, mariadb 10.1 download, GET_LOCK(), compound statements, CLIENT_STATISTICS, default roles, defrag innodb, defrag innodb tablespace, defragment innodb, defragment innodb tablespace, engine_condition_pushdown optimizer_switch flag, FLUSH QUERY_RESPONSE_TIME, Kakao patch, out parameters, SHOW LOCALES, SHOW QUERY_RESPONSE_TIME, Statements that exceed a certain execution time, triggers can be run on slave, USER_STATISTICS, Boundary, ConvexHull, CrackLib, cracklib_password_check password, domain_id based replication filters, EXPLAIN FORMAT=JSON, innodb_log_compressed_pages, Innodb_secondary_index_triggered_cluster_reads, Innodb_secondary_index_triggered_cluster_reads_avoided, IsRing, MariaDB 10.1.2, number of rows affected by a slow UPDATE or DELETE is now recorded, Out parameters in PREPARE, Password validation plugin API, Per-query variables, PointOnSurface, query_alloc_block_size, query_prealloc_size, Scalability fixes, simple_password_check password, Spatial Reference systems for the GIS data, ST_Boundary, ST_ConvexHull, ST_IsRing, ST_PointOnSurface, ST_Relate, Webscale patches, WSREP_MEMBERSHIP, WSREP_STATUS

MariaDB 10.1.2 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.1.2/

This is the third alpha release of MariaDB 10.1, so there are still a lot of new changes, functionalities added, defaults changed, and many bugs fixed (I counted 117, which is *way* down from the 637 fixed in 10.1.1). Since it’s alpha, I’ll only cover the major changes and additions, and omit covering general bug fixes (feel free to browse them all here).

To me, these are the highlights of the new features:

[Read more]
Oct
25
2014
MariaDB 10.1.1 Overview and Highlights
Posted by Chris Calender on Sat 25 Oct 2014 13:15 UTC
Tags:

MariaDB 10.1.1 was recently released, and is available for download here:

https://downloads.mariadb.org/mariadb/10.1.1/

This is the second alpha release of MariaDB 10.1, so there are a lot of new changes and functionalities added, and many, many bugs fixed (I counted 637). Since it’s alpha, I’ll only cover the major changes and additions, as there are a lot of great new features, and omit covering any of the bug fixes (feel free to browse them all here).

To me, these are the highlights of the new features:

  • InnoDB: You can now use OPTIMIZE TABLE to defragment InnoDB tablespaces (merged the Facebook/Kakao defragmentation patch). (Good blog post …
[Read more]
Sep
19
2014
MySQL Thread Pool Improvements @ Twitter
Posted by Inaam Rana on Fri 19 Sep 2014 17:05 UTC
Tags:

At Twitter, MySQL is an important part of our storage story. We can have a typical database node with thousands of open connections. It works mostly fine because generally only a few of these connections actively working inside the server. Given the scale at which we have to operate spikes happen – mostly at unexpected times and with unexpected ferocity. The challenge is how to control concurrency within MySQL server during spikes.

Historically we have been using innodb_thread_concurrency to control number of active threads within the server. In Twitter MySQL-5.5 we introduced the idea of Query Throttling where incoming requests are throttled if the number of active threads goes beyond a configurable threshold. These solutions focus on maintaining the health of the system. However, they don’t help us to scale to the workload spikes. With …

[Read more]
Showing entries 1 to 10 of 23
10 Older Entries »