3 ms·
MySQL is actually a really good key value store! Here's the schema we use for the routing information: CREATE TABLE `pages_routes` ( `id` int(11) NO
by charliesome 11y ago
MySQL is actually a really good key value store!
Here's the schema we use for the routing information:
CREATE TABLE `pages_routes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`host` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_pages_routes_on_user_id` (`user_id`)
);
Since we use MySQL for everything else, we decided it made the most sense to keep this routing data here rather than introducing a new database.
- toomuchtodo 11y ago> Since we use MySQL for everything else, we decided it made the most sense to keep this routing data here rather than introducing a new database. Very smart. "Perfection is Achieved Not When There Is Nothing More to Add, But When There Is Nothing Left to Take Away"
- jamesblonde 11y agoDo you run database management software, like severalnines clustercontrol, to manage your MySQL instances?
- MrBuddyCasino 11y agoI was surprised the lookup takes just 3ms. Is Lua pooling the db connections?