A good news for all PHP CMS users like Drupal and Joomla!, PHP 7.2.8 (available on Remi’s repo for those using rpms) supports the
new MySQL 8.0 default authentication plugin
‘caching_sha2_password‘ !
So, I’ve installed PHP 7.2.8:
And I’ve my user (here joomla) uses the …
[Read more]As other CMS using MySQL and PHP, Joomla! is not yet 100% ready to work with MySQL 8.0 out of the box.
I’ve been contacted by Brian Teeman to give my opinion and some tips… so here is the blog post
@lefred If you could offer some advice on this #joomla #mysql 8 issue it would be appreciated https://t.co/FS37GVunEO
— ((( Brian Teeman ))) (@brianteeman) …
[Read more]
The Performance Schema and sys schema are great for
investigating what is going on in MySQL including investigating
performance issues. In my work in MySQL Support, I have a several
times heard questions whether a peak in the InnoDB Data File
I/O – Latency graph in MySQL Enterprise Monitor (MEM) or
some values from the corresponding tables and view in the
Performance Schema and sys schema are cause for
concern. This blog will discuss what these observations means and
how to use them.
The Tables and Views Involved
…
[Read more]The MariaDB Foundation is pleased to announce the availability of MariaDB Galera Cluster 5.5.61 as well as MariaDB Connector/C 3.0.6 and MariaDB Connector/ODBC 3.0.6 all stable releases. See the release notes and changelogs for details. Download MariaDB Galera Cluster 5.5.61 Release Notes Changelog What is MariaDB Galera Cluster? Download MariaDB Connector/C 3.0.6 Release Notes Changelog […]
The post MariaDB Galera Cluster 5.5.61, MariaDB Connector/C 3.0.6 and MariaDB Connector/ODBC 3.0.6 now available appeared first on MariaDB.org.
From driver and rider locations and destinations, to restaurant orders and payment transactions, every interaction on Uber’s transportation platform is driven by data. Data powers Uber’s global marketplace, enabling more reliable and seamless user experiences across our products for riders, …
The post Databook: Turning Big Data into Knowledge with Metadata at Uber appeared first on Uber Engineering Blog.
Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.
Don’t wait, submit a talk for Percona Live Europe 2018 to be held in Frankfurt 5-7 November 2018. The call for proposals is ending soon, there is a committee being created, and it is a great conference to speak at, with a new city to boot!
Releases
Did you know that Continuent Clustering supports having clusters at multiple sites world-wide with either active-active or active-passive replication meshing them together?
Not only that, but we support a flexible hybrid model that allows for a blended architecture using any combination of node types. So mix-and-match your highly available database layer on bare metal, Amazon Web Services (AWS), Azure, Google Cloud, VMware, etc.
In this article we will discuss using the Active/Passive model to scale reads worldwide.
The model is simple: select one site as the Primary where all writes will happen. The rest of the sites will pull events as quickly as possible over the WAN and make the data available to all local clients. This means your application gets the best of both worlds:
I studied some macroeconomics in school. I’m still interested in it 20 years hence. I was recently in a discussion about query optimization and how to prioritize what to fix first. My pen and paper started graphing things, and here we are with an abstract thought. Bear with me. This is for entertainment purposes, mostly, but may actually have a small amount of value in your thought processes around optimizing queries. This is a riff on various supply, demand graphs from macroeconomics.
In the graph below:
The world of application and its related services are migrating more towards cloud, because of availability, Elasticity, Manageability etc. While moving the entire stack we need to be very cautious while migrating the database part.
Migration of DB servers is not a simple lift and shift operation, Rather it would require a proper planning and more cautious in maintaining data consistency with existing DB server and cloud server by means of native replication or by using any third party tools.
The best way to migrate the existing MySQL database to RDS, in my opinion, is by using “logical backup“. Some of the logical backup tools as below,
Mysqldump — single threaded (widely
used)
…
In this post, I provide an illustration of how to use Pentaho Data Integration (PDI) tool to set up external dictionaries in MySQL to support ClickHouse. Although I use MySQL in this example, you can use any PDI supported source.
ClickHouse
ClickHouse is an open-source column-oriented DBMS (columnar database management system) for online analytical processing. Source: wiki.
Pentaho Data Integration
Information from the Pentaho wiki: Pentaho Data Integration (PDI, also called Kettle) is the component of Pentaho responsible for the Extract, Transform and Load (ETL) processes. Though ETL tools are most frequently used in data warehouses environments, PDI can also be used for other purposes: