Ideas, releases, practical guides, and perspectives from the people building with MySQL.
The MySQL Development team is very happy to announce that MySQL 8.0.18 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.18 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
Facebook Twitter LinkedIn
We are happy to announce that for the second time a MySQL meetup is hold in Frankfurt Germany. Please see details below:
More information and registration here.
We are looking forward to meeting & talking to you on Oct 22!
Dear MySQL users,
MySQL Connector/Python 8.0.18 is the latest GA release version of
the
MySQL Connector Python 8.0 series. The X DevAPI enables
application
developers to write code that combines the strengths of the
relational
and document models using a modern, NoSQL-like syntax that does
not
assume previous experience writing traditional SQL.
To learn more about how to write applications using the X DevAPI,
see
http://dev.mysql.com/doc/x-devapi-userguide/en/
For more information about how the X DevAPI is implemented in
MySQL
Connector/Python, and its usage, see
http://dev.mysql.com/doc/dev/connector-python
Please note that the X DevAPI requires at least MySQL Server …
Backups are a very important part of your database operations, as your business must be secured when catastrophe strikes. When that time comes (and it will), your Recovery Point Objective (RPO) and Recovery Time Objective (RTO) should be predefined, as this is how fast you can recover from the incident which occurred.
Most organizations vary their approach to backups, trying to have a combination of server image backups (snapshots), logical and physical backups. These backups are then stored in multiple locations, so as to avoid any local or regional disasters. It also means that the data can be restored in the shortest amount of time, avoiding major downtime which can impact your company's business.
Hosting your database with a cloud provider, such as Microsoft Azure (which we will discuss in this blog), is not an exception, you still need to prepare …
[Read more]With growing development and support costs as well as the need to maintain a sustainable business, it became apparent that maintaining the OSS release of Tungsten Replicator (TR) just wasn’t viable. Earlier this year we decided to close it down, instead focusing our efforts on improving and developing its commercial release whilst also growing our flagship commercial product, Tungsten Clustering.
For many businesses, Open Source Software (OSS) is still a very viable solution in many use cases, and I’m sure it will continue to be so for a long time, but I wanted to explore whether an OSS solution really is as free as the $0 price tag suggests. In this blog I explore just that..
The hidden costs of OSS
Over the last few weeks I stumbled …
[Read more]
Dear MySQL users,
MySQL Shell 8.0.18 is a maintenance release of MySQL Shell 8.0
Series (a
component of the MySQL Server). The MySQL Shell is provided
under
Oracle’s dual-license.
MySQL Shell 8.0 is highly recommended for use with MySQL Server
8.0 and
5.7. Please upgrade to MySQL Shell 8.0.18.
MySQL Shell is an interactive JavaScript, Python and SQL
console
interface, supporting development and administration for the
MySQL
Server. It provides APIs implemented in JavaScript and Python
that
enable you to work with MySQL InnoDB cluster and use MySQL as a
document
store.
The AdminAPI enables you to work with MySQL InnoDB cluster,
providing an
integrated solution for high availability and scalability using
InnoDB
based MySQL databases, without requiring advanced MySQL
expertise. For
more information about how to …
In this tutorial, we will show you how to install LAMP Stack on a Debian 9 VPS. A LAMP (Linux, ...
The post How to Install LAMP (Linux, Apache, MySQL, PHP) on Debian 9 appeared first on RoseHosting.
As presented at the Percona Live Conference in Austin in May, at Alibaba we are working on adding support for parallel query execution to POLARDB for MySQL. As discussed in the presentation, we observe that parallel range scans on secondary indexes does not scale very well in MySQL. This is old news. Mark Callaghan reported this several years ago, and this does not seem to have changed. In this blog post, I will investigate what effects using a multi-processor machine have on the scalability of parallel index range scans.
I will run a variant of Query 6 of the TPC-H/ …
[Read more]MySQL InnoDB Cluster is the most easy and integrated High Availability solution for MySQL.
The solution is composed of:
All those components are developed and tested together to provide the easiest and best experience to the MySQL users.
As the MySQL Router is a TCP Level 4 router (like HA Proxy), some users requiring a more “intelligent” proxy having other extra features like caching, read/write splitting in relation with the user or SQL, firewall, … may be interested in using ProxySQL… and this is a good choice !
ProxySQL / MySQL Router in OSI Model
However, even is ProxySQL supports MysQL Group Replication, for …
[Read more]
MySQL InnoDB Cluster is easy to configure and deploy. This
article is written to provide 3 group replication parameter
settings which may contribute to the stability and reliability of
the Network in MySQL InnoDB Cluster.
With MySQL 8.0, there are at least 3 most important parameters in
Network Reliability Settings.
1.
group_replication_member_expel_timeout
2. group_replication_autorejoin_tries 3. …