(Hardik Savani) We will learn how to use if condition in laravel select query. we can use mysql case when statement with db raw in laravel.
Tag: Open Source
(Jesper Krogh) The sys schema was created to make it easier to use the Performance Schema. This included several functions, for example to convert the picoseconds used by the Performance Schema into human readable strings.
(Rafa Alvarez) There are already many tools for MySQL to perform backups and consistent restores, but this time I’d like to elaborate on how to take advantage of the kindness the cloud, which gives us Persistent Disk Snapshots (PSD) to restore our data set in a consistent way.
(Shinguz) Some applications have the bad behaviour to CREATE or DROP tables while our FromDual Backup Manager (bman) backup is running.
(Krzysztof Ksiazek) Database migrations don’t scale well. Typically you need to perform a great deal of tests before you can pull the trigger and switch from old to new. Migrations are usually done manually, as most of the process does not lend itself to automation.
(Ricardo Ferreira) With the release of version 8.0.16 of MySQL, we’ve added some features to the Group Replication (GR) plugin, in order to enhance its high-availability capacities.
Understanding Cross-Site Replication in a Tungsten Composite Multi-Master Cluster for MySQL, MariaDB and Percona Server
(Eric M. Stone) In this blog post we will discuss how the managed cross-site replication streams work in a Composite Multi-Master Tungsten Cluster for MySQL, MariaDB and Percona Server.
(Tomer Shay) I recently stumbled upon a very interesting post by Lukas Eder, where he describes 10 query transformations which do not depend on the database’s cost model.
(Waseem Akram) In this blog, we will see how to do a flashback recovery or rolling back the data in MariaDB, MySQL and Percona.
(Eric M. Stone) Recently, a customer asked us: Why would Tungsten Replicator be slow to apply to MySQL?