Watch the replay of this Zero Downtime MySQL use case webinar with Continuent CEO Eero Teerikorpi and find out how Kentucky Lottery achieved continuous MySQL operations with high availability, data protection, and disaster recovery using a Composite Active/Passive Tungsten Clustering Topology.
Tags: Webinar MySQL use case tungsten clustering mysql cluster continuous mysql operations …
[Read more]This is a topic that overall you never should have to do... Why? Because you created backups right... You have tested and know the backups work so you can just restore those backups and get your lost schema and related data...
However that one instance in the corner office.. you never got around to setting up.. it not that important... just crashed and now you realize how you actually do use it...
All is not lost..
MySQL released their MySQL utilities awhile back and since been replaced more with the MySQL Shell.
mysqlfrm is still very handy though when needing to pull out the schema from an …
[Read more]Here at Pythian we like to pay attention to what brings people to our site, and one of the main queries we’ve been seeing is “How can I allow a remote MySQL database connection?” Since our mission is to help you love your data, we asked Matthias Crauwels, Lead Database Consultant on one of Pythian’s MySQL teams to address this topic. Over to Matthias!
I’m hoping this may be the start of a series of posts where I can share some common MySQL knowledge in a (hopefully) clear and understandable manner. So let’s get started.
Technical requirements
Historically MySQL allows a client to connect in two different ways. You can either use a local socket solution (on a Linux/Unix system this is called a Unix socket, whereas on Windows systems it’s a named pipe) or via a TCP connection to a listening port (by default 3306).
Since the introduction of MySQL 8.0, a third way is also available using a newer …
[Read more]
MySQL Ndb Cluster provides durability for data by default via
logging and checkpointing.
In addition, users can take backups at any time, which allows for
disaster recovery, replication synchronisation, data portability
and other use cases.
This post looks at the backup and restore mechanisms in MySQL Ndb
Cluster.
MySQL Ndb Cluster architecture recap
MySQL Ndb Cluster is a distributed SQL relational database :
Rolling sum and average query results are possible by combining
the aggregate functions SUM() or AVG()
with the OVER() clause, making for powerful analytic
queries. I recently learned how to compute a rolling
average or sum of values by using the Windowing option
of the OVER() clause, applying the concepts to a
data set I am familiar with. I wanted to share my learning with
any readers who might be interested…
Image by Steve Buissinne from …
[Read more]Percona Server for MySQL 8.0 offers a number of clustering solutions for high availability out-of-the-box:
Single-master:
The most popular, battle-tested, and highly scalable solution is, of course, asynchronous replication. In this blog post, we are going to deploy a Percona Server replication setup specifically for high availability. The instructions described here are based on CentOS 7.
Installing Percona Server
For high availability, we need at least two nodes …
[Read more]Presentation of some of the new features of MySQL 8.0.22 released on October 19th, 2020.
The post MySQL 8.0.22 New Features Summary first appeared on dasini.net - Diary of a MySQL experts.
We would like to return to the regular announcements about where you can find MySQL Community team or MySQL experts at during Nov-Dec 2020. All the shows we are attending by end of this year are mostly VIRTUAL ones. Please find more details below:
November, 2020:
GSCC2020/Virtual, November 14, 2020, @5:00-6:00pm
We would like to return to the regular announcements about where you can find MySQL Community team or MySQL experts at during Nov-Dec 2020. All the shows we are attending by end of this year are mostly VIRTUAL ones. Please find more details below: November, 2020: GSCC2020/Virtual, November 14, 2020,...
The relational database of choice at Yelp is MySQL and it powers much of the Yelp app and yelp.com. MySQL does not include a native high-availability solution for the replacement of a primary server, which is a single point of failure. This is a tradeoff of its dedication to ensuring consistency. Replacing a primary server is sometimes necessary due to planned or unplanned events, like an operating system upgrade, a database crash or hardware failure. This requires pausing data modifications to the database while the server is restarted or replaced and can mean minutes of downtime. Pausing data modifications means...
