Category: MySQL & MariaDB

Feed: SingleStore Blog. Author: . In this guide, we'll show you how to get up and running with Laravel and SingleStoreDB in a matter of minutes. You can view the full example repository at github.com/singlestore-labs/start-with-laravel or follow along here.If your machine is not already set up with Composer, we recommend reading their getting started documentation. You may also consult Laravel's getting started documentation.To get started, create a fresh Laravel project.# Create a new Laravel project. composer create-project laravel/laravel singlestoredb-example cd singlestoredb-example Then require the SingleStoreDB database driver for Laravel.# Require the SingleStoreDB driver for Laravel. composer require singlestoredb/singlestoredb-laravel Now we ... Read More

Feed: Recent Announcements. AWS Database Migration Service (AWS DMS) now supports IBM Db2 z/OS as a source for the full load operational mode. Using AWS Schema Conversion Tool (SCT), you can convert schemas and code objects from IBM DB2 z/OS to Aurora MySQL, Aurora PostgreSQL, MySQL and PostgreSQL targets. Once you have the schema and objects in a format compatible with target database you can utilize AWS DMS to migrate data from IBM DB2 running on the z/OS operating system to any AWS DMS supported targets ... Read More

Feed: SingleStore Blog. Author: . The global Postgres community boasts tens of thousands of users and several thousand enterprises. That must say something good about the technology, right? Postgres has become very attractive to developers, thanks to benefits like its strong support for transactions, ability to handle JSON natively and ecosystem extensibility. Moreover, the database is widely adopted — given that it is open source and available as an option on popular services like AWS RDS. SaaS applications like Instagram, FlightAware and Reddit even use Postgres. Postgres developers looooooooove Postgres, so much so that it’s the #4 database on TrustRadius and on ... Read More

Feed: Planet MySQL; Author: Alena Subotina; This article explains how to install and configure the ODBC Driver Manager on Windows, macOS, and Linux. Also, it shows how to configure the ODBC data source name. Contents What is an ODBC Driver Manager? To explain what this driver manager is, take a look at the ODBC architecture in Figure 1. Figure 1. ODBC architecture. The ODBC driver manager manages communication between apps and ODBC drivers. To put it simply, this is what happens when your application starts connecting to your database: First, the app connects to a certain database using a connection string or ... Read More

Feed: Planet MySQL; Author: Dave Stokes;  Yes, SCaLE, or the Southern California Linux Expo is back. Friday is the MySQL track with eight presentations. A big thanks to all the presenters and we hope to see you at the LAX Hilton July 29th!MySQL 8.0 New FeaturesDave StokesAudience:EveryoneTopic:MySQLMySQL now features quarterly releases that come with new features.  So if you do not know about hash joins, replica set, JSON document validation, or other new features then you need to be in this presentation.!Room:CarmelTime:Friday, July 29, 2022 - 10:00 to 11:00State of MySQL Security in 2022Alexander RubinAudience:DeveloperTopic:MySQLIn this talk we will look ... Read More

Feed: Planet MySQL; Author: Kyle Hailey; Sure, wait event times in any database will include some CPU time, though ideally it should be minimal. Waits should be instrumented as close to the off CPU wait event as possible, i.e. if I’m doing an IO, then I want the wait to cover just the read call: start_wait('my_read_wait'); pread( ... ); end_wait('my_read_wait'); So my function that sets up the read will do some CPU that could get caught under the cover of the wait itself and the call to pread will use some CPU but most of the time should be ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; When performing physical backup on system that are heavily used, it can happen that the backup speed cannot keep up with the redo log generation. This can happen when the backup storage is slower than the redo log storage media and this can lead in inconsistency in the generated backup. MySQL Enterprise Backup (aka MEB) and probably Percona Xtrabackup, benefit from the possibility to sequentially write redo log records to an archive file in addition to the redo log files. This feature was introduced in MySQL 8.0.17. How to enable it ? To enable ... Read More

Feed: Planet MySQL; Author: Vitess; We are pleased to announce the general availability of Vitess 14.In this new release, major improvements have been made in several areas of Vitess, including usability and reliability.Online DDL is now GA.Gen4 planner is the new default planner.VTAdmin and VTOrc are officially in beta with Vitess 14.Command-Line Syntax Deprecation This release marks the beginning of Vitess standardizing its command-line and flags syntax. Some former syntaxes have been deprecated and will break in the next release. For details, as well as migration instructions, please refer to the release notes.VtctldServer and Client The new gRPC API for ... Read More

Feed: Database Journal. Author: James Payne. There are many ways for a database administrator to learn how to use a database programming language, including a book or tutorial, such as the one you are reading now. Some people prefer that method and everyone learns differently. If you are the type of student that learns more in a classroom type of environment – and you want to learn MySQL as part of your database administrator or database developer training – we suggest you consider our list of the top online MySQL courses, as detailed in the sections below. Best MySQL Courses ... Read More

Feed: Recent Announcements. Amazon RDS now allows you to have up to 20 concurrent snapshot copy requests per destination region per account, an increase from the former limit of five concurrent copies per destination region per account. The new limit applies to snapshots of Microsoft SQL Server, Oracle engines, Amazon RDS for PostgreSQL, Amazon RDS for MySQL, and Amazon RDS for MariaDB engines in AWS Regions where Amazon RDS is available. This feature has been enabled on your account and no further action is needed from you. For more information on copying RDS snapshots, please refer to the documentation guide ... Read More