Showing entries 1 to 10 of 37278
10 Older Entries »
Comparing Query Cache in ProxySQL and MaxScale

Few days ago MariaDB announced MaxScale 2.1.0 Beta, and among the new Query Performance capabilities there is Query Cache Filter. Query Cache was among the very first features introduced in ProxySQL, and therefore I was extremely curious to compare them!
Reading the documentation on MaxScale Query Cache Filter I noticed few interesting things compares to ProxySQL Query Cache:

  • MaxScale supports in-memory and on disk storage, while ProxySQL supports only in-memory storage
  • MaxScale can have either shared or per-thread cache, while ProxySQL supports only shared cache: in 2014 ProxySQL had per-thread cache, but benchmark showed that a partitioned shared cache is way more efficient

To compare ProxySQL 1.3.4 Query Cache …

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

This Log Buffer Edition searches through various blogs of Oracle, SQL Server and MySQL and picks a few contemporary ones.

Oracle:

Comma separated search and search with check-boxes in Oracle APEX

Once you have defined your users for your Express Cloud Service, all users with the role of Database Developer or higher can access the database Service Console.

Big Data Lite 4.7.0 is now available on OTN!

Install and configure Oracle HTTP Server Standalone

Can I …

[Read more]
ProxySQL and MaxScale on point select workload

Few days ago MariaDB announced that MaxScale 2.1 is roughly 45% faster than MaxScale 2.0 .

I first want to congratulate MaxScale Team: MaxScale 2.1 seems to have better performance than MaxScale 2.0, great work!
Since MaxScale 2.0 was considerable slower than ProxySQL, I was curious to compare ProxySQL against new MaxScale 2.1.

Reading the article, the first thing that caught my attention was(quoting). "In version 2.1 a session and all its related connections are pinned to a particular worker thread." .
I didn't check how this is implemented, but I am sure this is the right way to have a high performance proxy. I think it is the right way because this is at the base of the ProxySQL network core: each worker thread has its own poll(), and this seems to be the best scalable solution (see …

[Read more]
Conociendo ProxySQL

Last month, January 2017, two DevOps meetups were organized in Spain with the same topic: "Conociendo ProxySQL", presented by txetxu Velayos , @txetxuvel

The two DevOps meetups were:

I had the opportunity and the pleasure to be present at the Murcia DevOps meetup during the the session "Conociendo ProxySQL" , were was described how to configure ProxySQL in various MySQL setups.

Slides and videos are available online.
For Murcia DevOps: …

[Read more]
Releasing ProxySQL 1.3.4

I am happy to announce the release of the latest stable release of ProxySQL 1.3.4 on 18 February 2017.

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license!
It can be downloaded here, and freely usable and accessible according to GPL license.

ProxySQL 1.3.4 is bug fixes release based on ProxySQL 1.3.3: no new features were introduced.

Release notes for ProxySQL 1.3.4 are available online

A special thanks to all the people that reports bugs: this makes each version of ProxySQL better than the previous one.
Please report any bugs or feature requests on github issue tracker

MySQL Group Replication… synchronous or asynchronous replication ?

After some feedback we received from early adopters or discussions during events like FOSDEM, I realized that there is some misconception about the type of replication that MySQL Group Replication is using. And even experts can be confused as Vadim’s blog post illustrated it.

So, is MySQL Group Replication asynchronous or synchronous ?? … in fact it depends !

The short answer is that GR is asynchronous. The confusion here can be explained by the comparison with Galera that claims to be synchronous or virtually synchronous depending where and who claims it (Synchronous multi-master replication library, synchronous replication,  …

[Read more]
Donkey – system for MySQL automatic maintenance

We build this system based on Inception (Qunar)。

All of MySQL DDL/DML operations are based on Donkey system, with strict approval process to keep online system strong and available.

Open this file by Mockplus Donkey-system

MySQL Bug 72804 Workaround: “BINLOG statement can no longer be used to apply query events”

In this blog post, we’ll look at a workaround for MySQL bug 72804.

Recently I worked on a ticket where a customer performed a point-in-time recovery PITR using a large set of binary logs. Normally we handle this by applying the last backup, then re-applying all binary logs created since the last backup. In the middle of the procedure, their new server crashed. We identified the binary log position and tried to restart the PITR from there. However, using the option

--start-position

, the restore failed with the error “The BINLOG statement of type Table_map was not preceded by a format description BINLOG statement.” This is a known bug and is reported as MySQL …

[Read more]
Sysadmin 101: Troubleshooting

I typically keep this blog strictly technical, keeping observations, opinions and the like to a minimum. But this, and the next few posts will be about basics and fundamentals for starting out in system administration/SRE/system engineer/sysops/devops-ops (whatever you want to call yourself) roles more generally.
Bear with me!

“My web site is slow”

I just picked the type of issue for this article at random, this can be applied to pretty much any sysadmin related troubleshooting. It’s not about showing off the cleverest oneliners to find the most information. It’s also not an exhaustive, step-by-step “flowchart” with the word “profit” in the last box. It’s about general approach, by means of a few examples.
The example scenarios are solely for illustrative purposes. They sometimes have a basis in assumptions that doesn’t apply to all cases all of the time, and I’m positive many readers …

[Read more]
Percona Blog Poll Results: What Programming Languages Are You Using for Backend Development?

In this blog we’ll look at the results from Percona’s blog poll on what programming languages you’re using for backend development.

Late last year we started a poll on what backend programming languages are being used by the open source community. The three components of the backend – server, application, and database – are what makes a website or application work. Below are the results of Percona’s poll on backend programming languages in use by the community:

Note: There is a poll embedded within this post, please visit the site to participate in this post's poll.

One of the best-known and earliest web service stacks is the LAMP stack, which spelled out refers to Linux, Apache, MySQL and PHP/Perl/Python. We can see that this early model is still popular when it comes to the backend.

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