Percona is glad to announce the release of Percona XtraDB Cluster 5.7.24-31.33 (PXC) on January 4, 2019. Binaries are available from the downloads section or from our software repositories.
Percona XtraDB Cluster 5.7.24-31.33 is now the current release, based on the following:
Deprecated
The following variables are deprecated starting from this release:
…Recently, I encountered a situation where MySQL gave error messages that I had never seen before:
2018-12-12T14:36:45.571440Z 0 [ERROR] Error log throttle: 150 'Can't create thread to handle new connection' error(s) suppressed 2018-12-12T14:36:45.571456Z 0 [ERROR] Can't create thread to handle new connection(errno= 11) 2018-12-12T14:37:47.748575Z 0 [ERROR] Error log throttle: 940 'Can't create thread to handle new connection' error(s) suppressed 2018-12-12T14:37:47.748595Z 0 [ERROR] Can't create thread to handle new connection(errno= 11)
I was thinking maybe we hit some
ulimit
limitations or similar, but all the usual suspects were set high enough, and we were not even close to them.
After googling and discussing with the customer, I found they had had similar issues in the past, and I learned something new. Actually it is relatively new, as it has been around for a few years but is not that well known. It is …
[Read more]This is my first post in 2019, and Im starting with a MySQL solution. In MySQL world, implementing a better backup strategy to meet all of your requirement is still a challenging thing. The complexity depends on your RPO and RTO. Percona has many tools to help DBAs in many scenarios. Xtrabackup is one of …
The post Automation Script For Percona Xtrabackup FULL/Incremental appeared first on SQLgossip.
Image Source: DigitalOcean
This is my first post in 2019, and Im starting with a MySQL
solution. In MySQL world, implementing a better backup strategy
to meet all of your requirement is still a challenging thing. The
complexity depends on your RPO and RTO. Percona has many tools to
help DBAs in many
scenarios. [Xtrabackup](https://www.percona.com/software/mysql-database/percona-xtrabackup) is
one of the best backup tools to perform a better backup on
TeraBytes size of databases. Also, another great feature is it
supports Incremental and Differential backup.
There are couple of tools which is available in MySQL world, But due to some restrictions we can’t achieve what we are expecting.
#1 mysqldump
This is a widely used backup tool and most of the DBAs are trust this. This comes with …
[Read more]I have already explained about Express.js tutorial and creating simple app with it. As promised in that post i thought to come up with another Express.js tutorial with MySQL. But again, explaining just the concept about library is not enough and this is not even why codeforgeek exits. So i thought to come up with […]
While managing multi servers in a single place, we need a secure authentication method which includes SSH Keys, Passwords and etc. RunDeck is having a great feature called Key Storage. RunDeck Key Storage is a secure and encrypted place for storing confidential contents. Its using HashiCorp Vault for this. Its already enabled by default. So …
The post RunDeck Series 5 – Encrypt Key Files And Passwords In RunDeck appeared first on SQLgossip.
While managing multi servers in a single place, we need a secure authentication method which includes SSH Keys, Passwords and etc. RunDeck is having a great feature called Key Storage. RunDeck Key Storage is a secure and encrypted place for storing confidential contents. Its using HashiCorp Vault for this. Its already enabled by default. So we just upload our keys and creating encrypted passwords.
Encrypting PEM Files:
Then you can select that you want to store Key files or Password.
In this blog we are going to see how to implement Proxysql for Amazon Aurora RDS, this would be next in series of ProxySQL blogs. Below is the list of our previous blogs on ProxySQL which provides deeper insights based on different use cases and different architecture.
With most, if not all of 2018 behind us (depending on when you are reading this post), there is no doubt that it was a fantastic year for open-source SQL databases.
PostgreSQL 11 and MySQL 8 were both released, providing both communities with plenty to 'talk about'. Truth be told, both vendors have introduced many significant changes and additions in their respective releases and deserve their praise and accolades.
I normally guest post about the former here on the Severalnines blog (Many thanks to a great organization!) but I also have an interest in the latter. With many blog posts on my own website (link in my bio section), mostly targeting MySQL version 5.7, it (MySQL) is always in my peripherals.
So what does MySQL 8 have that version 5.7 does not have? What are the improvements? Well, there are many. In fact, too many to …
[Read more]I stopped freelancing on upwork in 2011. I used to be a part-time freelancer on upwork (previously known as oDesk) from 2008 to 2011 besides my full-time job. Since 2011, I have been developing my own Indie mobile apps which is a great success for me and in my career.
I am still earning very good passive income from my own portfolio apps, today I will discuss why I have started freelancing again.
1. Indie Developing
There is a saying:
If you walk alone you can go faster
If you walk in group you can go further