In my interview with Shane Atherholt, Head of ISVs at MySQL, I
asked him several questions: What is an ISV? What is a SaaS
application? How are ISVs using MySQL?
We also went over the recent data breaches and new government regulations. I asked how MySQL helps ISVs secure their data and comply with the new regulations. I also asked Shane what were ISV CEOs and CIOs top priorities and why they should consider a relationship with Oracle. In conclusion, we talked about what we should look forward to in the future with MySQL. Watch the interview below.
On May 27th, 2020, Shane Atherholt will hold a webinar focused on SaaS solutions for ISVs where he will go into more in depth detail about the MySQL offering for ISVs and SaaS. He will also cover the many MySQL Enterprise edition features that are designed to help ISVs with their SaaS applications so they can be more …
The purpose of this post if to show how you can automate the creation and pruning of partitioned tables. If you want to read about partitioning I recommend reading our manual.
In short partitioning makes it possible to spread your individual tables across a file system according to the partition rules you specify.
Reasons for partition your tables might be:
- Insert performance, smaller index trees for stable insert throughput.
- Select performance, only read data from selected (aka partitioning pruning) partitions.
- Delete performance, drop partitioning is must quicker than doing range deletes of old data.
Partitioning definitions is part for the CREATE/ALTER table statements, in …
This week MySQL turns 25 - - - on May 23rd to be exact. Join us in celebrating 25 years of great success.
Early on MySQL became the “M” in the LAMP stack that powered the open source revolution. It became and continues to be the most popular open source database. Early this year it earned the DB-Engine award for most popular database.
The most successful applications and websites we all know and use today, such as Twitter, Facebook, Booking but also Uber, Airbnb and many more, started with MySQL, grew up with MySQL and now scale with MySQL.
Over the years it has become the database of choice for many of the most successful open source applications like WordPress, Drupal, Joomla, Magento, and many more.
It has always been ranked the developers’ favorite …[Read more]
Dual-password capability makes it possible to seamlessly perform credential changes without downtime.
ProxySQL is proud announce the fast track release of the latest stable version of ProxySQL 2.0.12 on 18th of May 2020
ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded here or alternatively from the ProxySQL Repository, and freely usable and accessible according to the GNU GPL v3.0 license.
Release Overview Highlights Enhancements
- Added tracking capability for variable
- Do not compile if
GIT_VERSIONis not set #2768
- Several new automated …
Percona has enforced stronger security in Percona XtraDB Cluster (PXC) 8, but this requires some attention during the rollout of the new server version, so let see the why and what.
In PXC there are two different kinds of traffic: client-server exchange (ie: application traffic), and replication traffic. The latter refers to any SST/IST, write-set, and other service messages the nodes exchange.
In PXC 5.7 it is possible to activate SSL encryption by enabling the variable pxc-encrypt-cluster-traffic by following the instructions.
In PXC 8, we choose to enable encryption by default on all replication traffic, to have the highest out-of-box security enforcement.
While this is an obvious …[Read more]
This tutorial help to create dynamic image gallery using PHP and MySQL.The image upload and listing is very common functionality for web application.I have already shared Image Crop Functionality In Model Box Using PHP tutorial. I am extending my previous above tutorial and added image listing and gallery functionality.I have also added view image into […]
During this webinar, Tyler Duzan, Product Manager for MySQL and Cloud at Percona, will discuss Percona’s decision to delay Percona XtraDB Cluster 8.0 to ship it with Galera 4 instead of Galera 3, and why that matters. In addition, he’ll talk about the work done to integrate MySQL 8.0 features with Galera as well as how Percona is treating Kubernetes as one of its primary target platforms with this release. This webinar will provide an overall view of the current state of best-in-breed MySQL clustering as well as the Percona roadmap for the future.
Please join Tyler Duzan of Percona, on Tuesday, May 26 at 11 am EDT for his webinar “What’s New in Percona XtraDB Cluster (PXC) 8.0?”.[Read more]
Percona XtraDB Cluster 8.0 comes with an upgraded Galera 4.0 library, which provides a new feature – streaming replication. Let’s review what it is and when it might be helpful.
Previous versions of Percona XtraDB Cluster with Galera 3.x had a limitation in how big transactions are handled.
Let’s review the performance under sysbench-tpcc workload when in parallel we update a big update on a table that is even non-related to the tables in the primary workload.
Without Streaming Replication
Let’s run two workloads.
- sysbench-tpcc workload with 1 sec resolution
- In parallel run UPDATE oltp.sbtest SET k=k+1 LIMIT 1000000
mysql> update sbtest1 set k=k+1 limit 1000000; Query OK, 1000000 rows affected (34.48 sec) Rows matched: 1000000 …[Read more]