mysql

Node.js: Connecting to MySQL on a socket with Sequelize

Linux, Mac, Software development, Web Applications /

According to its official description, “Sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server.” Sequelize is widely used in Node.js web applications to abstract the database layer. I recently found a “corner case” for Sequelize which is possible to accomplish, but is not well documented anywhere on the web. […]

Node.js: Connecting to MySQL on a socket with Sequelize Read More »

MySQL replication fails with WSREP error after restart

Enterprise IT, Linux /

Scenario A single Percona MySQL 5.7 server replicates asynchronously with a cluster of Percona MySQL 5.7 servers. After rebooting the single server, replication failed with the following symptoms: mysql> show slave status \G**************************** 1. row ************** Slave_IO_State: Waiting to reconnect after a failed registration on master Master_Host: my-replication-partner Master_User: repl Master_Port: 3306 Connect_Retry: 60 Master_Log_File:

MySQL replication fails with WSREP error after restart Read More »

Configuring Laravel/Lumen applications to connect to SQL database sockets

Software development, Web Applications /

The Laravel/Lumen framework documentation does not explain how to connect an application to a database using UNIX sockets instead of a TCP-based network connection. I recently had to configure the Polr URL shortener (built on the Lumen microframework by Laravel) to connect to Google Cloud SQL with a UNIX socket. Since all of Polr’s configuration takes place

Configuring Laravel/Lumen applications to connect to SQL database sockets Read More »