What CoIsland watches in MySQL

Each monitor kind brings its own query and its own card in the notch.

How to monitor MySQL from your Mac’s notch

A CoIsland monitor runs a query on its own schedule and opens the notch only when the answer changes: a new row, or a count crossing a line.

-- name: Negative amounts
-- kind: mysql.custom-sql
-- connector: shop
-- every: 15m

SELECT *
FROM shop.orders
WHERE amount < 0

Connect MySQL covers every field, TLS and each error. PostgreSQL works the same way; all connectors share one page.

Connect it in three steps

  1. Get a host, a user and a password from your server or your provider's Connect page. A user with SELECT only is safest.

  2. Add a MySQL connector. Test connector says who you are, the server's version and how the connection is encrypted.

  3. Pick Custom SQL, Validation or an example: each checks every 15 minutes unless you change it.

Built for MySQL

  • Every check runs in START TRANSACTION READ ONLY and is rolled back; a second statement or INTO OUTFILE is refused before it is sent.
  • TLS is on and the certificate verified by default, by macOS.
  • The password stays in the macOS Keychain and goes only to your server.
  • MariaDB works too, with its default sign-in.

Then hand it to an agent

A click on the alert opens the agent in a terminal under it, with the whole alert as its first message.

MySQL questions

Can CoIsland change anything in my database?

No. Only SELECT, WITH or SHOW is accepted, one statement at a time, inside a read-only transaction that is rolled back. Writing a file with INTO OUTFILE is refused before anything is sent.

Does it work with PlanetScale or Amazon RDS?

Yes. PlanetScale's certificate is verified by default. RDS and Cloud SQL sign theirs with their own authority: choose Encrypted, server not verified, or trust their root certificate in Keychain Access.

Which sign-in methods work?

caching_sha2_password (MySQL's default) and mysql_native_password (MariaDB's). The full password is only ever sent over TLS.

Other connectors

Put your work stack in the notch

Regular price: $59.99 Early bird price: $19.99 once, for 2 Macs. Native for Apple Silicon, macOS 14 and later.

Early bird price until October 25