We are honored to be ranked as one of the 10 fastest growing AWS solution providers to watch in the year 2018 by The Technology Headlines.
Read about our journey, the host of benefits for our customers, our exceptional team, and future roadmap in this Amazon Special Edition at https://t.co/g9ZcIQ39HL .
phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. phpMyAdmin is a web-based tool that allows you to easily manage MySQL or MariaDB databases. In this tutorial, we will be going to explain how to install and secure phpMyAdmin on Ubuntu 18.04 server.
The MariaDB Foundation is pleased to announce the availability of MariaDB 10.3.11, the latest stable release in the MariaDB 10.3 series, as well as MariaDB Connector/C 3.0.7 and MariaDB Connector/ODBC 3.0.7, both stable releases, and MariaDB Connector/Node.js 2.0.1, the first beta release of the new 100% JavaScript non-blocking MariaDB client for Node.js, compatible with Node.js […]
The post MariaDB 10.3.11, and MariaDB Connector/C 3.0.7, Connector/ODBC 3.0.7 and Connector/Node.js 2.0.1 now available appeared first on MariaDB.org.
Just a friendly reminder for another two shows where you can find MySQL team at this week.
Feira do Conhecimento Brazil is a unique event with more than 10.000 attendees. There will be about 200 exhibitors on 9000m2 of expo space presenting technological solutions to improve key areas for society such as health, education, cities, agriculture, water resources, renewable energies, inclusion and diversity. The show will bring together academia, business, government and community to show how science and technology can help reduce inequalities. We are happy to be part of this show with our talk and MySQL representative!
Today I read the nice post of Bhuvanesh on
the memory leak issue they experienced with MySQL. In fact when
you read the post, you realize that MySQL was just following the
parameters that were setup (the default of max_prepare_stmt_count is 16382
even on 5.6).
I’m still convinced that the problem should be resolved in the application even if the use of ProxySQL for multiplexing is great.
In MySQL 8.0, we have enabled the …
[Read more]
This is review of TRIAD which was published in USENIX ATC 2017. It explains
how to reduce write amplification for RocksDB leveled compaction
although the ideas are useful for many LSM implementations. I
share a review here because the paper has good ideas. It isn't
easy to keep up with all of the LSM research, even when limiting
the search to papers that reference RocksDB, and I didn't
notice this paper until recently.
TRIAD reduces write amplification for an LSM with leveled
compaction and with a variety of workloads gets up to 193% more
throughput, up to 4X less write amplification and spends up to
77% less time doing compaction and flush. Per the …
I am currently working my way through the many PHP Frameworks to
see how they get on with MySQL 8. The Frameworks that can
take advantage of the MySQL Improved Extension or mysqli
can take advantage of the SHA256 Caching Authentication method.
But those that are PDO based need to use the older MySQL Native
Authentication method.
I wanted to check the PDO based frameworks and today I just
happened to be wearing the very nice Symfony shirt I received as
part of my presentation at Symfony USA. So I started with a
fresh install of Symfony. All was going well until it came
time to get it to work with MySQL 8 through Doctrine.
Doctrine
Symfony uses Doctrine as an ORM (Object Relational Mapper)
and DBAL (Database Abstraction Layer) as an
intermediary to the database. While I myself am not a big
fan of ORMs …
In the latest alpha release of React, a new concept was introduced, it is called Hooks. Hooks were introduced to React to solve many problems as explained in the introduction to Hooks session however, it primarily serves as an alternative for classes. With Hooks, we can create functional components that uses state and lifecycle methods.
Related Reading:
Hooks are relatively new, as matter of fact, it is still a feature proposal. However, it is available for use at …
[Read more]In this Checklist for Success series, we will discuss reducing unknowns when hosting in the cloud using and migrating to Amazon Aurora. These tips might also apply to other database as a service (DBaaS) offerings.
Previous blogs in the migrating to Amazon Aurora series:
The whole premise of a database as a service offering is that you do not need to worry about the operating the service, you just …
[Read more]Design A Highly Available MySQL Clusters With Orchestrator And ProxySQL In GCP — Part 2
In part1, we explained how we are going to approach the HA setup. Here we can see how to install and configure Orchestrator and ProxySQL, then do the failover testing.
Install and configure MySQL Replication:
We need a MySQL with 4 Read replica and the 4'th replica will have a replica for it. And we must have to use GTID replication. Because once the master failover done, the remaining replicas will start replicating from the new master. Without GTID its not possible, but as an alternate Orchestrator provides Pseudo-GTID.
VM Details: …
[Read more]