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 …
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 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]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-Eng...
Dual-password capability makes it possible to seamlessly perform credential changes without downtime.
The post MySQL Security - Dual Password Support first appeared on dasini.net - Diary of a MySQL expert.
ProxySQL is proud to 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
group_concat_max_len
#2709 - Do not compile if
GIT_VERSION
is 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 […]
The post Dynamic Image Gallery Using PHP 7 & MySQLi appeared first on Phpflow.com.