In this post i want to share about how to update node version in ubuntu OS I would like to share this post because i try lot to update my node js package When i install 01025 nodejs but i want to update nodejs current latest version At that time i did try lot to upgrade but i cant update my no

In this blog, we’ll discuss how the Percona XtraDB Cluster threading model works.

Percona XtraDB Cluster (PXC) creates a different set of threads to service its operations. These threads are in addition to existing MySQL threads. Let’s understand what these threads are and how they’re used. There are three main groups of threads:

1. Applier thread(s)
   1. Applier threads are meant to apply write-sets that the node receives from other nodes (through cluster). (write-message is directed through

      gcv_recv_thread

      .)
   2. The number of applier threads is controlled using the

      wsrep_slave_thread

       configuration. (The default value is 1, so at least one wsrep applier thread …

A few days ago, I was struggling to install python on a Linux machine, in which I had no root permission. That machine was shared with many other users and there was only an old python version already installed on the machine. After a bit of search and trial, I was able to install a newer version of python on this machine to my local directory.

My goal was to run a program developed under python 2.7 on the Linux server which already had python 2.6 installed. As you can see, it was impossible for me to upgrade python on the system because I had no root permission. The only solution was to install the python 2.7 into my local directory and override the necessary environment variables. Even though this blog aims for python 2.7, I believe it should also be the same for python 3.0. The detailed steps are as follows:

1. Install python to local directory

Firstly, I create a folder in my home directory, download the …

Just a quick post to help others who get stuck on the problem I solved today that could save a lot of time!

Introduction

Of course it’s Saturday (what else is there to do?!), and there is a little over a week before I present on running a Galera Cluster MySQL on Kubernetes and while trying to record the demo, everything was apparently broken. Here’s the tale of woe in a nutshell.

Initial problem

So, when trying to run my kubernetes cluster, when running the following:

patg@kubernetes-master001:~$ ./kubectl exec pxc-node2-hjjrw -i -t -- mysql -u root -p -h pxc-cluster
Content-Type specified (plain/text) must be 'application/json'

…

And the first two Database Performance Team characters are . . .

The last blog introduced the Database Performance Team. The Database Performance Team is comprised of our services experts, who work tirelessly every day to guarantee the performance of your database. Percona’s services team is made up of superheroes that make sure your database is running at peak performance. Now we’re ready to reveal the identity of the first two team members.

The first is funny, friendly, quick-witted, supporting, fast and courteous – but still able to get the job done with amazing competence. Who is this champion?

…

While being on the committee for the FOSDEM MySQL & friends devroom, I didn’t speak at that devroom (instead I spoke at the distributions devroom). But when I had time to pop in, I did take some notes on sessions that were interesting to me, so here are the notes. I really did enjoy Yoshinori Matsunobu’s session (out of the devroom) on RocksDB and MyRocks and I highly recommend you to watch the video as the notes can’t be very complete without the great explanation available in the slide deck. Anyway there are videos from the MySQL and friends devroom.

MySQL & Friends Devroom MySQL Group Replication or how good theory gets into better …

This blog is an EXPLAIN FORMAT=JSON wrap-up for the series of posts I’ve done in the last few months.

In this series, we’ve discussed everything unique to

EXPLAIN FORMAT=JSON

. I intentionally skipped a description of members such as

table_name

,

access_type

  or

select_id

, which are not unique.

In this series, I only mentioned in passing members that replace information from the

Extra

 column in the regular

EXPLAIN

 output, such as

using_join_buffer

 ,

partitions

,

using_temporary_table

  or simply

After publishing Part 2 of a series on JSON data in MySQL last week, a few folks reached out to me with some great feedback. Not only that, but they shared some resources I thought would be beneficial to pass on.

Morgan Tocker, the Product Manager that works on JSON support in MySQL pointed me toward the MySQL Server Team’s blog, which is more approachable than the docs for topical matters and directed discussion. Specifically he highlighted the JSON category, which has several great posts on everything from using path expressions to ‘upgrading’ json data previously stored in TEXT data columns to JSON data columns. Definitely worth perusing.

…

Sometimes we need to fire trigger like after delete update some fields of another tables for example if you have chatmessage tables and when remove row on this table then we need to update removecounterremovecounter 1 on users table i did give you bellow example you can see how to write t

Sometimes we need to fire trigger like after delete update some fields of another tables for example if you have chatmessage tables and when remove row on this table then we need to update removecounterremovecounter 1 on users table i did give you bellow example you can see how to write t