This use case of a global SaaS provider looks at how our customer migrated from Amazon RDS to a truly global, geo-distributed multi-master Tungsten Clustering solution.
Apr
22
2020
Apr
21
2020
In this two-part blog series, I wanted to cover some failover scenarios with Group Replication. In part one, I will discuss an interesting behavior and performance degradation I discovered while writing these posts. In part two, I will show several failover scenarios and demonstrate how Group Replication handles each situation.
The test environment is very basic, a three-node Group
Replication (mysql1,mysql2,myslq3) on MySQL 8.0.19 with default
settings. mysql2 is the Primary node.
In this scenario, I was testing a partial network failure when a node gets separated from the primary, but other nodes still can see it.
You would think mysql3 is going to lose quorum and
exit the cluster, but no. Inside the cluster, all the nodes are
in constant communication with each other, not just …
Apr
21
2020
Apache Spark is the de facto framework of the big data world. Any serious organization that’s dealing with big data uses Spark almost exclusively. Though, it has some caveats. For the starter, it’s hard to use. And it’s very confusing to get started with, even for those with a solid …
The post MySQL table to JSON with 10 lines of Spark appeared first on Geeky Hacker.
Apr
21
2020
How to achieve MySQL high availability, data protection & disaster recovery
This MySQL high availability and disaster recovery use case is based on a customer of ours who is a government-regulated lottery service consisting of a number of games of chance. Its mission is to fuel imagination – and fund education for all citizens of their state as it uses the proceeds of its activities to do so. Through its games, it has provided billions of dollars in scholarship and other such education funding for several decades.
What is the Challenge?
As is common for gambling and betting organisations, our customer faced a number of challenges and needed to have a solid infrastructure in place in order to provide its services satisfactorily.
This includes:
- Ensuring 24/7/365 availability of its online gaming platform
- Handling thousands of transactions quickly and while ensuring zero downtime …
Apr
21
2020
This MySQL high availability and disaster recovery use case is based on a customer of ours who is a government-regulated lottery service and who needs 24x7x365 operations as well as be able to perform maintenance without any disruption to their public facing gaming website.
Tags: Disaster Recovery High Availability MySQL use case Zero-Downtime
Apr
21
2020
MySQL provides password-expiration capability, which enables database administrators to require that users reset their password.
The post MySQL Security – Password Expiration Policy first appeared on dasini.net - Diary of a MySQL expert.
Apr
20
2020
Although MySQL is now more than two decades old, it continues to power some of the world’s largest internet applications. In this presentation, we’ll look at the history and evolution of distributed MySQL deployments. We’ll explore the original designs and the common architecture patterns still in use today. Finally, we’ll predict what the future has in store for us with the advent of the cloud and containers as the new operating environments for databases.
Please join Peter Zaitsev on Wednesday, April 29 at 11:00 am EDT for his webinar “Distributed MySQL Architectures – Past, Present, Future”.
If you can’t attend, sign up anyway and …
[Read more]
Apr
20
2020
CVE-2020-10996
Percona XtraDB Cluster versions greater than 5.7.22-29.26 and less than 5.7.28-31.42.1 contained a script that handled SST transfers to nodes, this was inadvertently set to a static value due to an error in the bash script handling this process.
Applicability
Time based access to SST files is required in order to exploit this error, as sst files are ephemeral in nature the window in which an attacker with access to the filesystem can exploit this issue is limited.
In addition to the enablement of innodb at-rest encryption, which is not considered a GA feature at the time of writing.
Credits
Percona would like to thank Pavel Kasko for discovering this issue, and working to aid resolution.
More Information
- CVE-2020-10996
- …
Apr
16
2020
Recently, I got access to the list of MySQL bug reports from bugs.mysql.com which someone crawled and stored in a MySQL database. I thought it would be interesting to see who the heroes are of MySQL bug reporting!
Top MySQL Bug Reporters Ever
select rank() over(order by count(*) desc) my_rank, count(*) cnt, reporter from bugs where reporter != "OCA Admin" and reporter != "[ name withheld ]" group by reporter order by cnt desc limit 20; +---------+------+--------------------+ | my_rank | cnt | reporter | +---------+------+--------------------+ | 1 | 1234 | Shane Bester | | 2 | 869 | Peter Gulutzan | | 3 | 818 | Daniël van Eeden | | 4 | 587 | Joerg Bruehe | | 5 | 572 | Philip Stoev | | 6 | 568 | Peter Laursen | | 7 | 564 | Roel Van de Paar | | 8 | 526 | Guilhem Bichot | | 9 | 524 | Jonathan …[Read more]
Apr
16
2020
Percona XtraDB Cluster 8.0 is in the final stretch before GA release and we have pre-release packages available for testing, and I wanted to see how Percona XtraDB Cluster 8.0 performs in CPU and IO-bound scenarios, like in my previous posts about MySQL Group Replication.
In this blog, I want to evaluate Percona XtraDB Cluster 8.0 scaling capabilities in I/O bound cases when we increase the number of nodes and increase user connections. The version I used is available here: …
[Read more]