Percona is glad to announce the release of Percona XtraDB Cluster 5.6.45-28.36 on September 17, 2019. Binaries are available from the downloads section or from our software repositories.
Percona XtraDB Cluster 5.6.45-28.36 is now the current release, based on the following:
All Percona software is open-source and free.
Bugs Fixed
Is “that” time of the year … when autumn is just around the
corner and temperature start to drop.
But is also the time for many exciting conferences in the MySQL
world.
We have the Oracle Open world this week, and many interesting
talks around MySQL 8.
Then in 2 weeks we will be at the Percona live Europe in
Amsterdam, which is not a MySQL (only) conference anymore
(https://www.cvent.com/events/percona-live-open-source-database-conference-europe-2019/agenda-6321c2468b1b43328f97212f3e53f4de.aspx).
Percona had move to a more “polyglot” approach not only in its
services but also during the events.
This is obviously an interesting experiment, that allow people
from different technologies to meet and discuss. At the end of
the day it is a quite unique …
We (Codership, the original and continued developers and experts of Galera Cluster) participated in Austin 2019, and so it would have seemed remiss if we did not also show up at the Percona Live Open Source Database Conference Europe 2019 (that was a mouthful!) happening in Amsterdam September 30 – October 2 2019. We have a booth in the expo hall at the Hilton Amsterdam Schipol Airport, so come drop by and say hello!
While we do not have any talks accepted in the main program, we do have a tutorial that involves using Galera Cluster and MariaDB Server on the first day at 9am by Colin Charles. View the whole …
[Read more]Mysql và Sql server hiện có thể được xem là 2 giải pháp RDBMS phổ biến nhất. Cả 2 gần như tương tự nhau bởi có cùng chức năng, gốc SQL. Tuy nhiên, vẫn có nhiều sự khác biệt giữa Mysql và Sql server. Điều đó cũng gây nên sự phân vân cho người dùng nếu không hiểu về từng giải pháp. Hãy cùng chúng tôi tìm hiểu rõ hơn sự khác biệt giữa hai cơ sở dữ liệu mã nguồn qua những chia sẻ dưới đây nhé!
1. MySQL và SQL Server là gì?
Trước hết, để phân biệt được sự khác nhau giữa 2 giải pháp Mysql và Sql server, chúng ta sẽ cùng tìm hiểu về khái niệm của từng giải pháp nhé!
Mysql và Sql server đều là một hệ quản lý cơ sở dữ liệu mã nguồn mở rất phổ biến bởi độ tin cậy cao.MySQL:
Mysql …
[Read more]Drupal is a Content Management System (CMS) designed to create everything from tiny to large corporate websites. Over 1,000,000 websites run on Drupal and it is used to make many of the websites and applications you use every day (including this one). Drupal has a great set of standard features such as easy content authoring, reliable performance, and excellent security. What sets Drupal apart is its flexibility as modularity is one of its core principles.
Drupal is also a great choice for creating integrated digital frameworks. You can extend it with the thousands of add-ons available. These modules expand Drupal's functionality. Themes let you customize your content's presentation and distributions (Drupal bundles) are bundles which you can use as starter-kits. You can use all these functionalities to mix and match to enhance Drupal's core abilities or to integrate Drupal with …
[Read more]I posted a few days ago some initial thoughts on the the MySQL native cloning functionality. Overall this looks good and I need to spend time to test further. I’m here in San Francisco ahead of Oracle Open World which starts today. As is usual with trips like this jet lag wakes you up rather … Continue reading MySQL Cloning: more thoughts
The post MySQL Cloning: more thoughts first appeared on Simon J Mudd's Blog.
Please find below the conferences & shows where you can find MySQL Community team and/or MySQL experts during this week:
Oracle Open World / MySQL Reception, San Francisco, US, September 16-19, 2019
Six years ago I wrote a common lookup post to illustrate the effectiveness of things used throughout your applications. Now, I’m updating my student image with a more complete solution to show how to avoid update anomalies.
In the prior post, I used a while loop in PHP, like
the following:
do {
...
} while($stmt->next_result());
Using PHP Version 7.3.8 and MySQL 8.0.16, that now raises the following error message:
Strict Standards: mysqli_stmt::next_result(): There is no next result set. Please, call mysqli_stmt_more_results()/mysqli_stmt::more_results() to check whether to call this function/method in /var/www/html/app/library.inc on line 81
You can see this type of error when you set the following parameters in your file during testing:
ini_set('display_errors',1); …[Read more]
Somebody didn’t like the MySQLi Update Query example on the tutorialspoint.com website because it use the
procedure mysqli_query style. Here’s a simple
example of using the object-oriented method version. More or
less, instead of query it uses the more intuitive
execute() method.
The update_member function contains the logic and
below it is a call to the test the function. It relies on a
MySQLCredentials.inc file that contains the
hostname, user name, password, and database name. You can create
create member table, like my example in MySQL 8, or
any other table in your MySQL database.
<?php /* || Function Name: update_member */ function update_member($account_number, $member_type, …[Read more]
Percona announces the release of Percona Toolkit 3.1.0 on September 13, 2019.
Percona Toolkit is a collection of advanced open-source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB®, PostgreSQL® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, Percona Toolkit supports Percona Server for MySQL, MySQL, MariaDB, PostgreSQL, Percona Server for MongoDB, and MongoDB.
Percona Toolkit, like all Percona software, is free and open source. You can download packages …
[Read more]