Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

Connect with Laravel

You can connect Laravel to SingleStore using the SingleStore Driver for Laravel ("the driver"). Refer to the SingleStore Driver for Laravel Github repository for its source code and related information.

Prerequisites

  • Install PDO_MYSQL.

  • Install the driver via composer:

    composer require singlestoredb/singlestoredb-laravel

Connect to SingleStore

To connect Laravel to SingleStore, enable the driver and configure the connection.

To enable the driver, edit your config/database.php file and create a new entry for SingleStore in the connection configuration. Update the default option to point to the new connection or set DB_CONNECTION=singlestore in your environment file.

Here's a sample configuration:

use Pdo\Mysql;
[
'default' => env('DB_CONNECTION', 'singlestore'),
'connections' => [
'singlestore' => [
'driver' => 'singlestore',
'url' => env('DATABASE_URL'),
'host' => env('DB_HOST'),
'port' => env('DB_PORT'),
'database' => env('DB_DATABASE'),
'username' => env('DB_USERNAME'),
'password' => env('DB_PASSWORD'),
'unix_socket' => env('DB_SOCKET'),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'prefix_indexes' => true,
'strict' => true,
'engine' => null,
'options' => extension_loaded('pdo_mysql') ? array_filter([
Mysql::ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
Mysql::ATTR_EMULATE_PREPARES => true,
Mysql::ATTR_PERSISTENT => true
]) : [],
],
]
]

The SingleStore driver is an extension of the MySQL driver, so you can also use the driver from mysql.

Connect using SSL

To configure SSL connections between SingleStore Helios and Laravel, download the singlestore_bundle.pem certificate file and update your MYSQL_ATTR_SSL_CA environment variable to point to it. Set Mysql::ATTR_SSL_VERIFY_SERVER_CERT to "true", as follows:

'options' => extension_loaded('pdo_mysql') ? array_filter([
Mysql::ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
Mysql::ATTR_SSL_VERIFY_SERVER_CERT => true,
Mysql::ATTR_EMULATE_PREPARES => true,
Mysql::ATTR_PERSISTENT => true
]) : [],

For more details, refer to the SingleStore Driver for Laravel and Laravel docs.

Last modified:

Was this article helpful?